关于解决EM不能启动的解决方法
为了使用恢复目录,我在目标主机上设置了一下listener.ora.
改成了这样。[@more@]关于解决EM不能启动的解决方法
为了使用恢复目录,我在目标主机上设置了一下listener.ora.
改成了这样。
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = oral)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = www.mengfm.com)(PORT = 1521))
)
)
。
这时再启动EM时就说是没有启动监听器。TNS:no lisenter.
这时费了半天的功夫,找了不少资料。最后把listener.ora改成了这样:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = oral)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = www.mengfm.com)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC))
)
)
这个SID_MAME = PLSExtProc是关于外部过程服务定义,不能缺少了,程序名设置为EXTPROC
为了使用恢复目录,我在目标主机上设置了一下listener.ora.
改成了这样。[@more@]关于解决EM不能启动的解决方法
为了使用恢复目录,我在目标主机上设置了一下listener.ora.
改成了这样。
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = oral)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = www.mengfm.com)(PORT = 1521))
)
)
。
这时再启动EM时就说是没有启动监听器。TNS:no lisenter.
这时费了半天的功夫,找了不少资料。最后把listener.ora改成了这样:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = oral)
(ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = www.mengfm.com)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC))
)
)
这个SID_MAME = PLSExtProc是关于外部过程服务定义,不能缺少了,程序名设置为EXTPROC
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/330796/viewspace-880503/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/330796/viewspace-880503/