当前位置: 代码迷 >> Oracle管理 >> ora-12514:TNS:listener does not currently know of service requested in connect,该怎么处理
  详细解决方案

ora-12514:TNS:listener does not currently know of service requested in connect,该怎么处理

热度:251   发布时间:2016-04-24 05:12:49.0
ora-12514:TNS:listener does not currently know of service requested in connect
我安装的是oracle10g 然后安装了sql developer 但是登录时显示
ora-12514:TNS:listener does not currently know of service requested in connect descriptor
该怎么配置啊

------解决方案--------------------
1、楼主检查有没有配置监听文件 tnsnames.ora和listener.ora
2、就楼主检查有没有启动监听,lsnrctl start

------解决方案--------------------
lsnrctl status 查看状态
------解决方案--------------------
SQL code
>lsnrctllsnrctl> status--查看监听器的状态!
------解决方案--------------------
重建监听 重建tns
  相关解决方案