oracle client ORA-12541: TNS: 无监听程序

时间:2023-03-08 16:26:57

1. Question description:

if you are setting the oracle client to add a local network service,  you may see the dialogue that show you the message

(oracle client ORA-12541: TNS: 无监听程序).

2.you can check the listener first, with command (lsnrctl status; lsnrctl start)

oracle client ORA-12541: TNS: 无监听程序

oracle client ORA-12541: TNS: 无监听程序

as the image describe, the listener object is wrong.

3. Solution:

you need to find the .ora file , and modify with the host name.

oracle client ORA-12541: TNS: 无监听程序

oracle client ORA-12541: TNS: 无监听程序

oracle client ORA-12541: TNS: 无监听程序

oracle client ORA-12541: TNS: 无监听程序