首页 > 技术文章 > Oracle连接出现TNS:no listener或者ORA-12514: TNS:listener does not currently know

Donnnnnn 2016-10-13 10:04 原文

 

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:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN下的listener.ora,

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

 然后在服务中

(1)关闭OracleServiceORCL

(2)关闭OracleOraDb11g_home1TNSListener

(3)启动OracleServiceORCL

(4)启动OracleOraDb11g_home1TNSListener

OK

 

推荐阅读