打开:
D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora文件
在
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
后面添加:
(SID_DESC =
(GLOBAL_DBNAME = ORCL )
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(SID_NAME = ORCL )
)
最后变成:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
) (SID_DESC =
(GLOBAL_DBNAME = ORCL )
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(SID_NAME = ORCL )
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
后面添加:
(SID_DESC =
(GLOBAL_DBNAME = ORCL )
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(SID_NAME = ORCL )
)
最后变成:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
) (SID_DESC =
(GLOBAL_DBNAME = ORCL )
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(SID_NAME = ORCL )
)
)