oracle9207 rac 升级到9208异常问题

今天晚上在贵州电信升级一套rac，发生异常，数据库升级到9208以后无法以cluster的方式启动，在metalink查了好多文档，都没有能够匹配的，见了鬼了，最终经过5个小时折腾终于找到了答案。[@more@]

环境：oracle9207 rac 升级到oracle9208 rac

问题现象：升级完成后两个节点的数据库无法同时启动，只能启动一个，无论先启动哪个节点，另外一个节点都无法启动，在mount阶段hang

报错：

node1：Sat Jan 9 03:13:27 2010

starting up 1 shared server(s) ...

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

ARCH: STARTING ARCH PROCESSES

ARC0 started with pid=19, OS id=16038

ARC0: Archival started

ARC1 started with pid=20, OS id=16040

Sat Jan 9 03:13:28 2010

ARCH: STARTING ARCH PROCESSES COMPLETE

Sat Jan 9 03:13:28 2010

ARC1: Archival started

Sat Jan 9 03:13:28 2010

ARC0: Becoming the 'no FAL' ARCH

ARC0: Becoming the 'no FAL' ARCHARC0: Thread not mounted

Sat Jan 9 03:13:28 2010

lmon registered with NM - instance id 1 (internal mem no 0)

tossing admin msg

tossing bad msg pid 16008

tossing admin msg

tossing bad msg pid 16008

tossing admin msg

node2：Sat Jan 9 03:14:40 2010

starting up 1 shared server(s) ...

starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

ARCH: STARTING ARCH PROCESSES

ARC0 started with pid=19, OS id=11307

ARC0: Archival started

ARC1 started with pid=20, OS id=11309

Sat Jan 9 03:14:41 2010

ARC1: Archival started

Sat Jan 9 03:14:41 2010

ARCH: STARTING ARCH PROCESSES COMPLETE

ARC1: Becoming the 'no FAL' ARCH

ARC1: Becoming the 'no FAL' ARCHARC1: Thread not mounted

Sat Jan 9 03:14:41 2010

ARC0: Becoming the heartbeat ARCH

ARC0: Becoming the heartbeat ARCHARC0: Thread not mounted

Sat Jan 9 03:14:41 2010

ALTER DATABASE MOUNT

Sat Jan 9 03:14:41 2010

lmon registered with NM - instance id 2 (internal mem no 1)

Sat Jan 9 03:15:41 2010

ARC0: Thread not mounted

Sat Jan 9 03:16:37 2010

LMON: terminating instance due to error 472

Sat Jan 9 03:16:39 2010

System state dump is made for local instance

Sat Jan 9 03:16:39 2010

Trace dumping is performing id=[cdmp_20100109031639]

Sat Jan 9 03:16:42 2010

Instance terminated by LMON, pid = 11277

主要是tossing admin msg

tossing bad msg pid 16008 和ARC1: Thread not mounted

处理过程：

主要问题是集中在$ORACLE_HOME/lib/libskgxp*文件有问题

两个节点执行ls -l $ORACLE_HOME/lib/libskgxp*

发现两个节点的结果不一致：

原来RAC配置后，libskgxp9.so应该是 libskgxpu.so的拷贝，而节点1，2的这两个文件并不一致，因此分别在两个节点执行以下步骤：

cd $ORACLE_HOME/lib

cp libskgxpu.so libskgxp9.so

然后重启数据库：srvctl start database –d ods

问题解决。

^_^

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/75730/viewspace-1030414/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/75730/viewspace-1030414/