監聽檔案配置錯誤,提示裡面有不知道的 SID描述,建議可以手工修改。
建議是:
或者修改你現有的監聽檔案 listener.ora 如下, 注意修改如下引數為你的實際情況
(1) GLOBAL_DBNAME = cqcq
(2) SID_NAME = cqcq)
(3) ORACLE_HOME
# listener.ora Network Configuration File: D:\app\Administrator\product\11.1.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 = 192.168.0.68)(PORT = 1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\app\Administrator\product\11.1.0\db_1)
(PROGRAM = extproc)
(GLOBAL_DBNAME = cqcq)
(SID_NAME = cqcq)
監聽檔案配置錯誤,提示裡面有不知道的 SID描述,建議可以手工修改。
建議是:
或者修改你現有的監聽檔案 listener.ora 如下, 注意修改如下引數為你的實際情況
(1) GLOBAL_DBNAME = cqcq
(2) SID_NAME = cqcq)
(3) ORACLE_HOME
# listener.ora Network Configuration File: D:\app\Administrator\product\11.1.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 = 192.168.0.68)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\app\Administrator\product\11.1.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = cqcq)
(ORACLE_HOME = D:\app\Administrator\product\11.1.0\db_1)
(SID_NAME = cqcq)
)
)