The listener supports no services
http://tc.itkee.com/database/detail-cba.html
[@more@]lsnrctl start
提示:
The listener supports no services
The command completed successfully這樣啓動後遠程連接會造成
oracle ORA-12514:TNS:listener does not currently know of service requested in connect descriptor
---方案一---------原因:數據庫實例註冊到listener-----------------------------------
--登錄數據庫
$sqlplus / as sysdba
--顯示服務名
SQL>show parameter service_names
--強制註冊服務
SQL>alter system register;
--查看監聽狀態
$lsnrctl status
-----方案二--------------------------------------
問題解決了
在listener.ora裏面添加了一行SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = globe)
(SID_NAME = globe)
)
)
-----方案三-------------------------
後發現Oracle有個Net Manager可用:
在下圖的Listeners->Database Services中配置要監聽的SID及ORACLE_HOME,退出保存。
linux上面:
[root@localhost oracle]# xhost +
[root@localhost oracle]# su - oracle
[oracle@localhost ~]$ netmgr来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/14377/viewspace-1060066/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/14377/viewspace-1060066/