遠(yuǎn)程連接時報錯:TNS-: no listener
原因:監(jiān)聽器未啟動
解決方案:
重新配置$Oracle_HOME/network/admin中的listener.ora
如下的標(biāo)準(zhǔn)文件
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
-
(ADDRESS = (PROTOCOL = TCP)(HOST = zkOracle)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = PLSEXTPROC
(Oracle_HOME = /u01/app/oracle/product/11.2.0/db_1)
(SID_NAME = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(Oracle_HOME = /u01/app/oracle/product/11.2.0/db_1)
(SID_NAME = ORCL)
)
) 本文出自:億恩科技【www.riomediacenter.com】
服務(wù)器租用/服務(wù)器托管中國五強(qiáng)!虛擬主機(jī)域名注冊頂級提供商!15年品質(zhì)保障!--億恩科技[ENKJ.COM]
|