在虚拟机上测试, 使用了ASM,
listener.ora 配置如下:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.10)(PORT = 1521))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/oracle/product/10.2.0/db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = vmorcl)
(ORACLE_HOME = /u01/app/oracle/oracle/product/10.2.0/db_1)
(SID_NAME = vmorcl)
)
)
LISTENER_1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.10)(PORT = 1522))
)
)
)
SID_LIST_LISTENER_1 =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = +ASM)
(ORACLE_HOME = /u01/app/oracle/oracle/product/10.2.0/db_1)
(SID_NAME = +ASM)
)
)
启动,客户端的访问都一切正常,但是使用EM时候却总是无法找到监听,并提示ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach)
使用emca -config dbcontrol db 重建也没有用
而使用emca -repos recreate,更是会在log中出现
[19-08-2010 06:31:09] Could not connect to SYS/(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=VMhost1.localdomain)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=vmorcl))): ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach)
请各位看看是什么问题呢..?是否有遇到过? 如何处理...
[本帖最后由 fxbsmile 于 2010-8-18 23:41 编辑]
未命名.JPG
(52.25 KB, 下载次数: 6)
2010-8-18 23:41 上传