求助，windows下的rac，服务器重启后一个节点不能启动

显示全部楼层 · 2012-1-9 14:19:00

小弟刚刚接触RAC，现场有一套Windows2008下的oracle 10g RAC，其中一个节点服务器重启之后发现该节点没有online，于是
start instance -d exchdb -i exchdb1

启动失败，
启动sqlplus /nolog
SQL> conn /as sysdba
Connected to an idle instance.
SQL> startup
结果
ORA-01078: failure in processing system parameters
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'listener'
本人刚刚接触rac，希望哪位高人能与帮助，小弟感激不尽

千问 · 2012-1-9 14:19:00

listener.ora 下的内容如下：
# listener.ora.lgdb1 Network Configuration File: E:\oracle\product\10.2.0\rac\network\admin\listener.ora.lgdb1
# Generated by Oracle configuration tools.
LISTENER_LGDB1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = vip1)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.27.4.71)(PORT = 1521)(IP = FIRST))
)
)
tnsnames.ora的内容如下：
# tnsnames.ora Network Configuration File: E:\oracle\product\10.2.0\rac\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
LISTENERS_EXCHDB =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = vip1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = vip2)(PORT = 1521))
)
EXCHDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = vip1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = vip2)(PORT = 1521))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = exchdb)
)
)
EXCHDB2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = vip2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = exchdb)
(INSTANCE_NAME = exchdb2)
)
)
EXCHDB1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = vip1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = exchdb)
(INSTANCE_NAME = exchdb1)
)
)
这两个文件中的listener是不是有问题，一个是LISTENER_LGDB1一个是EXCHDB1