Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

8

积分

0

好友

0

主题
1#
发表于 2012-1-11 23:18:34 | 查看: 6479| 回复: 2
在aix 6.1 上安装ora  10g rac 的时候,在一个几点运行root.sh 的时候,报如下错误:

Operation successful.
Now formatting voting device: /dev/rora_vote1
Now formatting voting device: /dev/rora_vote2
Now formatting voting device: /dev/rora_vote3
Format of 3 voting devices complete.
Startup will be queued to init within 30 seconds.
Adding daemons to inittab
Adding daemons to inittab
Expecting the CRS daemons to be up within 600 seconds.


Failure at final check of Oracle CRS stack.
0

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

查看ocssd.log

Oracle Database 10g CRS Release 10.2.0.1.0 Production Copyright 1996, 2005 Oracle.  All rights reserved.
[    CSSD]2012-01-11 20:40:35.975 >USER:    Oracle Database 10g CSS Release 10.2.0.1.0 Production Copyright 1996, 2004 Oracle.  All rights reserved.
[  clsdmt]Listening to (ADDRESS=(PROTOCOL=ipc)(KEY=menhudb1DBG_CSSD))
[    CSSD]2012-01-11 20:40:35.975 >USER:    CSS daemon log for node menhudb1, number 1, in cluster crs
[    CSSD]2012-01-11 20:40:36.012 [1] >TRACE:   clssscmain: local-only set to false
[    CSSD]2012-01-11 20:40:36.017 [1] >TRACE:   clssnmReadNodeInfo: added node 1 (menhudb1) to cluster
[    CSSD]2012-01-11 20:40:36.021 [1] >TRACE:   clssnmReadNodeInfo: added node 2 (menhudb2) to cluster
[    CSSD]2012-01-11 20:40:36.026 [1029] >TRACE:   clssnm_skgxninit: initialized skgxn version (2/0/IBM AIX skgxn
)
[    CSSD]2012-01-11 20:40:36.058 [1029] >ERROR:   clssnm_skgxnmon: Failure 0 registering.(1/1 [HA_GS_NOT_OK]/sskgxn_gs_in)
[    CSSD]2012-01-11 20:40:36.060 [1] >TRACE:   clssnmInitNMInfo: misscount set to 600
[    CSSD]2012-01-11 20:40:36.062 [1] >TRACE:   clssnmDiskStateChange: state from 1 to 2 disk (0//dev/rora_vote1)
[    CSSD]2012-01-11 20:40:36.063 [1] >TRACE:   clssnmDiskStateChange: state from 1 to 2 disk (1//dev/rora_vote2)
[    CSSD]2012-01-11 20:40:36.064 [1] >TRACE:   clssnmDiskStateChange: state from 1 to 2 disk (2//dev/rora_vote3)
[    CSSD]2012-01-11 20:40:38.063 [1030] >TRACE:   clssnmDiskStateChange: state from 2 to 4 disk (0//dev/rora_vote1)
[    CSSD]2012-01-11 20:40:38.065 [1287] >TRACE:   clssnmDiskStateChange: state from 2 to 4 disk (1//dev/rora_vote2)
[    CSSD]2012-01-11 20:40:38.066 [1544] >TRACE:   clssnmDiskStateChange: state from 2 to 4 disk (2//dev/rora_vote3)
[    CSSD]2012-01-11 20:40:38.169 [1] >TRACE:   clssscSclsFatal: read value of disable
[    CSSD]2012-01-11 20:40:38.170 [2058] >TRACE:   clssnmFatalThread: spawned
[    CSSD]2012-01-11 20:40:38.170 [1] >TRACE:   clssscSclsFatal: read value of disable
[    CSSD]2012-01-11 20:40:38.170 [2315] >TRACE:   clssnmconnect: connecting to node 1, flags 0x0001, connector 1
[    CSSD]2012-01-11 20:40:38.213 [2572] >TRACE:   clssgmclientlsnr: listening on (ADDRESS=(PROTOCOL=ipc)(KEY=Oracle_CSS_LclLstnr_crs_1))
[    CSSD]2012-01-11 20:40:38.213 [2572] >TRACE:   clssgmclientlsnr: listening on (ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_menhudb1_crs))
[    CSSD]2012-01-11 20:40:38.222 [3600] >TRACE:   clssnmPollingThread: Connection complete
[    CSSD]2012-01-11 20:40:38.222 [3857] >TRACE:   clssnmSendingThread: Connection complete
[    CSSD]2012-01-11 20:40:38.222 [4114] >TRACE:   clssnmRcfgMgrThread: Connection complete
[    CSSD]2012-01-11 20:40:38.222 [4114] >TRACE:   clssnmRcfgMgrThread: Local Join
[    CSSD]2012-01-11 20:40:38.222 [4114] >TRACE:   clssnmDoSyncUpdate: Initiating sync 1
[    CSSD]2012-01-11 20:40:38.222 [4114] >TRACE:   clssnmSetupAckWait: Ack message type (11)
[    CSSD]2012-01-11 20:40:38.222 [4114] >TRACE:   clssnmSetupAckWait: node(1) is ALIVE
[    CSSD]2012-01-11 20:40:38.222 [4114] >TRACE:   clssnmSendSync: syncSeqNo(1)
[    CSSD]2012-01-11 20:40:38.223 [4114] >TRACE:   clssnmWaitForAcks: Ack message type(11), ackCount(1)
[    CSSD]2012-01-11 20:40:38.223 [2315] >TRACE:   clssnmHandleSync: Acknowledging sync: src[1] srcName[menhudb1] seq[1] sync[1]
[    CSSD]2012-01-11 20:40:38.322 [1] >USER:    NMEVENT_SUSPEND [00][00][00][00]
[    CSSD]2012-01-11 20:40:39.223 [4114] >TRACE:   clssnmWaitForAcks: done, msg type(11)
[    CSSD]2012-01-11 20:40:39.223 [4114] >TRACE:   clssnmSetupAckWait: Ack message type (13)
[    CSSD]2012-01-11 20:40:39.223 [4114] >TRACE:   clssnmSetupAckWait: node(1) is ACTIVE
[    CSSD]2012-01-11 20:40:39.223 [4114] >TRACE:   clssnmSendVote: syncSeqNo(1)
[    CSSD]2012-01-11 20:40:39.223 [4114] >TRACE:   clssnmWaitForAcks: Ack message type(13), ackCount(1)
[    CSSD]2012-01-11 20:40:39.223 [2315] >TRACE:   clssnmSendVoteInfo: node(1) syncSeqNo(1)
[    CSSD]2012-01-11 20:40:40.223 [4114] >TRACE:   clssnmWaitForAcks: done, msg type(13)
[    CSSD]2012-01-11 20:40:40.223 [4114] >TRACE:   clssnmCheckDskInfo: Checking disk info...
[    CSSD]2012-01-11 20:40:41.223 [4114] >ERROR:   clssnmCheckDskInfo: We appear to be dead skgxn 0
[    CSSD]2012-01-11 20:40:41.223 [4114] >ERROR:   clssnmDoSyncUpdate:  checkDskInfo signaled shutdown
[    CSSD]2012-01-11 20:40:41.223 [4114] >TRACE:   clssscctx:  dump of 0x110075b90, len 3752
[    CSSD]2012-01-11 20:40:41.223 [4114] >TRACE:   0x110075b90 00 00 00 01 10 d2 af 90 - 00 00 00 01 10 ce 15 70 ...............p
[    CSSD]2012-01-11 20:40:41.223 [4114] >TRACE:   0x110075ba0 00 00 00 00 00 00 00 00 - 00 00 00 01 10 07 41 d0 ..............A.
[    CSSD]2012-01-11 20:40:41.223 [4114] >TRACE:   0x110075bb0 00 00 00 01 10 14 aa 70 - 00 00 00 01 10 07 45 b0 .......p......E.

---- crsd.log
Oracle Database 10g CRS Release 10.2.0.1.0 Production Copyright 1996, 2005 Oracle.  All rights reserved.
2012-01-11 20:40:34.711: [ default][1][ENTER]32
Oracle Database 10g CRS Release 10.2.0.1.0 Production Copyright 1996, 2004, Oracle.  All rights reserved
2012-01-11 20:40:34.711: [ default][1]32CRS Daemon Starting
2012-01-11 20:40:34.711: [ CRSMAIN][1]32Checking the OCR device
2012-01-11 20:40:34.715: [ CRSMAIN][1]32Connecting to the CSS Daemon
2012-01-11 20:40:34.742: [ COMMCRS][259]clsc_connect: (110cee490) no listener at (ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_menhudb1_crs))
2012-01-11 20:40:34.742: [ CSSCLNT][1]clsssInitNative: connect failed, rc 9
2012-01-11 20:40:34.743: [  CRSRTI][1]32CSS is not ready. Received status 3 from CSS. Waiting for good status ..
2012-01-11 20:40:35.750: [ COMMCRS][261]clsc_connect: (110cee490) no listener at (ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_menhudb1_crs))
2012-01-11 20:40:35.750: [ CSSCLNT][1]clsssInitNative: connect failed, rc 9

---- evmd.log

Oracle Database 10g CRS Release 10.2.0.1.0 Production Copyright 1996, 2005 Oracle.  All rights reserved.
2012-01-11 20:40:34.645: [    EVMD][1]32EVMD Starting
2012-01-11 20:40:34.673: [    EVMD][1]32
Oracle Database 10g CRS Release 10.2.0.1.0 Production Copyright 1996, 2004, Oracle.  All rights reserved
2012-01-11 20:40:34.705: [ COMMCRS][259]clsc_connect: (110615210) no listener at (ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_menhudb1_crs))
2012-01-11 20:40:34.705: [ CSSCLNT][1]clsssInitNative: connect failed, rc 9
2012-01-11 20:40:34.705: [    EVMD][1]32EVMD waiting for CSS to be ready err = 3
2012-01-11 20:40:35.713: [ COMMCRS][261]clsc_connect: (110615210) no listener at (ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_menhudb1_crs))
2012-01-11 20:40:35.713: [ CSSCLNT][1]clsssInitNative: connect failed, rc 9
2012-01-11 20:40:35.714: [    EVMD][1]32EVMD waiting for CSS to be ready err = 3
2012-01-11 20:40:36.722: [ COMMCRS][263]clsc_connect: (110615210) no listener at (ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_menhudb1_crs))
2012-01-11 20:40:36.723: [ CSSCLNT][1]clsssInitNative: connect failed, rc 9

-----
有谁遇到过该问题,不啬分享,多谢!

crs_error_aix61_20120111.rar

1013.86 KB, 下载次数: 1160

2#
发表于 2012-1-12 19:22:01
[    CSSD]2012-01-11 20:40:36.058 [1029] >ERROR:   clssnm_skgxnmon: Failure 0 registering.(1/1 [HA_GS_NOT_OK]/sskgxn_gs_in)
[    CSSD]2012-01-11 20:40:36.060 [1] >TRACE:   clssnmInitNMInfo: misscount set to 600

=》

出现  clssnm_skgxnmon  说明使用了vendor clusterware  HACMP

clssnm_skgxnmon thread (via clssnmNMInitialize --> clssnmStartClusterListening)
Note: This thread is only persistent if the customer is using vendor clusterware


ODM Data:
  1. CSSD does not Start on AIX (Oracle Clusterware with HACMP) [ID 580467.1]

  2. Applies to:
  3. Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.1 - Release: 10.2 to 10.2
  4. IBM AIX on POWER Systems (64-bit)
  5. AIX5L Based Systems (64-bit)
  6. CRS
  7. RAC
  8. HACMP
  9. Symptoms

  10. Oracle Clusterware installed on top of HACMP cluster, but cssd startup fails with following error message in the ocssd.log:

  11.     [ CSSD]2008-05-27 15:09:43.456 [1029] >TRACE: clssnm_skgxninit: initialized skgxn version (2/0/IBM AIX skgxn)
  12.     [ CSSD]2008-05-27 15:09:43.475 [1029] >ERROR: clssnm_skgxnmon: Failure 0 registering.(1/1 [HA_GS_NOT_OK]/sskgxn_gs_in)
  13.     ..............

  14.     [ CSSD]2008-05-27 15:09:47.554 [3600] >TRACE: clssnmCheckDskInfo: Checking disk info...
  15.     [ CSSD]2008-05-27 15:09:48.554 [3600] >ERROR: clssnmCheckDskInfo: We appear to be dead skgxn 0
  16.     [ CSSD]2008-05-27 15:09:48.554 [3600] >ERROR: clssnmDoSyncUpdate: checkDskInfo signaled shutdown
  17.     [ CSSD]2008-05-27 15:09:48.554 [3600] >TRACE: clssscctx: dump of 0x11000ddf0, len 3752
  18.     [ CSSD]2008-05-27 15:09:48.554 [3600] >TRACE: 0x11000ddf0 00 00 00 01 10 9a 33 90 - 00 00 00 01 10 95 a2 b0

  19.     ............
  20.     [ CSSD]2008-05-28 15:09:58.508 [3600] >TRACE: clssscctx->nmctx->nmnode[002]->nodeData: dump of 0x0, len 0
  21.     [ CSSD]2008-05-28 15:09:58.508 [3600] >TRACE: clssscctx->nmctx->nmnode[002]->con: dump of 0x0, len 976
  22.     [ CSSD]--- DUMP GROCK STATE DB ---
  23.     [ CSSD]--- END OF GROCK STATE DUMP ---

  24. Cause
  25. CSSD dameon is not able to communicate with HACMP .
  26. Solution

  27. Oracle cssd must able to communicate with HACMP cluster.  Therefore the oracle user must be part of the hagsuser group.

  28. Make sure Oracle and Root user are part of the hagsuser group.

  29. Reference:

  30. Oracle� Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide
  31. 10g Release 2 (10.2) for AIX

  32. 2.3.4 Creating a HAGSUSER Group (Optional)

  33. http://download.oracle.com/docs/cd/B19306_01/install.102/b14201/preaix.htm#sthref228
复制代码

回复 只看该作者 道具 举报

3#
发表于 2012-1-12 19:25:01
action plan:

id  oracle              -- 检查oracle用户是否hagsuser组成员

不是的话 创建该hagsuser组,并加入oracle用户

smitty user
smitty group
add oracle user to HAGSUSER Group

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-23 21:10 , Processed in 0.057459 second(s), 25 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569