ITPub博客

首页 > 数据库 > Oracle > oracle9207 rac 升级到9208异常问题

oracle9207 rac 升级到9208异常问题

原创 Oracle 作者:watershed 时间:2010-01-09 05:10:07 0 删除 编辑
今天晚上在贵州电信升级一套rac,发生异常,数据库升级到9208以后无法以cluster的方式启动,在metalink查了好多文档,都没有能够匹配的,见了鬼了,最终经过5个小时折腾终于找到了答案。[@more@]

环境:oracle9207 rac 升级到oracle9208 rac

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

报错:

node1Sat 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

node2Sat 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的拷贝,而节点12的这两个文件并不一致,因此分别在两个节点执行以下步骤:

cd $ORACLE_HOME/lib

cp libskgxpu.so libskgxp9.so

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

问题解决。

^_^

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

上一篇: RAC的TAF简单测试
请登录后发表评论 登录
全部评论

注册时间:2011-07-25

  • 博文量
    33
  • 访问量
    1388261