[ORACLE] dbca Node Sellection 에서 모든 노드가 뜨지 않는 경우 해결

오류 번호 : PRVG-2019 PRKC-1191 

이런 경우는 자주 없는 것 같은데 해결방안 써봄다..

 

일단 내 상황

2 node 환경에서 OS hostname 변경을 위해

1번 노드 delete node 했다가 hostname 변경하고 다시 add node 만들고

2번 노드 delete node 했다가 hostname 변경하고 다시 add node 만들었음

그 후 여기에다가 dbca 진행할려 했더니 Node Selection 파트에서 모든 노드가 안나오는 상황이 발생

[racdr1|root:/root]> crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
               ONLINE  ONLINE       racdr1                   STABLE
               ONLINE  ONLINE       racdr2                   STABLE
ora.chad
               ONLINE  ONLINE       racdr1                   STABLE
               ONLINE  ONLINE       racdr2                   STABLE
ora.net1.network
               ONLINE  ONLINE       racdr1                   STABLE
               ONLINE  ONLINE       racdr2                   STABLE
ora.ons
               ONLINE  ONLINE       racdr1                   STABLE
               ONLINE  ONLINE       racdr2                   STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       racdr2                   STABLE
      2        ONLINE  OFFLINE                               STABLE
      3        ONLINE  ONLINE       racdr1                   STABLE
ora.CRS.dg(ora.asmgroup)
      1        ONLINE  ONLINE       racdr2                   STABLE
      2        OFFLINE OFFLINE                               STABLE
      3        ONLINE  ONLINE       racdr1                   STABLE
ora.DATA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       racdr2                   STABLE
      2        OFFLINE OFFLINE                               STABLE
      3        ONLINE  ONLINE       racdr1                   STABLE
ora.FRA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       racdr2                   STABLE
      2        OFFLINE OFFLINE                               STABLE
      3        ONLINE  ONLINE       racdr1                   STABLE
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       racdr1                   STABLE
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       racdr2                   STABLE
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       racdr1                   STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       racdr2                   Started,STABLE
      2        ONLINE  OFFLINE                               STABLE
      3        ONLINE  ONLINE       racdr1                   Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       racdr2                   STABLE
      2        ONLINE  OFFLINE                               STABLE
      3        ONLINE  ONLINE       racdr1                   STABLE
ora.cvu
      1        ONLINE  ONLINE       racdr2                   STABLE
ora.qosmserver
      1        ONLINE  ONLINE       racdr2                   STABLE
ora.racdr1.vip
      1        ONLINE  ONLINE       racdr1                   STABLE
ora.racdr2.vip
      1        ONLINE  ONLINE       racdr2                   STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       racdr1                   STABLE
ora.scan2.vip
      1        ONLINE  ONLINE       racdr2                   STABLE
ora.scan3.vip
      1        ONLINE  ONLINE       racdr1                   STABLE
--------------------------------------------------------------------------------

 

Oracle 해결방안은 Doc ID 552457.1 참조하여 진행해봤음 -> 결과적으로 나는 해결 안됐음

참고하라고 써놓겠음니다

# 현재 node 확인 - grid
[+ASM1|grid:/home/grid]> olsnodes
racdr1
racdr2

$ cat /u01/app/oraInventory/ContentsXML/inventory.xml

<INVENTORY>
<VERSION_INFO>
   <SAVED_WITH>12.2.0.7.0</SAVED_WITH>
   <MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME NAME="OraGI19Home1" LOC="/u01/app/19c/grid" TYPE="O" IDX="1" CRS="true"/>
<HOME NAME="OraDB19Home1" LOC="/u01/app/oracle/product/19.0.0/dbhome_1" TYPE="O" IDX="2"/>
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>

여기에 NODE_LIST가 없어서 그런거라고 함

1번 노드 oracle 계정으로 아래 실행

su - oracle
cd $ORACLE_HOME/oui/bin
./runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME \
CLUSTER_NODES=racdr1,racdr2 \
LOCAL_NODE=racdr1 -local

위 실행 후 확인

<HOME NAME="OraDB19Home1" LOC="/u01/app/oracle/product/19.0.0/dbhome_1" TYPE="O" IDX="2">
   <NODE_LIST>
      <NODE NAME="racdr1"/>
      <NODE NAME="racdr2"/>
   </NODE_LIST>
</HOME>

그래도 나는 여전히 안떴다

 

일단 문제 상황 확인을 위해 cluvfy 진행했을 때 2가지 문제가 나왔다

scan ip , ssh

결론적으로는 hostname 변경 후 비밀번호 없는 ssh 접속 설정을 안해서 안뜬 문제였던 듯. 

# oracle 계정
cd $ORACLE_HOME/bin
./cluvfy stage -post crsinst -n racdr1,racdr2

-----------------------------------------------------------------------------------
Post-check for cluster services setup was unsuccessful. 
Checks did not pass for the following nodes:
	racdr2


Failures were encountered during execution of CVU verification request "stage -post crsinst".

User Equivalence ...FAILED
racdr2: PRVG-2019 : Check for equivalence of user "oracle" from node "racdr1"
        to node "racdr2" failed

        PRKC-1191 : Remote command execution setup check for node racdr2 using
        shell /usr/bin/ssh failed.
        No ECDSA host key is known for racdr2 and you have requested strict
        checking.Host key verification failed.

 

ssh 재등록 방법

node 2

[+ASM2|grid:/home/grid]> mv .org .ssh_org   [+ASM2|grid:/home/grid]> mkdir ~/.ssh [+ASM2|grid:/home/grid]> chmod 700 ~/.ssh [+ASM2|grid:/home/grid]> /usr/bin/ssh-keygen -t dsa

[+ASM2|grid:/home/grid]> cd .ssh [+ASM2|grid:/home/grid/.ssh]> ls -al total 12 drwx------. 2 grid oinstall   38 Apr 27 14:52 . drwx------. 8 grid oinstall 4096 Apr 27 14:52 .. -rw-------. 1 grid oinstall  672 Apr 27 14:52 id_dsa -rw-r--r--. 1 grid oinstall  601 Apr 27 14:52 id_dsa.pub [+ASM2|grid:/home/grid/.ssh]> cat id_dsa.pub >> authorized_keys

[+ASM2|grid:/home/grid/.ssh]> scp authorized_keys grid@racdr1:/home/grid/.ssh [+ASM1|grid:/home/grid/.ssh]> cat authorized_keys

node 1

[+ASM1|grid:/home/grid]> cd .ssh [+ASM1|grid:/home/grid/.ssh]> cat id_rsa.pub >> authorized_keys [+ASM1|grid:/home/grid/.ssh]> cat authorized_keys -> node 2번에 없는 node1에 해당하는 authorized key --> node2  authorized key에 작성 [+ASM2|grid:/home/grid/.ssh]> vi authorized_keys

test

$ ssh racdr1

$ ssh racdr2

 

하고 다시 dbca 진행했더니 잘떴다 ~