Oracle连接出现TNS:no listener或者ORA-12514: TNS:listener does not currently know

 

1、Message 850 not found; No message file for product=network, facility=NL

 提示框:TNS:no listener

解决办法:

重新配置监听程序

点重新配置,一路next……

2、ORA-12514: TNS:listener does not currently know of service requested in connect descriptor:

解决办法:

找到E:appAdministratorproduct11.2.0dbhome_1NETWORKADMIN下的listener.ora,

将原来的用#号注释掉,修改为红框中的(根据安装目录修改)

 然后在服务中

(1)关闭OracleServiceORCL

(2)关闭OracleOraDb11g_home1TNSListener

(3)启动OracleServiceORCL

(4)启动OracleOraDb11g_home1TNSListener

OK

原文地址:https://www.cnblogs.com/Donnnnnn/p/5955336.html