经过一个多星期的折腾,反复安装了无数遍,基本上安装oracle 10g rac的问题都被我遇到了,一直用的是(oracle 10.2.0.1+VMware-workstation-5.5.1-19175+win2k3环境) 就在昨天晚上,自己不甘心,心想一定是哪里出了问题,换了个vmware版本(oracle 10.2.0.1+VMware-gsx-server-installer-3.2.0-14497+win2k3环境),居然顺利通过,不过最后还是出了一个小问题,安装完成后在两个节点上可以正常登录,重新启动两个节点,再登录sqlplus如下 C:\oracle>sqlplus SQL*Plus: Release 10.2.0.1.0 - Production on 星期二 2月 17 13:19:19 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. 请输入用户名: sys/licheng@sales as sysdba
ERROR:
ORA-12541: TNS: 无监听程序 下面传上监听程序的日志文件,请大家为我指点迷津,感涕流泪 部分日志文件内容如下:
Oracle Database 10g CRS Release 10.2.0.1.0 Production Copyright 1996, 2005 Oracle. All rights reserved.
2009-02-17 10:51:59.828: [ RACG][472] [1408][472][ora.rac02.LISTENER_RAC02.lsnr]:
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-2月 -2009 10:51:55 Copyright (c) 1991, 2005, Oracle. All rights reserved. 启动tnslsnr: 请稍候... Failed to open service <OracleOraDb10g_home1TNSListenerLISTENER_RAC02>, error 1
2009-02-17 10:51:59.828: [ RACG][472] [1408][472][ora.rac02.LISTENER_RAC02.lsnr]: 060.
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
系统参数文件为E:\oracle\product\10.2.0\db_1\network\admin\listener.ora
写入E:\oracle\product\10.2.0\db_1\network\log\listener_rac02.log的日志信息
监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=t
2009-02-17 10:51:59.828: [ RACG][472] [1408][472][ora.rac02.LISTENER_RAC02.lsnr]: cp)(HOST=211.152.14.109)(PORT=1521)))
监听该对象时出错: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=211.152.14.109)(PORT=1521)(IP=FIRST)))
TNS-12542: TNS: 地址已被占用
TNS-12560: TNS: 协议适配器错误
TNS-00512: 地址已在使用
32-bit Windows Error:
2009-02-17 10:51:59.828: [ RACG][472] [1408][472][ora.rac02.LISTENER_RAC02.lsnr]: 48: Unknown error 监听程序未能启动。请参阅上面的错误消息...
2009-02-17 10:51:59.875: [ RACG][472] [1408][472][ora.rac02.LISTENER_RAC02.lsnr]: clsrcexecut: env ORACLE_CONFIG_HOME=C:\oracle\product\10.2.0\crs 2009-02-17 10:51:59.875: [ RACG][472] [1408][472][ora.rac02.LISTENER_RAC02.lsnr]: clsrcexecut: cmd = E:\oracle\product\10.2.0\db_1\bin\racgeut.exe -e _USR_ORA_DEBUG=0 540 E:\oracle\product\10.2.0\db_1\bin\lsnrctl.exe start LISTENER_RAC02 2009-02-17 10:51:59.875: [ RACG][472] [1408][472][ora.rac02.LISTENER_RAC02.lsnr]: clsrcexecut: rc = 1, time = 5.331s 2009-02-17 10:52:02.843: [ RACG][472] [1408][472][ora.rac02.LISTENER_RAC02.lsnr]:
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-2月 -2009 10:52:00 Copyright (c) 1991, 2005, Oracle. All rights reserved. 正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vip02)(PORT=1521)(IP=FIRST)))
TNS-12541: TNS: 无监
2009-02-17 10:52:02.843: [ RACG][472] [1408][472][ora.rac02.LISTENER_RAC02.lsnr]: 绦? TNS-12560: TNS: 协议适配器错误
TNS-00511: 无监听程序
32-bit Windows Error: 61: Unknown error
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=211.152.14.109)(PORT=1521)(IP=FIRST)))
TNS-12541: TNS: 无监听程序
TNS-12560: TNS: 协议适
2009-02-17 10:52:02.843: [ RACG][472] [1408][472][ora.rac02.LISTENER_RAC02.lsnr]: 淦鞔砦? TNS-00511: 无监听程序
32-bit Windows Error: 61: Unknown error
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS: 无监听程序
TNS-12560: TNS: 协议适配器错误
TNS-00511: 无监听程序
32-bit Windows Error: 2
2009-02-17 10:52:02.843: [ RACG][472] [1408][472][ora.rac02.LISTENER_RAC02.lsnr]: : No such file or directory 2009-02-17 10:52:02.875: [ RACG][472] [1408][472][ora.rac02.LISTENER_RAC02.lsnr]: clsrcexecut: env ORACLE_CONFIG_HOME=C:\oracle\product\10.2.0\crs 2009-02-17 10:52:02.875: [ RACG][472] [1408][472][ora.rac02.LISTENER_RAC02.lsnr]: clsrcexecut: cmd = E:\oracle\product\10.2.0\db_1\bin\racgeut.exe -e _USR_ORA_DEBUG=0 540 E:\oracle\product\10.2.0\db_1\bin\lsnrctl.exe status LISTENER_RAC02 2009-02-17 10:52:02.875: [ RACG][472] [1408][472][ora.rac02.LISTENER_RAC02.lsnr]: clsrcexecut: rc = 1, time = 2.999s 2009-02-17 10:52:02.875: [ RACG][472] [1408][472][ora.rac02.LISTENER_RAC02.lsnr]: end for resource = ora.rac02.LISTENER_RAC02.lsnr, action = start, status = 1, time = 8.550s 2009-02-17 10:52:06.265: [ RACG][3496] [3476][3496][ora.rac02.LISTENER_RAC02.lsnr]:
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-2月 -2009 10:52:03 Copyright (c) 1991, 2005, Oracle. All rights reserved. 正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vip02)(PORT=1521)(IP=FIRST)))
TNS-12541: TNS: 无监
2009-02-17 10:52:06.265: [ RACG][3496] [3476][3496][ora.rac02.LISTENER_RAC02.lsnr]: 绦? TNS-12560: TNS: 协议适配器错误
TNS-00511: 无监听程序
32-bit Windows Error: 61: Unknown error
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=211.152.14.109)(PORT=1521)(IP=FIRST)))
TNS-12541: TNS: 无监听程序
TNS-12560: TNS: 协议适
2009-02-17 10:52:06.296: [ RACG][3496] [3476][3496][ora.rac02.LISTENER_RAC02.lsnr]: 淦鞔砦? TNS-00511: 无监听程序
32-bit Windows Error: 61: Unknown error
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS: 无监听程序
TNS-12560: TNS: 协议适配器错误
TNS-00511: 无监听程序
32-bit Windows Error: 2
2009-02-17 10:52:06.296: [ RACG][3496] [3476][3496][ora.rac02.LISTENER_RAC02.lsnr]: : No such file
.......
ERROR:
ORA-12541: TNS: 无监听程序 下面传上监听程序的日志文件,请大家为我指点迷津,感涕流泪 部分日志文件内容如下:
Oracle Database 10g CRS Release 10.2.0.1.0 Production Copyright 1996, 2005 Oracle. All rights reserved.
2009-02-17 10:51:59.828: [ RACG][472] [1408][472][ora.rac02.LISTENER_RAC02.lsnr]:
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-2月 -2009 10:51:55 Copyright (c) 1991, 2005, Oracle. All rights reserved. 启动tnslsnr: 请稍候... Failed to open service <OracleOraDb10g_home1TNSListenerLISTENER_RAC02>, error 1
2009-02-17 10:51:59.828: [ RACG][472] [1408][472][ora.rac02.LISTENER_RAC02.lsnr]: 060.
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
系统参数文件为E:\oracle\product\10.2.0\db_1\network\admin\listener.ora
写入E:\oracle\product\10.2.0\db_1\network\log\listener_rac02.log的日志信息
监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=t
2009-02-17 10:51:59.828: [ RACG][472] [1408][472][ora.rac02.LISTENER_RAC02.lsnr]: cp)(HOST=211.152.14.109)(PORT=1521)))
监听该对象时出错: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=211.152.14.109)(PORT=1521)(IP=FIRST)))
TNS-12542: TNS: 地址已被占用
TNS-12560: TNS: 协议适配器错误
TNS-00512: 地址已在使用
32-bit Windows Error:
2009-02-17 10:51:59.828: [ RACG][472] [1408][472][ora.rac02.LISTENER_RAC02.lsnr]: 48: Unknown error 监听程序未能启动。请参阅上面的错误消息...
2009-02-17 10:51:59.875: [ RACG][472] [1408][472][ora.rac02.LISTENER_RAC02.lsnr]: clsrcexecut: env ORACLE_CONFIG_HOME=C:\oracle\product\10.2.0\crs 2009-02-17 10:51:59.875: [ RACG][472] [1408][472][ora.rac02.LISTENER_RAC02.lsnr]: clsrcexecut: cmd = E:\oracle\product\10.2.0\db_1\bin\racgeut.exe -e _USR_ORA_DEBUG=0 540 E:\oracle\product\10.2.0\db_1\bin\lsnrctl.exe start LISTENER_RAC02 2009-02-17 10:51:59.875: [ RACG][472] [1408][472][ora.rac02.LISTENER_RAC02.lsnr]: clsrcexecut: rc = 1, time = 5.331s 2009-02-17 10:52:02.843: [ RACG][472] [1408][472][ora.rac02.LISTENER_RAC02.lsnr]:
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-2月 -2009 10:52:00 Copyright (c) 1991, 2005, Oracle. All rights reserved. 正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vip02)(PORT=1521)(IP=FIRST)))
TNS-12541: TNS: 无监
2009-02-17 10:52:02.843: [ RACG][472] [1408][472][ora.rac02.LISTENER_RAC02.lsnr]: 绦? TNS-12560: TNS: 协议适配器错误
TNS-00511: 无监听程序
32-bit Windows Error: 61: Unknown error
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=211.152.14.109)(PORT=1521)(IP=FIRST)))
TNS-12541: TNS: 无监听程序
TNS-12560: TNS: 协议适
2009-02-17 10:52:02.843: [ RACG][472] [1408][472][ora.rac02.LISTENER_RAC02.lsnr]: 淦鞔砦? TNS-00511: 无监听程序
32-bit Windows Error: 61: Unknown error
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS: 无监听程序
TNS-12560: TNS: 协议适配器错误
TNS-00511: 无监听程序
32-bit Windows Error: 2
2009-02-17 10:52:02.843: [ RACG][472] [1408][472][ora.rac02.LISTENER_RAC02.lsnr]: : No such file or directory 2009-02-17 10:52:02.875: [ RACG][472] [1408][472][ora.rac02.LISTENER_RAC02.lsnr]: clsrcexecut: env ORACLE_CONFIG_HOME=C:\oracle\product\10.2.0\crs 2009-02-17 10:52:02.875: [ RACG][472] [1408][472][ora.rac02.LISTENER_RAC02.lsnr]: clsrcexecut: cmd = E:\oracle\product\10.2.0\db_1\bin\racgeut.exe -e _USR_ORA_DEBUG=0 540 E:\oracle\product\10.2.0\db_1\bin\lsnrctl.exe status LISTENER_RAC02 2009-02-17 10:52:02.875: [ RACG][472] [1408][472][ora.rac02.LISTENER_RAC02.lsnr]: clsrcexecut: rc = 1, time = 2.999s 2009-02-17 10:52:02.875: [ RACG][472] [1408][472][ora.rac02.LISTENER_RAC02.lsnr]: end for resource = ora.rac02.LISTENER_RAC02.lsnr, action = start, status = 1, time = 8.550s 2009-02-17 10:52:06.265: [ RACG][3496] [3476][3496][ora.rac02.LISTENER_RAC02.lsnr]:
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-2月 -2009 10:52:03 Copyright (c) 1991, 2005, Oracle. All rights reserved. 正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vip02)(PORT=1521)(IP=FIRST)))
TNS-12541: TNS: 无监
2009-02-17 10:52:06.265: [ RACG][3496] [3476][3496][ora.rac02.LISTENER_RAC02.lsnr]: 绦? TNS-12560: TNS: 协议适配器错误
TNS-00511: 无监听程序
32-bit Windows Error: 61: Unknown error
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=211.152.14.109)(PORT=1521)(IP=FIRST)))
TNS-12541: TNS: 无监听程序
TNS-12560: TNS: 协议适
2009-02-17 10:52:06.296: [ RACG][3496] [3476][3496][ora.rac02.LISTENER_RAC02.lsnr]: 淦鞔砦? TNS-00511: 无监听程序
32-bit Windows Error: 61: Unknown error
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12541: TNS: 无监听程序
TNS-12560: TNS: 协议适配器错误
TNS-00511: 无监听程序
32-bit Windows Error: 2
2009-02-17 10:52:06.296: [ RACG][3496] [3476][3496][ora.rac02.LISTENER_RAC02.lsnr]: : No such file
.......
监听的问题,再贴些信息出来吧:
1. cmd下lsnrctl services
lsnrctl stop
lsnrctl start
lsnrctl stat
2. listener.ora
3. tnsnames.ora
重新配置监听程序时,出现下面的错误 配置错误:rac02:LISTENER_RAC02启动监听程序失败.
监听程序可能已经在运行
CRS-0215:无法启动资源'ora.rac02.LISTENER_RAC02.lsnr'.
TNS-12541: TNS: 无监
2009-02-17 10:52:06.265: [ RACG][3496] [3476][3496][ora.rac02.LISTENER_RAC02.lsnr]: 绦? TNS-12560: TNS: 协议适配器错误
TNS-00511: 无监听程序 】
看到楼主报如上错误,可以用以下的办法看下监听服务的运行状态:
连接字符中的HOST需要跟监听器中的HOST保持一致。可以用以下步骤来验证:
启动本地数据库-》启动监听器-》过一段时间,用OEM连接数据库-》lsnrctl status
如果过一段时间还无法用OEM或TNSPING,那么可以用以下命令强制注册:
SQL> alter system register;System altered.
这样可以检查下你的监听是否起来了
刚才系统重新启动了C:\oracle>sqlplusSQL*Plus: Release 10.2.0.1.0 - Production on 星期二 2月 17 13:19:19 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.请输入用户名: sys/licheng@sales as sysdba
ERROR:
ORA-12541: TNS: 无监听程序C:\oracle\product\10.2.0\crs\BIN>crs_unregister.exeC:\>lsnrctl servicesLSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-2月 -2009 15:0
3:18Copyright (c) 1991, 2005, Oracle. All rights reserved.正在连接到 (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS: 无监听程序
TNS-12560: TNS: 协议适配器错误
TNS-00511: 无监听程序
32-bit Windows Error: 61: Unknown errorC:\>lsnrctl stopLSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-2月 -2009 15:0
3:26Copyright (c) 1991, 2005, Oracle. All rights reserved.正在连接到 (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12541: TNS: 无监听程序
TNS-12560: TNS: 协议适配器错误
TNS-00511: 无监听程序
32-bit Windows Error: 61: Unknown errorC:\>lsnrctl startLSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-2月 -2009 15:0
3:33Copyright (c) 1991, 2005, Oracle. All rights reserved.启动tnslsnr: 请稍候...Failed to open service <OracleOraDb10g_home1TNSListener>, error 1060.
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
系统参数文件为E:\oracle\product\10.2.0\db_1\network\admin\listener.ora
写入E:\oracle\product\10.2.0\db_1\network\log\listener.log的日志信息
监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac02)(PORT=1521)))正在连接到 (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER 的 STATUS
------------------------
别名 LISTENER
版本 TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
启动日期 17-2月 -2009 15:03:37
正常运行时间 0 天 0 小时 0 分 2 秒
跟踪级别 off
安全性 ON: Local OS Authentication
SNMP OFF
监听程序参数文件 E:\oracle\product\10.2.0\db_1\network\admin\listener.o
ra
监听程序日志文件 E:\oracle\product\10.2.0\db_1\network\log\listener.log监听端点概要...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac02)(PORT=1521)))
监听程序不支持服务
命令执行成功C:\>lsnrctl statLSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-2月 -2009 15:0
3:43Copyright (c) 1991, 2005, Oracle. All rights reserved.正在连接到 (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
LISTENER 的 STATUS
------------------------
别名 LISTENER
版本 TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Produ
ction
启动日期 17-2月 -2009 15:03:37
正常运行时间 0 天 0 小时 0 分 8 秒
跟踪级别 off
安全性 ON: Local OS Authentication
SNMP OFF
监听程序参数文件 E:\oracle\product\10.2.0\db_1\network\admin\listener.o
ra
监听程序日志文件 E:\oracle\product\10.2.0\db_1\network\log\listener.log监听端点概要...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=rac02)(PORT=1521)))
服务摘要..
服务 "sales.koorka.com" 包含 1 个例程。
例程 "sales1", 状态 READY, 包含此服务的 1 个处理程序...
服务 "salesXDB.koorka.com" 包含 1 个例程。
例程 "sales1", 状态 READY, 包含此服务的 1 个处理程序...
服务 "sales_XPT.koorka.com" 包含 1 个例程。
例程 "sales1", 状态 READY, 包含此服务的 1 个处理程序...
命令执行成功C:\>listener.ora内容:
# listener.ora Network Configuration File: E:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER_RAC02 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)SID_LIST_LISTENER_RAC01 =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)LISTENER_RAC02 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vip02)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 211.152.14.109)(PORT = 1521)(IP = FIRST))
)
)LISTENER_RAC01 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vip01)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 211.152.14.110)(PORT = 1521)(IP = FIRST))
)
)
tnsnames.ora内容:
# tnsnames.ora Network Configuration File: E:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.SALES =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vip02)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = vip01)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = sales.koorka.com)
)
)LISTENERS_SALES =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = vip02)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = vip01)(PORT = 1521))
)SALES2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vip02)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = sales.koorka.com)
(INSTANCE_NAME = sales2)
)
)SALES1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vip01)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = sales.koorka.com)
(INSTANCE_NAME = sales1)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
试试
也碰到同样的问题