Oracle監(jiān)聽(tīng)報(bào)The listener supports no services
作者：雪竹聊運(yùn)維
最近在遷移一個(gè)oracle數(shù)據(jù)庫(kù)時(shí)，啟動(dòng)oracle監(jiān)聽(tīng)程序時(shí)報(bào)如下錯(cuò)誤，The listener supports no services
一、問(wèn)題描述
最近在遷移一個(gè)oracle數(shù)據(jù)庫(kù)時(shí)，啟動(dòng)oracle監(jiān)聽(tīng)程序時(shí)報(bào)如下錯(cuò)誤，The listener supports no services，
二、原因分析
數(shù)據(jù)庫(kù)實(shí)例沒(méi)注冊(cè)到listener
三、處理過(guò)程
在listener.ora里面添加了紅色標(biāo)記的代碼，具體如下：
oracle@oracle11g admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle11g)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(SID_NAME = orcl)
)
)
ADR_BASE_LISTENER = /u01/app/oracle
注：根據(jù)實(shí)際情況把GLOBAL_DBNAME及SID_NAME的值換成自己數(shù)據(jù)庫(kù)實(shí)際的值即可。
責(zé)任編輯：姜華
來(lái)源：
jrtt
