千家信息网

listener.ora

发表于:2025-01-21 作者:千家信息网编辑
千家信息网最后更新 2025年01月21日,ORACLE_HOME/network/admin/Status : Failure -Test failed: Listener refused the connection with the fo
千家信息网最后更新 2025年01月21日listener.ora

ORACLE_HOME/network/admin/

Status : Failure -Test failed: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor


SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe)
(PROGRAM = extproc)
)

    (SID_DESC =      (GLOBAL_DBNAME = XE)      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe)      (SID_NAME = XE)    )

)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
)
)

DEFAULT_SERVICE_LISTENER = (XE)

0