rac 설치 중 에러 발생 시 확인해야 할 로그

OS환경 : Oracle Linux6.8(64bit)

DB 환경 : Oracle Database 11.2.0.4 2node RAC

에러 : rac 구성 시 dbca 진행중 node1, 2 가 모두 reboot 되는 현상 발생

해결 방법 :

로그 확인

crs log

$ vi $GRID_HOME/log/rac1/crsd/crsd.log

ctss 상태 확인(Cluster Time Synchonisation Services)

$ crsctl check ctss

CRS는 서버 부팅 시 자동으로 시작됨(조절가능)

수동종료 : # crsctl stop crs
 
수동시작 : # crsctl start crs

node1, node2 각각 해줘야함

RAC 환경 종료 시

DB 내리고 CRS 내리기

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
 
$ su - 
# crsctl stop crs
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'prsjedb1'
CRS-2673: Attempting to stop 'ora.crsd' on 'prsjedb1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'prsjedb1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'prsjedb1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'prsjedb1' succeeded
CRS-2673: Attempting to stop 'ora.prsjedb1.vip' on 'prsjedb1'
CRS-2677: Stop of 'ora.prsjedb1.vip' on 'prsjedb1' succeeded
CRS-2672: Attempting to start 'ora.prsjedb1.vip' on 'prsjedb2'
CRS-2676: Start of 'ora.prsjedb1.vip' on 'prsjedb2' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'prsjedb1'
CRS-2677: Stop of 'ora.ons' on 'prsjedb1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'prsjedb1'
CRS-2677: Stop of 'ora.net1.network' on 'prsjedb1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'prsjedb1' has completed
CRS-2677: Stop of 'ora.crsd' on 'prsjedb1' succeeded
CRS-2673: Attempting to stop 'ora.crf' on 'prsjedb1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'prsjedb1'
CRS-2673: Attempting to stop 'ora.evmd' on 'prsjedb1'
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'prsjedb1'
CRS-2673: Attempting to stop 'ora.mdnsd' on 'prsjedb1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'prsjedb1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'prsjedb1' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 'prsjedb1' succeeded
CRS-2677: Stop of 'ora.crf' on 'prsjedb1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'prsjedb1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'prsjedb1'
CRS-2677: Stop of 'ora.cssd' on 'prsjedb1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'prsjedb1'
CRS-2677: Stop of 'ora.gipcd' on 'prsjedb1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'prsjedb1'
CRS-2677: Stop of 'ora.gpnpd' on 'prsjedb1' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'prsjedb1' has completed
CRS-4133: Oracle High Availability Services has been stopped.

RAC 환경 재시작 시

CRS 올리고 DB 올리기

$ su -
# crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
 
# su - oracle
SQL> startup
ORACLE instance started.
 
Total System Global Area  830930944 bytes
Fixed Size            2257800 bytes
Variable Size          562039928 bytes
Database Buffers      264241152 bytes
Redo Buffers            2392064 bytes
Database mounted.
Database opened.

+

내부적 한쪽 노드 간 통신이 안되면 reboot 해서 다른 쪽이랑 연결함

이 이유 때문에 dbca 중 reboot이 되는 경우도 있음

/etc/hosts를 확인해보니 이상한 문자가 있어서 지워준 뒤

dbca를 다시 하니 정상적으로 설치가 되었음

원인 : /etc/hosts의 특수문자로 인한 문제, 서버간 통신 장애로 인한 reboot

참조 : https://docs.oracle.com/cd/E11882_01/server.112/e25494/restart.htm#ADMIN13262