修改listener.ora 文件:
加:
(SID_DESC =
(GLOBAL_DBNAME = hanmi)
(ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)
(SID_NAME = hanmi)
)
修改后为:
#SID_LIST_LISTENER =
# (SID_LIST =
# (SID_DESC =
# (SID_NAME = PLSExtProc)
# (ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)
# (PROGRAM = extproc)
# )
#
# )
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.20.20)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = hanmi)
(ORACLE_HOME = /u01/oracle/product/10.2.0/db_1)
(SID_NAME = hanmi)
)
)
~
转载于:https://blog.51cto.com/comtv/382891