ORA-12514TNSlistenerdoesnotcurrentlyknowofservicerequestedinconnectdescriptor

2024-08-16 18:38阅读：

http://blog.sina.cn/dpool/blog/u/5000063013

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

Linux上安装完ORACLE11g后出现服务器上能正常登陆，不能远程登陆情况，如图:
lsnrctl status 查看监听状态如下无支持的服务

ORA-12514TNSlistenerdoesnotcurrentlyknowofservicerequestedinconnectdescriptor

正常情况如下 lsnrctl status

ORA-12514TNSlistenerdoesnotcurrentlyknowofservicerequestedinconnectdescriptor

PL/SQL登陆提示如下无法登陆

ORA-12514TNSlistenerdoesnotcurrentlyknowofservicerequestedinconnectdescriptor

解决方法:
修改监听配置 listener.ora
路径: cd $ORACLE_HOME/network/admin
cd /u01/oracle11g/product/11.2.0/network/admin
修改前:

ORA-12514TNSlistenerdoesnotcurrentlyknowofservicerequestedinconnectdescriptor

修改后:

ORA-12514TNSlistenerdoesnotcurrentlyknowofservicerequestedinconnectdescriptor

修改完，重启监听 lsnrctl stop lsnrctl start
再使用PL/SQL 客户端登陆
也可以在服务器上如下远程登陆看是否正常登陆
sqlplus scott/tiger@1270.0.01/cuug
sqlplus scott/tiger@192.168.127.133/cuug

举报/Report

我的更多文章

下载客户端阅读体验更佳