AIX5.3安裝RAC Oracle10.2.0.1時被忽略的組hagsuser

snowdba發表於2014-09-02
oracle10g在安裝RAC時還不能像oracle11g那樣完全由grid使用者搞定叢集的安裝設定,必須透過hagsuser組來實現。需要將oracle使用者設定為hagsuser的組成員。今天在安裝叢集軟體的是時候在執行root指令碼一直報錯,最終診斷為oracle使用者不在hagsuser組導致。

執行root指令碼
/u01/app/oracle/product/10.2.0/crs_1/root.sh

報錯資訊片段
Failure at final check of Oracle CRS stack.

在建立組的時候要注意這個不能缺少的hagsuser
# mkgroup -'A' id='203' oinstall
# mkgroup -'A' id='204'dba
# mkgroup -'A' id='205'hagsuser


在將oracle使用者加入到hagsuser中
Change / Show Characteristics of a User

Type or select values in entry fields.
Press Enter AFTER making all desired changes.

[TOP]                                                   [Entry Fields]
* User NAME                                           oracle
  User ID                                            [1001]                                                                   #
  ADMINISTRATIVE USER?                                                                                                       +
  Primary GROUP                                      [oinstall]                                                              +
  Group SET                                          [oinstall,dba,hagsuser]                                                 +
  ADMINISTRATIVE GROUPS                              []                                                                      +
  ROLES                                              []                                                                      +
  Another user can SU TO USER?                                                                                               +
  SU GROUPS                                          []                                                                      +
  HOME directory                                     [/home/oracle]
  Initial PROGRAM                                    [/usr/bin/ksh]
  User INFORMATION                                   []
  EXPIRATION date (MMDDhhmmyy)                       []
  Is this user ACCOUNT LOCKED?                                                                                               +
  User can LOGIN?                                                                                                            +
  User can LOGIN REMOTELY(rsh,tn,rlogin)?                                                                                    +
  Allowed LOGIN TIMES                                []
  Number of FAILED LOGINS before                     []                                                                       #
       user account is locked
  Login AUTHENTICATION GRAMMAR                       []
  Valid TTYs                                         []
  Days to WARN USER before password expires          []                                                                       #
  Password CHECK METHODS                             []
  Password DICTIONARY FILES                          []
  NUMBER OF PASSWORDS before reuse                   []                                                                       #
  WEEKS before password reuse                        []                                                                       #
  Weeks between password EXPIRATION and LOCKOUT      []
  Password MAX. AGE                                  []                                                                       #
  Password MIN. AGE                                  []                                                                       #
  Password MIN. LENGTH                               []                                                                       #
  Password MIN. ALPHA characters                     []                                                                       #
  Password MIN. OTHER characters                     []                                                                       #
  Password MAX. REPEATED characters                  []                                                                       #


執行root指令碼失敗的log日誌如下:

# vi /u01/app/oracle/product/10.2.0/crs_1/log/scgl1/cssd/ocssd.log

"/u01/app/oracle/product/10.2.0/crs_1/log/scgl1/cssd/ocssd.log" 6066 lines, 784340 characters (4 null characters)
Oracle Database 10g CRS Release 10.2.0.1.0 Production Copyright 1996, 2005 Oracle.  All rights reserved.
[    CSSD]2014-09-02 21:03:18.877 >USER:    Oracle Database 10g CSS Release 10.2.0.1.0 Production Copyright 1996, 2004 Ora
cle.  All rights reserved.
[    CSSD]2014-09-02 21:03:18.877 >USER:    CSS daemon log for node scgl1, number 1, in cluster crs
[    CSSD]2014-09-02 21:03:18.901 [1] >TRACE:   clssscmain: local-only set to false
[    CSSD]2014-09-02 21:03:18.906 [1] >TRACE:   clssnmReadNodeInfo: added node 1 (scgl1) to cluster
[    CSSD]2014-09-02 21:03:18.910 [1] >TRACE:   clssnmReadNodeInfo: added node 2 (scgl2) to cluster
[    CSSD]2014-09-02 21:03:18.914 [1029] >TRACE:   clssnm_skgxninit: initialized skgxn version (2/0/IBM AIX skgxn
)
[  clsdmt]Listening to (ADDRESS=(PROTOCOL=ipc)(KEY=scgl1DBG_CSSD))
[    CSSD]2014-09-02 21:03:18.953 [1029] >ERROR:   clssnm_skgxnmon: Failure 0 registering.(1/19 [HA_GS_CONNECT_FAILED]/ssk
gxn_gs_in)
[    CSSD]2014-09-02 21:03:18.954 [1] >TRACE:   clssnmInitNMInfo: misscount set to 600
[    CSSD]2014-09-02 21:03:18.957 [1] >TRACE:   clssnmDiskStateChange: state from 1 to 2 disk (0//dev/rora_raw8_1gb)
[    CSSD]2014-09-02 21:03:18.958 [1] >TRACE:   clssnmDiskStateChange: state from 1 to 2 disk (1//dev/rora_raw9_1gb)
[    CSSD]2014-09-02 21:03:18.960 [1] >TRACE:   clssnmDiskStateChange: state from 1 to 2 disk (2//dev/rora_raw10_1gb)
[    CSSD]2014-09-02 21:03:20.958 [1030] >TRACE:   clssnmDiskStateChange: state from 2 to 4 disk (0//dev/rora_raw8_1gb)
[    CSSD]2014-09-02 21:03:20.960 [1287] >TRACE:   clssnmDiskStateChange: state from 2 to 4 disk (1//dev/rora_raw9_1gb)
[    CSSD]2014-09-02 21:03:20.961 [1544] >TRACE:   clssnmDiskStateChange: state from 2 to 4 disk (2//dev/rora_raw10_1gb)
[    CSSD]2014-09-02 21:03:21.015 [1] >TRACE:   clssscSclsFatal: read value of disable
[    CSSD]2014-09-02 21:03:21.015 [2058] >TRACE:   clssnmFatalThread: spawned
[    CSSD]2014-09-02 21:03:21.015 [1] >TRACE:   clssscSclsFatal: read value of disable
[    CSSD]2014-09-02 21:03:21.015 [2315] >TRACE:   clssnmconnect: connecting to node 1, flags 0x0001, connector 1
[    CSSD]2014-09-02 21:03:21.070 [2572] >TRACE:   clssgmclientlsnr: listening on (ADDRESS=(PROTOCOL=ipc)(KEY=Oracle_CSS_L
clLstnr_crs_1))
[    CSSD]2014-09-02 21:03:21.070 [2572] >TRACE:   clssgmclientlsnr: listening on (ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_scg
l1_crs))
[    CSSD]2014-09-02 21:03:21.075 [3600] >TRACE:   clssnmPollingThread: Connection complete
[    CSSD]2014-09-02 21:03:21.076 [3857] >TRACE:   clssnmSendingThread: Connection complete
[    CSSD]2014-09-02 21:03:21.076 [4114] >TRACE:   clssnmRcfgMgrThread: Connection complete
[    CSSD]2014-09-02 21:03:21.076 [4114] >TRACE:   clssnmRcfgMgrThread: Local Join
[    CSSD]2014-09-02 21:03:21.076 [4114] >TRACE:   clssnmDoSyncUpdate: Initiating sync 1
[    CSSD]2014-09-02 21:03:21.076 [4114] >TRACE:   clssnmSetupAckWait: Ack message type (11)
[    CSSD]2014-09-02 21:03:21.076 [4114] >TRACE:   clssnmSetupAckWait: node(1) is ALIVE
[    CSSD]2014-09-02 21:03:21.076 [4114] >TRACE:   clssnmSendSync: syncSeqNo(1)
[    CSSD]2014-09-02 21:03:21.076 [4114] >TRACE:   clssnmWaitForAcks: Ack message type(11), ackCount(1)
[    CSSD]2014-09-02 21:03:21.076 [2315] >TRACE:   clssnmHandleSync: Acknowledging sync: src[1] srcName[scgl1] seq[1] sync
[1]
[    CSSD]2014-09-02 21:03:21.176 [1] >USER:    NMEVENT_SUSPEND [00][00][00][00]
[    CSSD]2014-09-02 21:03:22.085 [4114] >TRACE:   clssnmWaitForAcks: done, msg type(11)
[    CSSD]2014-09-02 21:03:22.085 [4114] >TRACE:   clssnmSetupAckWait: Ack message type (13)
[    CSSD]2014-09-02 21:03:22.085 [4114] >TRACE:   clssnmSetupAckWait: node(1) is ACTIVE
[    CSSD]2014-09-02 21:03:22.085 [4114] >TRACE:   clssnmSendVote: syncSeqNo(1)
"/u01/app/oracle/product/10.2.0/crs_1/log/scgl1/cssd/ocssd.log" 6066 lines, 784340 characters (4 null characters)
Oracle Database 10g CRS Release 10.2.0.1.0 Production Copyright 1996, 2005 Oracle.  All rights reserved.
[    CSSD]2014-09-02 21:03:18.877 >USER:    Oracle Database 10g CSS Release 10.2.0.1.0 Production Copyright 1996, 2004 Oracle.
All rights reserved.
[    CSSD]2014-09-02 21:03:18.877 >USER:    CSS daemon log for node scgl1, number 1, in cluster crs
[    CSSD]2014-09-02 21:03:18.901 [1] >TRACE:   clssscmain: local-only set to false
[    CSSD]2014-09-02 21:03:18.906 [1] >TRACE:   clssnmReadNodeInfo: added node 1 (scgl1) to cluster
[    CSSD]2014-09-02 21:03:18.910 [1] >TRACE:   clssnmReadNodeInfo: added node 2 (scgl2) to cluster
[    CSSD]2014-09-02 21:03:18.914 [1029] >TRACE:   clssnm_skgxninit: initialized skgxn version (2/0/IBM AIX skgxn
)
[  clsdmt]Listening to (ADDRESS=(PROTOCOL=ipc)(KEY=scgl1DBG_CSSD))
[    CSSD]2014-09-02 21:03:18.953 [1029] >ERROR:   clssnm_skgxnmon: Failure 0 registering.(1/19 [HA_GS_CONNECT_FAILED]/sskgxn_gs
_in)
[    CSSD]2014-09-02 21:03:18.954 [1] >TRACE:   clssnmInitNMInfo: misscount set to 600
[    CSSD]2014-09-02 21:03:18.957 [1] >TRACE:   clssnmDiskStateChange: state from 1 to 2 disk (0//dev/rora_raw8_1gb)
[    CSSD]2014-09-02 21:03:18.958 [1] >TRACE:   clssnmDiskStateChange: state from 1 to 2 disk (1//dev/rora_raw9_1gb)
[    CSSD]2014-09-02 21:03:18.960 [1] >TRACE:   clssnmDiskStateChange: state from 1 to 2 disk (2//dev/rora_raw10_1gb)
[    CSSD]2014-09-02 21:03:20.958 [1030] >TRACE:   clssnmDiskStateChange: state from 2 to 4 disk (0//dev/rora_raw8_1gb)
[    CSSD]2014-09-02 21:03:20.960 [1287] >TRACE:   clssnmDiskStateChange: state from 2 to 4 disk (1//dev/rora_raw9_1gb)
[    CSSD]2014-09-02 21:03:20.961 [1544] >TRACE:   clssnmDiskStateChange: state from 2 to 4 disk (2//dev/rora_raw10_1gb)
[    CSSD]2014-09-02 21:03:21.015 [1] >TRACE:   clssscSclsFatal: read value of disable
[    CSSD]2014-09-02 21:03:21.015 [2058] >TRACE:   clssnmFatalThread: spawned
[    CSSD]2014-09-02 21:03:21.015 [1] >TRACE:   clssscSclsFatal: read value of disable
[    CSSD]2014-09-02 21:03:21.015 [2315] >TRACE:   clssnmconnect: connecting to node 1, flags 0x0001, connector 1
[    CSSD]2014-09-02 21:03:21.070 [2572] >TRACE:   clssgmclientlsnr: listening on (ADDRESS=(PROTOCOL=ipc)(KEY=Oracle_CSS_LclLstn
r_crs_1))
[    CSSD]2014-09-02 21:03:21.070 [2572] >TRACE:   clssgmclientlsnr: listening on (ADDRESS=(PROTOCOL=ipc)(KEY=OCSSD_LL_scgl1_crs
))
[    CSSD]2014-09-02 21:03:21.075 [3600] >TRACE:   clssnmPollingThread: Connection complete
[    CSSD]2014-09-02 21:03:21.076 [3857] >TRACE:   clssnmSendingThread: Connection complete
[    CSSD]2014-09-02 21:03:21.076 [4114] >TRACE:   clssnmRcfgMgrThread: Connection complete
[    CSSD]2014-09-02 21:03:21.076 [4114] >TRACE:   clssnmRcfgMgrThread: Local Join
[    CSSD]2014-09-02 21:03:21.076 [4114] >TRACE:   clssnmDoSyncUpdate: Initiating sync 1
[    CSSD]2014-09-02 21:03:21.076 [4114] >TRACE:   clssnmSetupAckWait: Ack message type (11)
[    CSSD]2014-09-02 21:03:21.076 [4114] >TRACE:   clssnmSetupAckWait: node(1) is ALIVE
[    CSSD]2014-09-02 21:03:21.076 [4114] >TRACE:   clssnmSendSync: syncSeqNo(1)
[    CSSD]2014-09-02 21:03:21.076 [4114] >TRACE:   clssnmWaitForAcks: Ack message type(11), ackCount(1)
[    CSSD]2014-09-02 21:03:21.076 [2315] >TRACE:   clssnmHandleSync: Acknowledging sync: src[1] srcName[scgl1] seq[1] sync[1]
[    CSSD]2014-09-02 21:03:21.176 [1] >USER:    NMEVENT_SUSPEND [00][00][00][00]
[    CSSD]2014-09-02 21:03:22.085 [4114] >TRACE:   clssnmWaitForAcks: done, msg type(11)
[    CSSD]2014-09-02 21:03:22.085 [4114] >TRACE:   clssnmSetupAckWait: Ack message type (13)
[    CSSD]2014-09-02 21:03:22.085 [4114] >TRACE:   clssnmSetupAckWait: node(1) is ACTIVE
[    CSSD]2014-09-02 21:03:22.085 [4114] >TRACE:   clssnmSendVote: syncSeqNo(1)

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/29047826/viewspace-1262440/,如需轉載,請註明出處,否則將追究法律責任。

相關文章