优秀是一种习惯 , 生活是一种过程 ， 放弃是一种智慧 , 缺点是一种恩惠。 我的MSN: qiwang1979@hotmail.com , 希望结交更多喜欢Oracle, Linux，热爱生活的朋友。 欢迎加入Oracle数据库讨论QQ群组 (号码：42235266)，希望大家在这里共同进步 !

[悬赏500pub$] Oracle 9.2.0.7 RAC + Linux AS3.0, ORA-29702导致实例crash

上一篇 / 下一篇  2008-01-05 20:55:46 / 个人分类：Oracle数据库管理

查看( 420 ) / 评论( 32 )
Linux AS3.0
内核版本： 2.4.21-37.ELsmp  
Oracle 9.2.0.4 升级到Oracle9.2.0.7  , RAC  ， 两节点。   clusterware是9204软件安装的 。






alter_orcl1.log  

-------------------------------------------------------------------------------------------------   


Sat Jan  5 18:44:19 2008
ARC1: Evaluating archive   log 1 thread 1 sequence 122
ARC1: Beginning to archive log 1 thread 1 sequence 122
Creating archive destination LOG_ARCHIVE_DEST_1: '/ocfs_arch1/orcl/1_122.dbf'
ARC1: Completed archiving  log 1 thread 1 sequence 122
Sat Jan  5 19:36:06 2008
Thread 1 advanced to log sequence 124
  Current log# 4 seq# 124 mem# 0: /ocfs_ctrl_redo/orcl/redo04.log
  Current log# 4 seq# 124 mem# 1: /ocfs_data/orcl/redo04b.log
Sat Jan  5 19:36:06 2008
ARC1: Evaluating archive   log 3 thread 1 sequence 123
ARC1: Beginning to archive log 3 thread 1 sequence 123
Creating archive destination LOG_ARCHIVE_DEST_1: '/ocfs_arch1/orcl/1_123.dbf'
ARC1: Completed archiving  log 3 thread 1 sequence 123
Sat Jan  5 19:45:15 2008
Errors in file /u01/product/admin/orcl/bdump/orcl1_lmon_14214.trc:
ORA-29702: error occurred in Cluster Group Service operation
Sat Jan  5 19:45:15 2008
LMON: terminating instance due to error 29702
Sat Jan  5 19:45:16 2008
System state dump is made for local instance
Sat Jan  5 19:45:20 2008
Instance terminated by LMON, pid = 14214
Sat Jan  5 19:54:53 2008
Starting ORACLE instance (normal)
Sat Jan  5 19:54:53 2008
Global Enqueue Service Resources = 26694, pool = 4
Sat Jan  5 19:54:53 2008
Global Enqueue Service Enqueues = 39350
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.7.0.
System parameters with non-default values:
  processes                = 1000
  timed_statistics         = FALSE
  resource_limit           = TRUE
  shared_pool_size         = 419430400
  large_pool_size          = 33554432
  java_pool_size           = 33554432  
















$  vi   /u01/product/admin/orcl/bdump/orcl1_lmon_14214.trc  

=============




/u01/product/admin/orcl/bdump/orcl1_lmon_14214.trc
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
ORACLE_HOME = /u01/product/oracle
System name:    Linux
Node name:      DELL-RAC01
Release:        2.4.21-37.ELsmp
Version:        #1 SMP Wed Sep 7 13:28:55 EDT 2005
Machine:        i686
Instance name: orcl1
Redo thread mounted by this instance: 0 <none>
Oracle process number: 4
Unix process pid: 14214, image: oracle@DELL-RAC01 (LMON)

*** SESSION ID3.1) 2007-12-31 12:07:45.591
GES IPC: Receivers 3  Senders 3
GES IPC: Buffers  Receive 1000  Send (i:2230 b:2230) Reserve 1000
GES IPC: Msg Size  Regular 396  Batch 2048
Batch msg size = 2048
Batching factor: enqueue replay 48, ack 53
Batching factor: cache replay 34 size per lock 56
kjxggin: receive buffer size = 32768
kjxgmin: SKGXN ver (2 1 Oracle 9i Reference CM)
CMCLI WARNING: CMInitContext:  init ctx(0xb6d93f8)
*** 2007-12-31 12:07:49.396
kjxgmrcfg: Reconfiguration started, reason 1
kjxgmcs: Setting state to 0 0.
*** 2007-12-31 12:07:49.396
     Name Service frozen
kjxgmcs: Setting state to 0 1.
kjfcpiora: publish my weight 122787
kjxgmps: proposing substate 2
kjxgmcs: Setting state to 1 2.
     Performed the unique instance identification check
kjxgmps: proposing substate 3
kjxgmcs: Setting state to 1 3.
     Name Service recovery started
     Deleted all dead-instance name entries
kjxgmps: proposing substate 4
kjxgmcs: Setting state to 1 4.
     Multicasted all local name entries for publish
     Replayed all pending requests
kjxgmps: proposing substate 5
kjxgmcs: Setting state to 1 5.
     Name Service normal
     Name Service recovery done
*** 2007-12-31 12:07:49.611
kjxgmps: proposing substate 6
kjxgmcs: Setting state to 1 6.
*** 2007-12-31 12:07:49.832
*** 2007-12-31 12:07:49.832
Reconfiguration started (old inc 0, new inc 1)
Synchronization timeout interval: 600 sec
List of nodes:
0
Global Resource Directory frozen
node 0
release 9 2 0 7
* kjshashcfg: I'm the only node in the cluster (node 0)
Active Sendback Threshold = 50 %
Communication channels reestablished
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
Resources and enqueues cleaned out
Resources remastered 0
0 GCS shadows traversed, 0 cancelled, 0 closed
0 GCS resources traversed, 0 cancelled
set master node info
Submitted all remote-enqueue requests
Update rdomain variables
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
*** 2007-12-31 12:07:50.121
0 GCS shadows traversed, 0 replayed, 0 unopened
Submitted all GCS cache requests
0 write requests issued in 0 GCS resources
0 PIs marked suspect, 0 flush PI msgs

论坛模式 推荐 收藏 分享给好友 推荐到圈子 管理

TAG:

春暖花开 tolywang 发布于2008-01-05 21:04:37
主要是节点1出现实例关闭，节点2正常，节点1上的 oracm log 如下 ：




Sat Jan  5 19:45:15 2008
Errors in file /u01/product/admin/orcl/bdump/orcl1_lmon_14214.trc:
ORA-29702: error occurred in Cluster Group Service operation




在这个时候： Jan  5 19:45:15   出现一处ERROR .    ERROR:    WriteEventPort: write failed with error 32., tid = ClientProcListener:688145 file = unixinc.c, line = 915 {Sat Jan  5 19:45:16 2008 }^M
详见下面：





Debug Hang :ClientProcListener (PID=22683)  UnRegistered with watchdog daemon. {Sat Jan  5 16:43:30 2008 }^M
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = ClientProcListener:1966099 file = unixinc.c, line = 767 {Sat Jan  5 17:01:33 2008 }^M
Debug Hang :ClientProcListener (PID=22674)  UnRegistered with watchdog daemon. {Sat Jan  5 17:01:33 2008 }^M
>WARNING:  ReadCommPort: received error=104 on recv()., tid = ClientProcListener:425998 file = unixinc.c, line = 775 {Sat Jan  5 19:45:15 2008 }^M
Debug Hang :ClientProcListener (PID=14243)  UnRegistered with watchdog daemon. {Sat Jan  5 19:45:15 2008 }^M
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = ClientProcListener:1835026 file = unixinc.c, line = 767 {Sat Jan  5 19:45:15 2008 }^M
Debug Hang :ClientProcListener (PID=16033)  UnRegistered with watchdog daemon. {Sat Jan  5 19:45:15 2008 }^M
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = ClientProcListener:606223 file = unixinc.c, line = 767 {Sat Jan  5 19:45:15 2008 }^M
Debug Hang :ClientProcListener (PID=14254)  UnRegistered with watchdog daemon. {Sat Jan  5 19:45:15 2008 }^M
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = ClientProcListener:639000 file = unixinc.c, line = 767 {Sat Jan  5 19:45:15 2008 }^M
Debug Hang :ClientProcListener (PID=14256)  UnRegistered with watchdog daemon. {Sat Jan  5 19:45:15 2008 }^M
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = ClientProcListener:589833 file = unixinc.c, line = 767 {Sat Jan  5 19:45:16 2008 }^M
Debug Hang :ClientProcListener (PID=14253)  UnRegistered with watchdog daemon. {Sat Jan  5 19:45:16 2008 }^M
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = ClientProcListener:655385 file = unixinc.c, line = 767 {Sat Jan  5 19:45:16 2008 }^M
Debug Hang :ClientProcListener (PID=14257)  UnRegistered with watchdog daemon. {Sat Jan  5 19:45:16 2008 }^M
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = ClientProcListener:688145 file = unixinc.c, line = 767 {Sat Jan  5 19:45:16 2008 }^M
>ERROR:    WriteEventPort: write failed with error 32., tid = ClientProcListener:688145 file = unixinc.c, line = 915 {Sat Jan  5 19:45:16 2008 }^M
Debug Hang :ClientProcListener (PID=14261)  UnRegistered with watchdog daemon. {Sat Jan  5 19:45:16 2008 }^M
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = ClientProcListener:622615 file = unixinc.c, line = 767 {Sat Jan  5 19:45:16 2008 }^M
Debug Hang :ClientProcListener (PID=14255)  UnRegistered with watchdog daemon. {Sat Jan  5 19:45:16 2008 }^M
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = ClientProcListener:557077 file = unixinc.c, line = 767 {Sat Jan  5 19:45:16 2008 }^M
Debug Hang :ClientProcListener (PID=14251)  UnRegistered with watchdog daemon. {Sat Jan  5 19:45:16 2008 }^M
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = ClientProcListener:573462 file = unixinc.c, line = 767 {Sat Jan  5 19:45:16 2008 }^M
Debug Hang :ClientProcListener (PID=14252)  UnRegistered with watchdog daemon. {Sat Jan  5 19:45:16 2008 }^M
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = ClientProcListener:393226 file = unixinc.c, line = 767 {Sat Jan  5 19:45:16 2008 }^M
Debug Hang :ClientProcListener (PID=14213)  UnRegistered with watchdog daemon. {Sat Jan  5 19:45:16 2008 }^M
Debug Hang :ClientProcListener (PID=27645):Registered with watchdog daemon. {Sat Jan  5 19:54:53 2008 }^M
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = ClientProcListener:2015241 file = unixinc.c, line = 767 {Sat Jan  5 19:54:53 2008 }^M
Debug Hang :ClientProcListener (PID=27645)  UnRegistered with watchdog daemon. {Sat Jan  5 19:54:53 2008 }^M
Debug Hang :ClientProcListener (PID=27646):Registered with watchdog daemon. {Sat Jan  5 19:54:53 2008 }^M
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = ClientProcListener:2031626 file = unixinc.c, line = 767 {Sat Jan  5 19:54:53 2008 }^M
Debug Hang :ClientProcListener (PID=27646)  UnRegist
花好月不圆的个人空间 花好月不圆 发布于2008-01-05 21:06:33
clusterware是9204软件安装的 。


9207 没有　clusterware 的补丁？理论上　clusterware 版本>=db版本把
春暖花开 tolywang 发布于2008-01-05 21:22:50

QUOTE:

原帖由 花好月不圆 于 2008-1-5 21:06 发表
clusterware是9204软件安装的 。


9207 没有　clusterware 的补丁？理论上　clusterware 版本>=db版本把
不知道是不是这个原因，原来  9204 RAC 没有发生过这个事情 。 这次升级后1周就出现了。
春暖花开 tolywang 发布于2008-01-05 21:30:42

QUOTE:

原帖由 花好月不圆 于 2008-1-5 21:06 发表
clusterware是9204软件安装的 。


9207 没有　clusterware 的补丁？理论上　clusterware 版本>=db版本把
p4163445_92070_LINUX.zip        9207patch  .  


看了一下 9207 patch执行画面  , 发现没有clusterware这一项。
9207patch.jpg

9207patch.jpg

春暖花开 tolywang 发布于2008-01-05 21:42:11
如何  deinstall   the    patch  ？  降为 9204
春暖花开 tolywang 发布于2008-01-05 22:06:33
Bug No.6028803
Filed02-MAY-2007Updated12-JUN-2007
ProductOracle Server - Enterprise EditionProduct Version 9.2.0.8
PlatformLinux x86Platform VersionRHAS 3
Database Version9.2.0.8Affects Platforms Port-Specific
Severity Minimal Loss of ServiceStatusNot a Bug. To Filer
Base BugN/AFixed in Product VersionNo Data
Problem statement:

LMON TERMINIATING WITH ERROR ORA-29702
*** 05/02/07 05:40 am ***
TAR:
----
.
PROBLEM:
--------
On 9.2.0.8.0 in Production:
Every now and then LMON is terminating the instance,
the following error occurs:
.
ERROR
-----------------------
ORA-29702 error occurred in Cluster Group Service operation
.
-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Suddenly the error ORA-29702 appeared.
2. LMON terminated the instance.
.
DIAGNOSTIC ANALYSIS:
--------------------
Alert Log: node#2
-------------
.
Sun Apr 15 00:21:22 2007
Errors in file  
/home/oracle/app/product/9.2.0.5.0/rdbms/log/somprd2_lmon_21839.trc:
ORA-29702 : error occurred in Cluster Group Service operation
Sun Apr 15 00:21:22 2007
LMON: terminating instance due to error 29702
Sun Apr 15 00:21:22 2007
System state dump is made for local instance
Sun Apr 15 00:21:27 2007
Instance terminated by LMON, pid = 21839
.
WORKAROUND:
-----------
N/A
.
RELATED BUGS:
-------------
.
REPRODUCIBILITY:
----------------
occurs every now and then.
.
TEST CASE:
----------
N/A
.
STACK TRACE:
------------
.
SUPPORTING INFORMATION:
-----------------------
.
24 HOUR CONTACT INFORMATION FOR P1 BUGS:
----------------------------------------
.
DIAL-IN INFORMATION:
--------------------
.
IMPACT DATE:
------------
.
*** 05/02/07 05:41 am ***
Log File: cm.log on node#2
-----------
.
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = 850771996  
file = unixinc.c, line = 833 {Sun Apr 15 00:19:16 2007 }
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = 850788369  
file = unixinc.c, line = 833 {Sun Apr 15 00:19:52 2007 }
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = 850804764  
file = unixinc.c, line = 833 {Sun Apr 15 00:19:53 2007 }
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = 850821137  
file = unixinc.c, line = 833 {Sun Apr 15 00:20:41 2007 }
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = 850837532  
file = unixinc.c, line = 833 {Sun Apr 15 00:20:41 2007 }
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = 850853905  
file = unixinc.c, line = 833 {Sun Apr 15 00:20:51 2007 }
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = 850870300  
file = unixinc.c, line = 833 {Sun Apr 15 00:20:51 2007 }
>WARNING:  ReadCommPort: received error=104 on recv()., tid = 756793359 file  
= unixinc.c, line = 841 {Sun Apr 15 00:21:22 2007 }
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = 848773149  
file = unixinc.c, line = 833 {Sun Apr 15 00:21:22 2007 }
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = 850116629  
file = unixinc.c, line = 833 {Sun Apr 15 00:21:22 2007 }
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = 757022747  
file = unixinc.c, line = 833 {Sun Apr 15 00:21:22 2007 }
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = 756989978  
file = unixinc.c, line = 833 {Sun Apr 15 00:21:22 2007 }
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = 784973857  
file = unixinc.c, line = 833 {Sun Apr 15 00:21:22 2007 }
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = 757055504  
file = unixinc.c, line = 833 {Sun Apr 15 00:21:22 2007 }
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = 847069206  
file = unixinc.c, line = 833 {Sun Apr 15 00:21:22 2007 }
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = 816824340  
file = unixinc.c, line = 833 {Sun Apr 15 00:21:22 2007 }
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = 756973593  
file = unixinc.c, line = 833 {Sun Apr 15 00:21:22 2007 }
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = 757317642  
file = unixinc.c, line = 833 {Sun Apr 15 00:21:22 2007 }
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = 756957208  
file = unixinc.c, line = 833 {Sun Apr 15 00:21:22 2007 }
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = 757006345  
file = unixinc.c, line = 833 {Sun Apr 15 00:21:22 2007 }
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = 757039122  
file = unixinc.c, line = 833 {Sun Apr 15 00:21:2 2 2007 }
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = 757088275  
file = unixinc.c, line = 833 {Sun Apr 15 00:21:22 2007 }
>ERROR:    WriteEventPort: write failed with error 32., tid = 757088275 file  
= unixinc.c, line = 981 {Sun Apr 15 00:21:22 2007 }
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = 756940823  
file = unixinc.c, line = 833 {Sun Apr 15 00:21:22 2007 }
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = 756760590  
file = unixinc.c, line = 833 {Sun Apr 15 00:21:22 2007 }
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = 850886665  
file = unixinc.c, line = 833 {Sun Apr 15 05:54:16 2007 }
>WARNING:  ReadCommPort:  socket closed by peer on recv()., tid = 850903050  
file = unixinc.c, line = 833 {Sun Apr 15 05:54:16 2007 }
*** 05/02/07 05:42 am ***
.
.
libskgxn9: node#1:
-rwxr-xr-x    1 oracle   oinstall    65236 Apr  8 06:34  
/home/oracle/app/product/9.2.0.5.0/lib/libskgxn9.so
.
libskgxn9: node#2:
-rwxr-xr-x    1 oracle   oinstall    64274 Mar 11  2004  
/home/oracle/app/product/9.2.0.5.0/lib/libskgxn9.so
.
ls -al $ORACLE_HOME/bin/ora* : node#1
-rwxr-xr-x    1 oracle   oinstall       46 Nov 20  2001  
/home/oracle/app/product/9.2.0.5.0/bin/oracg
-rwsr-s--x    1 oracle   oinstall 53734840 Apr  8 07:23  
/home/oracle/app/product/9.2.0.5.0/bin/oracle
-rwsr-s--x    1 oracle   oinstall 53734840 Apr  8 07:20  
/home/oracle/app/product/9.2.0.5.0/bin/oracleO
-rwxr-xr-x    1 oracle   oinstall     2548 Jul 26  2003  
/home/oracle/app/product/9.2.0.5.0/bin/oraenv
.
.
ls -al $ORACLE_HOME/bin/ora* : node#2
-rwxr-xr-x    1 oracle   oinstall       46 Nov 20  2001  
/home/oracle/app/product/9.2.0.5.0/bin/oracg
-rwsr-s--x    1 oracle   oinstall 53734840 Apr  8 07:23  
/home/oracle/app/product/9.2.0.5.0/bin/oracle
-rwsr-s--x    1 oracle   oinstall 53735479 Apr  8 06:35  
/home/oracle/app/product/9.2.0.5.0/bin/oracleO
-rwsr-s--x    1 oracle   oinstall 52999216 May 15  2005  
/home/oracle/app/product/9.2.0.5.0/bin/oracleO.bak
-rwxr-xr-x    1 oracle   oinstall     2548 Jul 26  2003  
/home/oracle/app/product/9.2.0.5.0/bin/oraenv
*** 05/09/07 08:26 am *** (CHG: Sta->16)
*** 05/09/07 08:26 am ***
uploaded the following files:
RDA.RDA_somprd1.zip
RDA.RDA_somprd2.zip
alert_traces.zip
.
Thanks in advance
*** 05/09/07 09:13 pm *** (CHG: Sta->10)
*** 05/09/07 09:14 pm ***
*** 05/14/07 05:09 am ***
This is what happenened in a previous time. The same ORA-29702 happened, it  
can be seen in LMON trace log:
*** SESSION ID3.1) 2007-04-13 10:45:27.324
GES IPC: Receivers 3  Senders 3  
GES IPC: Buffers  Receive 1000  Send (i:660 b:660) Reserve 430
GES IPC: Msg Size  Regular 396  Batch 2048
Batch msg size = 2048
Batching factor: enqueue replay 48, ack 53
Batching factor: cache replay 34 size per lock 56
kjxggin: receive buffer size = 32768
kjxgmin: SKGXN ver (2 1 Oracle 9i Reference CM)
CMCLI WARNING: CMInitContext:  init ctx(0xccfb358)
*** 2007-04-13 10:45:31.439
kjxgmrcfg: Reconfiguration started, reason 1
kjxgmcs: Setting state to 0 0.
*** 2007-04-13 10:45:31.441
     Name Service frozen
kjxgmcs: Setting state to 0 1.
kjfcpiora: publish my weight 62874
kjxgmps: proposing substate 2
kjxgmcs: Setting state to 6 2.
     Performed the unique instance identification check
kjxgmps: proposing substate 3
kjxgmcs: Setting state to 6 3.
     Name Service recovery started
     Deleted all dead-instance name entries
kjxgmps: proposing substate 4
kjxgmcs: Setting state to 6 4.
     Multicasted all local name entries for publish
     Replayed all pending requests
kjxgmps: proposing substate 5
kjxgmcs: Setting state to 6 5.
     Name Service normal
     Name Service recovery done
*** 2007-04-13 10:45:32.808
kjxgmps: proposing substate 6
kjxgmcs: Setting state to 6 6.
*** 2007-04-13 10:45:32.920
*** 2007-04-13 10:45:32.920
Reconfiguration started (old inc 0, new inc 6)
Synchronization timeout interval: 660 sec
List of nodes:
0 1
Global Resource Directory frozen
node 0
release 9 2 0 8
node 1
release 9 2 0 8
res_master_weight for node 0 is 62874
res_master_weight for node 1 is 62874
Total master weight = 125748
Dead  inst  
Join  inst 0 1  
Exist inst  
Active Sendback Threshold = 50 %
Communication channels reestablished
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
Resources and enqueues cleaned out
Resources remastered 0
0 GCS shadows traversed, 0 cancelled, 0 closed
0 GCS resources traversed, 0 cancelled
set master node info  
Submitted all remote-enqueue requests
kjfcrfg: Number of mesgs sent to node 0 = 0
Update rdomain variables
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
*** 2007-04-13 10:45:34.508
0 GCS shadows traversed, 0 replayed, 0 unopened
Submitted all GCS cache requests
0 write requests issued in 31086 GCS resources
7 PIs marked suspect, 0 flush PI msgs
*** 2007-04-13 10:45:34.775
Reconfiguration complete
*** 2007-04-13 10:45:39.636
kjxgrtmc2: Member 1 thread 2 mounted
CMCLI WARNING: ReadCommPort: poll() failed
kjxggpoll: received an error event from DBALL_DB
Return code from kjxggpoll: 10
error 29702 detected in background process
ORA-29702: error occurred in Cluster Group Service operation
ksuitm: waiting for [5] seconds before killing DIAG
.
.
--
The concern here that when checking the libskgxn9.so library on both nodes,  
they are not the same. So may be when the reconfiguration happened the issue  
appeared.
.
The same time the ORA-29702 appeared in alert log these errors appeared in  
cm.log:
>WARNING:  ReadCommPort: received error=104 on recv()., tid = 756793359 file  
= unixinc.c, line = 841 {Sun Apr 15 00:21:22 2007 }  
>ERROR:    WriteEventPort: write failed with error 32., tid = 757088275 file  
= unixinc.c, line = 981 {Sun Apr 15 00:21:22 2007 }  
.
This happened in the node which has a wrong libskgxn9.so library.
.
Thanks
*** 05/14/07 05:10 am *** (CHG: Sta->16)
*** 05/23/07 07:24 am ***
Hi,
Could you please provide an update?
.
Thanks
Amr
*** 05/30/07 10:45 am *** (CHG: G/P->P Asg->NEW OWNER)
*** 05/30/07 10:45 am ***
*** 06/04/07 06:42 am *** (CHG: Asg->NEW OWNER)
*** 06/04/07 06:42 am ***
*** 06/04/07 08:34 am ***
*** 06/04/07 08:34 am *** (CHG: Sta->10)
*** 06/11/07 08:43 am *** (CHG: Sta->16)
*** 06/11/07 08:43 am ***
*** 06/12/07 07:51 am ***
*** 06/12/07 07:52 am *** (CHG: Sta->32)


jieyancai发布于2008-01-05 23:12:50

QUOTE:

原帖由 tolywang 于 2008-1-5 21:42 发表
如何  deinstall   the    patch  ？  降为 9204
除了用升级前的备份，没别的办法吧。
没别的招那么就只能导出数据，重建库了。

[ 本帖最后由 jieyancai 于 2008-1-5 23:14 编辑 ]
OZ的个人空间 OZ 发布于2008-01-05 23:37:36
可以参照这个http://www.bibts.com/-t1027778.htm
主机名添加到client的hosts文件后测试一下，还会提示你说的错误么？
yangtingkun的个人空间 yangtingkun 发布于2008-01-05 23:43:39
从metalink上面的错误描述上看，似乎是由于rac环境两个实例的libskgxn9.so不一致造成的。

你不妨先检查一下，这两个文件是否完全一致。

这个错误很可能是你升级rac环境时造成的
liuxuejunjx发布于2008-01-06 12:41:56

QUOTE:

原帖由 tolywang 于 2008-1-5 21:30 发表



p4163445_92070_LINUX.zip        9207patch  .  


看了一下 9207 patch执行画面  , 发现没有clusterware这一项。
在oracle9i里面不叫clusterware，而是oracle cluster manager，简称ORACM
要升级这个，首先要升级OUI，然后再升级ORACM
升级OUI就不说了
要想升级ORACM，到你解压的patch下，/Disk1/oracm
运行 ./runInstaller
仔细看看readme和metalink上的相关文档吧
呵呵，一般升级都会先在测试环境，从头到位仔细做一次，兄弟你有些大意了
春暖花开 tolywang 发布于2008-01-07 08:20:56

QUOTE:

原帖由 liuxuejunjx 于 2008-1-6 12:41 发表


在oracle9i里面不叫clusterware，而是oracle cluster manager，简称ORACM
要升级这个，首先要升级OUI，然后再升级ORACM
升级OUI就不说了
要想升级ORACM，到你解压的patch下，/Disk1/oracm
运行 ./runInstaller
仔细看看readme和metalink上的相关文档吧
呵呵，一般升级都会先在测试环境，从头到位仔细做一次，兄弟你有些大意了
是大意了， 以为oracm版本不是太重要。 只要能实现cluster就行，没有想到还有这么一个错误。

准备在测试环境先升级oracm看看（其他都升级完成），不知道这样升级会有啥后果。

数据库正在使用，停机备份，然后停机直接升级oracm 不知道会有否有很大风险？
春暖花开 tolywang 发布于2008-01-07 09:08:34

QUOTE:

原帖由 yangtingkun 于 2008-1-5 23:43 发表
从metalink上面的错误描述上看，似乎是由于rac环境两个实例的libskgxn9.so不一致造成的。

你不妨先检查一下，这两个文件是否完全一致。

这个错误很可能是你升级rac环境时造成的
两个实例的libskgxn9.so ？      两个文件是一样的，大小，时间几乎都是一致的。  

使用Oracle9207 数据库，   用Oracle9204 ORACM 不行 ？ 这个时候升级oracm应该不会覆盖掉oracm中的配置吧？
lib.jpg

lib.jpg

春暖花开 tolywang 发布于2008-01-07 09:49:06
Bug No.        5716512
Filed        14-DEC-2006        Updated        27-DEC-2007
Product        Oracle Server - Enterprise Edition        Product Version         9.2.0.7.0
Platform        Linux x86        Platform Version        No Data
Database Version        9.2.0.7.0        Affects Platforms         Port-Specific
Severity         Severe Loss of Service        Status        Closed, Vendor OS Problem
Base Bug        N/A        Fixed in Product Version        No Data

Problem statement:

ORA-29702 WRITEEVENTPORT: WRITE FAILED WITH ERROR 32
________________________________________
*** 12/14/06 07:15 am ***
TAR:
----
PROBLEM:
--------
Customer is hitting 29702 error
    Mon Dec  4 11:41:52 2006
    Errors in file /home/ora920/admin/SEJOUR/bdump/sejou2_lmon_7737.trc:
    ORA-29702: error occurred in Cluster Group Service operation
    Mon Dec  4 11:41:52 2006
    LMON: terminating instance due to error 29702
    Mon Dec  4 11:41:53 2006
    System state dump is made for local instance
    Mon Dec  4 11:41:57 2006
    Instance terminated by LMON, pid = 7737
Checked for the  Cluster ORACM logs it is  showing
    ERROR:    WriteEventPort: write failed with error  32., tid =
    ClientProcListener:-1436087376 file = unixinc.c, line = 981 {Mon Dec  4
    11:41:52 2006 }
.
DIAGNOSTIC ANALYSIS:
--------------------
Tried setting all the kernel parameter to 1MB
.
WORKAROUND:
-----------
NA
.
RELATED BUGS:
-------------
.
REPRODUCIBILITY:
----------------
.
TEST CASE:
----------
.
STACK TRACE:
------------
.
SUPPORTING INFORMATION:
-----------------------
.
24 HOUR CONTACT INFORMATION FOR P1 BUGS:
----------------------------------------
.
DIAL-IN INFORMATION:
--------------------
.
IMPACT DATE:
------------
.
*** 12/14/06 09:40 am *** (CHG: Sta-&gt;16)
*** 12/18/06 07:22 am *** (CHG: G/P-&gt;P Asg-&gt;NEW OWNER)
*** 12/18/06 07:22 am ***
*** 12/19/06 02:59 am *** (CHG: Asg-&gt;NEW OWNER)
*** 12/19/06 02:59 am ***
*** 12/20/06 07:09 am *** (CHG: Sta-&gt;10)
*** 12/20/06 07:09 am ***
*** 01/08/07 09:06 am ***
*** 01/08/07 09:06 am *** (CHG: Sta-&gt;16)
*** 01/15/07 08:05 am *** (CHG: Sta-&gt;10)
*** 01/15/07 08:05 am ***
*** 02/15/07 03:36 am ***
*** 02/15/07 03:36 am *** (CHG: Sta-&gt;16)
*** 03/19/07 03:06 pm ***
*** 03/19/07 03:06 pm *** (CHG: Sta-&gt;45)
*** 03/19/07 03:07 pm ***
*** 12/27/07 01:47 am *** (CHG: Sta-&gt;95)
春暖花开 tolywang 发布于2008-01-07 10:46:11
晕，  9208 的数据库升级patch  oracm 和 db software就是放在一起的。  
9208.jpg

9208.jpg

春暖花开 tolywang 发布于2008-01-07 10:50:12
9.2.0.7 升级包需要单独运行 oracm  .  
9207.jpg

9207.jpg

春暖花开 tolywang 发布于2008-01-07 10:55:17
10g RAC软件和crs升级选项也都是放在一起的， 晕倒
shahand的个人空间 shahand 发布于2008-01-07 11:12:17
嘿嘿  readme不看   经验不可靠  
mustapha的个人空间 mustapha 发布于2008-01-07 11:16:57
呵呵，为省事，直接上9208吧
haorman zuohao_lu 发布于2008-01-07 11:48:16
不懂．帮顶！
春暖花开 tolywang 发布于2008-01-07 13:34:46

QUOTE:

原帖由 liuxuejunjx 于 2008-1-6 12:41 发表


在oracle9i里面不叫clusterware，而是oracle cluster manager，简称ORACM
要升级这个，首先要升级OUI，然后再升级ORACM
升级OUI就不说了
要想升级ORACM，到你解压的patch下，/Disk1/oracm
运行 ./runInstaller
仔细看看readme和metalink上的相关文档吧
呵呵，一般升级都会先在测试环境，从头到位仔细做一次，兄弟你有些大意了
看来不是 ｏｒａｃｍ版本的原因
在安装9207Ｐａｔｃｈ的时候安装到最后会有这个过程，如图：
2.jpg

2.jpg

春暖花开 tolywang 发布于2008-01-07 13:57:51

QUOTE:

原帖由 liuxuejunjx 于 2008-1-6 12:41 发表


在oracle9i里面不叫clusterware，而是oracle cluster manager，简称ORACM
要升级这个，首先要升级OUI，然后再升级ORACM
升级OUI就不说了
要想升级ORACM，到你解压的patch下，/Disk1/oracm
运行 ./runInstaller
仔细看看readme和metalink上的相关文档吧
呵呵，一般升级都会先在测试环境，从头到位仔细做一次，兄弟你有些大意了
到解压的patch下，/Disk1/oracm
运行 ./runInstaller  




发现没有什么可以安装的了，都是 0 KB 大小 。


估计还是bug的问题 。
8.jpg

8.jpg

9.jpg

9.jpg

liuxuejunjx发布于2008-01-07 15:10:33
是否bug是另外一回事情，但是你的安装过程的确没有按照readme里面严格执行
在6 Preinstallation Tasks这一章节里面，尤其是6.2到6.4这些章节里面，专门针对的就是ORACM的
如果你按照readme的先后顺序严格做下来，我不知道你在运行./oracm/runInstaller所遇到的情况是否会再现。
即便出现你所说的情况，在6.2里面的step 9，所描述的的步骤，不知道你是否按照说明，根据你实际情况进行修改后，然后运行过。
Enter the following commands where oracle_home is the Oracle home where you installed Oracle Universal Installer 10.1.0.4:

$ cd oracle_home/oui/bin
$ ./runInstaller -updateNodeList -noClusterEnabled -local ORACLE_HOME=$ORACLE_HOME CLUSTER_NODES=node1,node2,node3


最简单的就是搭建一个新的测试环境，和你生产系统升级之前的环境一样，然后按照readme的说明，从头到尾，逐步执行一下，看看最后是个什么结果。
个人观点，即便是one-off patch，也需要从头到位仔细阅读readme，这种patchset就要更加细致了。

我想必须保证你搭建的环境是没有问题的，在这个基础之上，再去分析碰到具体问题，这样还更省心一些。如果搭建的环境，自己都不能肯定是否没有问题，那么以后管理起这个数据库，自己心里也没底。

以下是引用你碰到的情况：
到解压的patch下，/Disk1/oracm
运行 ./runInstaller  

发现没有什么可以安装的了，都是 0 KB 大小 。


估计还是bug的问题 。 [/quote]
liuxuejunjx发布于2008-01-07 15:17:55
此外你这个版本的readme里面专门提到下面一段话
Note:

You must install the Oracle Cluster Manager patch and configure Oracle Cluster Manager before you install the Oracle9i release 2 Database patch set.
Only one instance of Oracle Cluster Manager can run per node. If the system has multiple Oracle home directories, then make sure to apply the patch to the Oracle home directory where Oracle Cluster Manager is installed.
春暖花开 tolywang 发布于2008-01-07 19:08:07
多谢 。

测试环境已经建立好了，正在测试中，  You must install the Oracle Cluster Manager patch and configure Oracle Cluster Manager before you install the Oracle9i release 2 Database patch set.  

个人觉得 ， 其实这一句主要是需要配置cluster mananger之后才能出现升级oracle软件时候的两个节点信息 ， 所以才会特意提出来让用户注意 。 oracm 和 oracle 软件是不同的路径(没有像windows系统到处注册一些东西) ，oracm是单独的一个目录，不知道是否还有其他地方有记录oracm的相关信息  ？  


-----------------------------------------------  


这个问题在一周会又出现，原来的Oracle9.2.0.4 RAC从来没有这样过 ，估计是升级oracle9.2.0.7 的问题，准备重新
升级一次， 先 oracm ，运行
[size=12.0pt]
[size=12.0pt]$ cd oracle_home/oui/bin
[size=12.0pt]
[size=12.0pt]$ ./runInstaller -updateNodeList -noClusterEnabled -local ORACLE_HOME=$ORACLE_HOME CLUSTER_NODES=DELL-RAC01[size=12.0pt],
[size=12.0pt]DELL-RAC02


[size=12.0pt]然后再次重新升级Oracle9.2.0.7 patch，最后upgrade DB (运行几个脚本，readme有提示) .





[ 本帖最后由 tolywang 于 2008-1-14 11:09 编辑 ]
春暖花开 tolywang 发布于2008-01-14 19:37:28
Oracle Patchset 真是不敢恭維。

Oracle 9.20.7 Patch set 沒有oracm 9.2.0.7 的patch . 還要在9.2.0.6 patch打 。





Subject:  9207 Patchset does not contain OraCM (Oracle Cluster Manager) for RAC
  Doc ID:  Note:359849.1 Type:  PROBLEM
  Last Revision Date:  20-OCT-2006 Status:  PUBLISHED

In this Document
  Symptoms
  Changes
  Cause
  Solution
  References



--------------------------------------------------------------------------------



Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.7.0 to 9.2.0.7.0
Linux x86
Oracle Cluster Manager for RAC only. (OraCM) SymptomsPatchset 9.2.0.7.0 Bug 4163445 (Unpublished Bug) does not contain the 9207 OraCM ChangesInstallation of 9.2.0.7.0 Patchset for RAC only CauseThe 9.2.0.7.0 patchset Bug 4163445 does not contain the OraCM because there was no change from the 9.2.0.6.52 OraCM that was bundled with 9.2.0.6.0 patchset. However it is needed for Customers who are going from older versions like 9.2.0.5.0 to 9.2.0.7.0 (basically skipping the 9.2.0.6.0 version).

SolutionFor Customers who are applying the 9.2.0.7.0 patchset and are currently on 9.2.0.6.0, There are no additional steps. The OraCM version can be checked by


cd $ORACLE_HOME/oracm/log
grep 'version' cm.log
oracm, version[ 9.2.0.6.0.52 ] started {Thu Feb  9 21:35:37 2006 }

If the version is 9.2.0.6.0.52 then no additional steps needs to be performed and Customer can continue applying the 9.2.0.7.0 patchset to the RDBMS

For Customers who are applying the 9.2.0.7.0 Patchset and are on older releases than 9.2.0.6.0 like 9.2.0.4.0 and 9.2.0.5.0. They need to follow the additional steps

Download the 9.2.0.6.0 Patchset (Bug 3948480)
Follow the steps to apply the patch. This will copy the OraCM version 9.2.0.6.0.52 and the libraries.
After OraCM has been upgraded, Start it using ocmstart.sh command
Check the version of the OraCM using the above steps and ensure it is at least 9.2.0.6.0.52
Continue to apply the 9.2.0.7.0 Patch using the steps in the 9.2.0.7.0 readme.
References
李迪发布于2008-01-15 10:12:35

QUOTE:

原帖由 tolywang 于 2008-1-14 19:37 发表
Oracle Patchset 真是不敢恭維。

Oracle 9.20.7 Patch set 沒有oracm 9.2.0.7 的patch . 還要在9.2.0.6 patch打 。
这个在06年给9204RAC升级9208的时候碰到过一次，当时怎么升级都不行，总感觉是不是当时装RAC的时候有问题，后来根据错误代码在META上所搜，才发现9208的补丁包少ORACM，后来只有在9206的补丁集上装ORACM，然后在打9208的补丁集
liuxuejunjx发布于2008-01-15 13:49:27
相信你最后找到的是正解。
呵呵，最后补充几条
1 升级或者应用任何patch，readme必读
2 先在测试环境做
3 遇到任何异常，查找原因
这样避免直接上生产后，给自己带来不必要的麻烦
春暖花开 tolywang 发布于2008-01-15 14:02:02

QUOTE:

原帖由 liuxuejunjx 于 2008-1-15 13:49 发表
相信你最后找到的是正解。
呵呵，最后补充几条
1 升级或者应用任何patch，readme必读
2 先在测试环境做
3 遇到任何异常，查找原因
这样避免直接上生产后，给自己带来不必要的麻烦
是的   

readme 读了，呵呵，不过oracle的readme 没有提示 。这点做的实在是太那啥 。  

查了无数的资料才偶然发现 oracm 9.2.0.7 是没有的，而在 9.2.0.6 patch中，并不是根据那个错误找到的 。

但是每隔 8 天crash 一次，实在是不知道如何测试出来 ，而且测试的系统，没有人使用，是否生产系统有太多ap连接使用而触发bug , 导致crash ,  也不可知 。  

总之是一次教训， 还好， crash 没有太多事情要做，直接重启db就ok 。准备明天找时间升级 9206 oracm , 然后再次升级oracle9.2.0.7 rdbms .        成熟的东西多用，没用过的多测 。 呵呵。   

[ 本帖最后由 tolywang 于 2008-1-15 14:08 编辑 ]
春暖花开 tolywang 发布于2008-01-15 14:06:16

QUOTE:

原帖由 李迪 于 2008-1-15 10:12 发表


  这个在06年给9204RAC升级9208的时候碰到过一次，当时怎么升级都不行，总感觉是不是当时装RAC的时候有问题，后来根据错误代码在META上所搜，才发现9208的补丁包少ORACM，后来只有在9206的补丁集上装ORACM，然后在打9208的补丁集
谢谢分享 。


Oracle至少应该给出 ， RAC下， Oracle RDBMS 升级版本应该和 哪个版本的 ORACM 匹配 ，不然readme没有提示， 用户会以为oracm 9.2.0.2.0 这个版本 （安装ORACLE9.2.0.4 时候的原始ocm版本）就ok了 。 9.2.0.7 Patch也没有指出不包含9207 patch , 结果解压后 9.2.0.7 patch 对应的 Disk1中居然还有一个 oracm 目录 ， 晕 。   
春暖花开 tolywang 发布于2008-01-22 11:35:36
升级ORACM 9.2.0.6 , 然后升级 9207 RDBMS , 后来变成RAC2 节点开始每隔几天 crash一次 。

metalink 给的相似的建议 ：  


WORKAROUND:
-----------
.
1) cd $ORACLE_HOME/rdbms/lib
2) Shut down all the instances in the OH
3) make -f ins_rdbms.mk rac_on ioracle
.
Probably only rac_on is needed.


===================================







Bug No. 5103767
Filed 19-MAR-2006 Updated 23-MAR-2006
Product Oracle Server - Enterprise Edition Product Version 9.2.0.7
Platform Linux Itanium Platform Version RHKERNEL V52
Database Version 9.2.0.7 Affects Platforms Port-Specific
Severity Complete Loss of Service Status Closed, Not a Bug
Base Bug N/A Fixed in Product Version No Data

Problem statement:

INSTANCE TERMINATED BY LMON DUE TO ORA-29702
________________________________________
*** 03/19/06 02:49 am ***
TAR:
----
5243920.993
.
PROBLEM:
--------
Customer is experiencing instance crashes quite often due to 29702 error
The workaround from Bug 4390716 relink rac_on has tried but it did not help.
Make log shows that rac_on went fine no errors.
.
The oracm version is oracm, version[ 9.2.0.7.0.52 ]
The oracm does not crash when the second instance gets the ora-29702
- customer is using a switch and not a cross over cable for interconnect.
- Misscount is 30
.
DIAGNOSTIC ANALYSIS:
--------------------
eiserv02_lms0_12319.trc
------------------------------------
*** SESSION ID5.1) 2006-03-19 04:29:06.745
*** 2006-03-19 04:29:06.745
ksedmp: internal or fatal error
ORA-29702: error occurred in Cluster Group Service operation
Function List
============
ksedmp ksddoa ksdpcg ksdpec PGOSF34_ksfpec kgesev
ksesec0 ksliwat kslwaitns kskthbwt kslwait ksxprcv
kjctr_rksxp kjctrcv kjcsrmg kjmsm ksbrdp opirip
opidrv sou2o main libc_start_main start fini
25742096
eiserv02_diag_12311.trc
--------------------------------------
*** 2006-03-19 04:29:20.264
Trace dumping is done
Instance is terminating by process 12315 [ospid=oracle@fyne (LMON)]
Dump system state for local instance only
CMCLI WARNING: CommonContextCleanup: closing comm port
DIAG detachs from CM
error 29723 detected in background process
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-29723: Failed to attach to the global enqueue service (status=32)
.
WORKAROUND:
-----------
none at a moment cause relink rac_on did not help
.
RELATED BUGS:
-------------
4390716
.
REPRODUCIBILITY:
----------------
.
TEST CASE:
----------
.
STACK TRACE:
------------
.
SUPPORTING INFORMATION:
-----------------------
.
24 HOUR CONTACT INFORMATION FOR P1 BUGS:
----------------------------------------
.
DIAL-IN INFORMATION:
--------------------
.
IMPACT DATE:
------------
.
*** 03/19/06 02:56 am ***
*** 03/19/06 03:03 am *** (CHG: Pri->1)
*** 03/19/06 03:03 am ***
*** 03/19/06 03:26 am ***
*** 03/19/06 03:28 am *** (CHG: Sta->16 G/P->G)
*** 03/19/06 08:31 am *** (CHG: G/P->P)
*** 03/19/06 08:31 am ***





======================


Bug No. 4390716

Filed 24-MAY-2005 Updated 20-SEP-2007
Product Oracle Server - Enterprise Edition Product Version 9.2.0.6
Platform Linux x86 Platform Version 2.1
Database Version 9.2.0.6 Affects Platforms Port-Specific
Severity Severe Loss of Service Status Suspended, Req'd Info not Avail
Base Bug 4220403
Fixed in Product Version No Data

Problem statement:

LOTS OF TRACE FILES SEEN AFTER UPGRADING TO 9.2.0.6
________________________________________
*** 05/24/05 12:28 pm ***
TAR:
----
.
PROBLEM:
--------
This is essentially the same reported problem as seen in bug4220403.
.
After upgrading to 9.2.0.6 from 9.2.0.5 the customers udump directory fills
up with trace files.
.
Trace files contain:
.
*** SESSION ID10.9) 2005-03-18 16:07:29.616
CMCLI WARNING: CMInitContext: init ctx(0xae5c9a4)
CMCLI WARNING: CommonContextCleanup: closing comm port
.
DIAGNOSTIC ANALYSIS:
--------------------
The procedure of relinking using rac_on resolved the isssue for the customer
but this is seen as severe as the files were filling up the fileystem and
made it very hard to track down trace files for other issues.
.
So the understanding of the problem is this. After you upgrade to 9.2.0.6
since rac_on is not executed if RAC is installed the older libskgxp9.so and
libskgxn9.so are being used.
.
There is no telling how this could really impact customers, and in this
customers case it is possible that this could be the root of some of their
other problems. After relink with rac_on the trace files stopped getting
generated.
.
Looking at the make.log generated from the patch install rac_on is never
issued.
.
WORKAROUND:
-----------
.
1) cd $ORACLE_HOME/rdbms/lib
2) Shut down all the instances in the OH
3) make -f ins_rdbms.mk rac_on ioracle
.
Probably only rac_on is needed.
.
RELATED BUGS:
-------------
BUG:4220403
.
REPRODUCIBILITY:
----------------
Always reproducible. May be more of an issue for Linux since both the
libskgxn and libskgxp are both shipped.
.
TEST CASE:
----------
Simple, install 9.2.0.4 then upgrade to 9.2.0.5, then to 9.2.0.6. Have not
tested other combinations.
.
STACK TRACE:
------------
.
SUPPORTING INFORMATION:
-----------------------
.
24 HOUR CONTACT INFORMATION FOR P1 BUGS:
----------------------------------------
.
DIAL-IN INFORMATION:
--------------------
.
IMPACT DATE:
------------
.
*** 05/24/05 12:28 pm *** (CHG: Asg->NEW OWNER)
*** 05/24/05 12:28 pm *** (CHG: Sta->11)
*** 05/24/05 12:29 pm ***
*** 05/24/05 10:09 pm *** (CHG: FixBy->9.2.0.7.0)
*** 05/24/05 10:09 pm *** (CHG: Asg->NEW OWNER)
*** 05/25/05 01:00 pm *** (CHG: Asg->NEW OWNER)
*** 08/09/05 11:39 pm *** (CHG: Asg->NEW OWNER)
*** 08/09/05 11:39 pm ***
*** 09/08/05 10:28 pm *** (CHG: FixBy->9.2.0.7PL)
*** 09/08/05 10:48 pm ***
*** 09/13/05 12:08 am ***
*** 09/13/05 02:12 am ***
*** 09/14/05 02:17 pm *** (CHG: Fixed->9.2.0.7)
*** 09/14/05 02:17 pm *** (CHG: Sta->35 Asg->NEW OWNER)
*** 09/14/05 02:17 pm ***
added the relinking of rac_on and ioracle. Please test on rac scenario and
update.
*** 12/09/05 06:45 am *** (CHG: Sta->16)
*** 12/09/05 06:45 am ***
*** 12/09/05 09:33 am ***
*** 12/09/05 09:34 am ***
*** 12/09/05 09:34 am *** (CHG: Asg->NEW OWNER)
*** 12/09/05 09:35 am *** (CHG: Sta->11)
*** 12/09/05 09:35 am ***
*** 05/02/06 08:03 am ***
*** 05/02/06 09:01 am ***
*** 05/02/06 09:13 am ***
*** 05/05/06 04:32 am *** (CHG: Asg->NEW OWNER)
*** 05/05/06 04:32 am ***
It seems the oracm or it's related libraries that are mentioned below with
9207
maybe not be existing only then will those CMCLI WARNING show up
according to rac dev.
.
4058819161 671963 cm
1667821770 65236 libcmdll.so
847200908 8219 libwddapi.so
.
please reply after verifying with the above 9207 libraries.
*** 05/08/06 07:35 am ***
*** 05/08/06 07:36 am *** (CHG: Asg->NEW OWNER)
*** 09/20/07 03:10 am *** (CHG: Sta->33)
*** 09/20/07 03:10 am ***
*** 09/20/07 03:10 am *** (CHG: Asg->NEW OWNER)
我来说两句

(可选)

日历

« 2008-10-16  
日 一 二 三 四 五 六
   1234
567891011
12131415161718
19202122232425
262728293031 

数据统计

  • 访问量: 30176
  • 日志数: 1427
  • 图片数: 5
  • 书签数: 1
  • 建立时间: 2007-12-10
  • 更新时间: 2008-09-19

RSS订阅

Open Toolbar