打开:%Oracle_Hoem%/network/admin/listener.ora文件 在
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:/Oracle/Oracle10g)
(PROGRAM = extproc)
)
后面添加:
(SID_DESC =
(GLOBAL_DBNAME = ORACLE)
(ORACLE_HOME = D:/Oracle/Oracle10g)
(SID_NAME = ORACLE)
)
GLOBAL_DBNAME与SDI相同
最后变成:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:/Oracle/Oracle10g)
(PROGRAM = extproc)
) (SID_DESC =
(GLOBAL_DBNAME = ORACLE)
(ORACLE_HOME = D:/Oracle/Oracle10g)
(SID_NAME = ORACLE)
)
)