新浪博客

ORA-12514TNSlistenerdoesnotcurrentlyknowofservicerequestedinconnectdescriptor

2024-08-16 18:38阅读:
问题: 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


我的更多文章

下载客户端阅读体验更佳

APP专享