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