내맘대로긍정이 알려주는
Oracle 23ai 신기능
무료 세미나 발표자료
다운로드
trending_flat
OS환경 : Oracle Linux 7.6 (64bit)
DB 환경 : Oracle Database 19.8.0.0
에러 : CRS-5017: The resource action "ora.ttdb.db start" encountered the following error:
19c RAC 구성 중 grid 설치, db 엔진 설치 후 19.8 패치 후
dbca 시 2번 노드부분에서 발생한 에러메세지
1 2 3 4 5 6 | PRCR-1079 : Failed to start resource ora.ttdb.db CRS-5017: The resource action "ora.ttdb.db start" encountered the following error: ORA-01565: error in identifying file '+DATA/TTDB/PARAMETERFILE/spfile.268.1049575727. For details refer to "(:CLSN00107:)" in "/app/oracle/diag/crs/ora19db2/crs/trace/crsd_oraagent_oracle.trc". CRS-2674: Start of 'ora.ttdb.db' on 'ora19db2' failed CRS-2632: There are no more servers to try to place resource 'ora.ttdb.db' on that would satisfy its placement policy |
crs 상태확인
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 | $ crsctl stat res -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr ONLINE ONLINE ora19db1 STABLE ONLINE ONLINE ora19db2 STABLE ora.chad ONLINE ONLINE ora19db1 STABLE ONLINE ONLINE ora19db2 STABLE ora.net1.network ONLINE ONLINE ora19db1 STABLE ONLINE ONLINE ora19db2 STABLE ora.ons ONLINE ONLINE ora19db1 STABLE ONLINE ONLINE ora19db2 STABLE ora.proxy_advm OFFLINE OFFLINE ora19db1 STABLE OFFLINE OFFLINE ora19db2 STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup) 1 ONLINE ONLINE ora19db1 STABLE 2 ONLINE ONLINE ora19db2 STABLE 3 ONLINE OFFLINE STABLE ora.DATA.dg(ora.asmgroup) 1 ONLINE ONLINE ora19db1 STABLE 2 ONLINE ONLINE ora19db2 STABLE 3 OFFLINE OFFLINE STABLE ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE ora19db1 STABLE ora.OCR_VOTE.dg(ora.asmgroup) 1 ONLINE ONLINE ora19db1 STABLE 2 ONLINE ONLINE ora19db2 STABLE 3 OFFLINE OFFLINE STABLE ora.asm(ora.asmgroup) 1 ONLINE ONLINE ora19db1 Started,STABLE 2 ONLINE ONLINE ora19db2 Started,STABLE 3 OFFLINE OFFLINE STABLE ora.asmnet1.asmnetwork(ora.asmgroup) 1 ONLINE ONLINE ora19db1 STABLE 2 ONLINE ONLINE ora19db2 STABLE 3 OFFLINE OFFLINE STABLE ora.cvu 1 ONLINE ONLINE ora19db1 STABLE ora.ora19db1.vip 1 ONLINE ONLINE ora19db1 STABLE ora.ora19db2.vip 1 ONLINE ONLINE ora19db2 STABLE ora.qosmserver 1 ONLINE ONLINE ora19db1 STABLE ora.scan1.vip 1 ONLINE ONLINE ora19db1 STABLE ora.ttdb.db 1 ONLINE ONLINE ora19db1 Open,HOME=/app/oracl e/product/19c,STABLE 2 ONLINE OFFLINE STABLE -------------------------------------------------------------------------------- |
2번 db만 offline 상태임
해결 방법 : 수동으로 db 기동
에러메세지에 있는 trc 파일 확인
1 2 3 4 5 6 7 8 9 10 | $ vi /app/oracle/diag/crs/ora19db2/crs/trace/crsd_oraagent_oracle.trc 2020-08-27 20:49:36.707 : AGFW:844936960: [ INFO] {1:27991:2768} Preparing CHECK command for: ora.ttdb.db 2 1 2020-08-27 20:49:36.750 :CLSDYNAM:827213568: [ora.ttdb.db]{1:27991:2768} [start] InstAgent::start 340 End Loop thread:0x7fe60822e718 start isAlive:0 isRunning:0 2020-08-27 20:49:36.750 : USRTHRD:827213568: [ INFO] {1:27991:2768} Thread:InstStartThread: InstStartThread::didUserExceptionOccur excp:(nil) 2020-08-27 20:49:36.750 : USRTHRD:827213568: [ INFO] {1:27991:2768} Thread:InstStartThread: InstStartThread::didOCIExceptionOccur excp:0x7fe5b00b6c00 2020-08-27 20:49:36.750 : USRTHRD:827213568: [ INFO] {1:27991:2768} Thread:InstStartThread: InstStartThread::didOCIExceptionOccur excp:0x7fe5b00b6c00 2020-08-27 20:49:36.750 :CLSDYNAM:827213568: [ora.ttdb.db]{1:27991:2768} [start] InstAgent::start 380 thread exception:ORA-01565: error in identifying file '+DATA/TTDB/PARAMETERFILE/spfile.268.1049575727 2020-08-27 20:49:36.751 :CLSDYNAM:827213568: [ora.ttdb.db]{1:27991:2768} [start] clsnUtils::error Exception type=2 string= CRS-5017: The resource action "ora.ttdb.db start" encountered the following error: ORA-01565: error in identifying file '+DATA/TTDB/PARAMETERFILE/spfile.268.1049575727. For details refer to "(:CLSN00107:)" in "/app/oracle/diag/crs/ora19db2/crs/trace/crsd_oraagent_oracle.trc". |
ASM 영역에 존재하는 spfile을 제대로 읽지 못하는듯함
에러메세지에 있는 spfile 존재 확인(1번 2번 모두)
1 2 3 4 5 6 | $ export ORACLE_HOME=$GRID_HOME $ export ORACLE_SID=+ASM2 $ asmcmd ASMCMD> cd DATA/TTDB/PARAME* ASMCMD> ls spfile.268.1049575727 |
정상적으로 존재함
2번노드 db 수동 기동
1 2 3 4 5 6 7 8 9 10 11 12 | $ sqlplus / as sysdba SQL> startup ORACLE instance started. Total System Global Area 1660940992 bytes Fixed Size 8897216 bytes Variable Size 1056964608 bytes Database Buffers 587202560 bytes Redo Buffers 7876608 bytes Database mounted. Database opened. |
정상적으로 기동됨
crs 상태 확인
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 | $ crsctl stat res -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr ONLINE ONLINE ora19db1 STABLE ONLINE ONLINE ora19db2 STABLE ora.chad ONLINE ONLINE ora19db1 STABLE ONLINE ONLINE ora19db2 STABLE ora.net1.network ONLINE ONLINE ora19db1 STABLE ONLINE ONLINE ora19db2 STABLE ora.ons ONLINE ONLINE ora19db1 STABLE ONLINE ONLINE ora19db2 STABLE ora.proxy_advm OFFLINE OFFLINE ora19db1 STABLE OFFLINE OFFLINE ora19db2 STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup) 1 ONLINE ONLINE ora19db1 STABLE 2 ONLINE ONLINE ora19db2 STABLE 3 ONLINE OFFLINE STABLE ora.DATA.dg(ora.asmgroup) 1 ONLINE ONLINE ora19db1 STABLE 2 ONLINE ONLINE ora19db2 STABLE 3 OFFLINE OFFLINE STABLE ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE ora19db1 STABLE ora.OCR_VOTE.dg(ora.asmgroup) 1 ONLINE ONLINE ora19db1 STABLE 2 ONLINE ONLINE ora19db2 STABLE 3 OFFLINE OFFLINE STABLE ora.asm(ora.asmgroup) 1 ONLINE ONLINE ora19db1 Started,STABLE 2 ONLINE ONLINE ora19db2 Started,STABLE 3 OFFLINE OFFLINE STABLE ora.asmnet1.asmnetwork(ora.asmgroup) 1 ONLINE ONLINE ora19db1 STABLE 2 ONLINE ONLINE ora19db2 STABLE 3 OFFLINE OFFLINE STABLE ora.cvu 1 ONLINE ONLINE ora19db1 STABLE ora.ora19db1.vip 1 ONLINE ONLINE ora19db1 STABLE ora.ora19db2.vip 1 ONLINE ONLINE ora19db2 STABLE ora.qosmserver 1 ONLINE ONLINE ora19db1 STABLE ora.scan1.vip 1 ONLINE ONLINE ora19db1 STABLE ora.ttdb.db 1 ONLINE ONLINE ora19db1 Open,HOME=/app/oracl e/product/19c,STABLE 2 ONLINE ONLINE ora19db2 Open,HOME=/app/oracl e/product/19c,STABLE -------------------------------------------------------------------------------- |
에러 메세지 발생 이후 2번 db startup 후
dbca gui 창으로 돌아와보니 revert 메세지가 나와서 무심코 YES를 눌렸더니 생성되었던 DB가 모두 삭제됨
이후 다시 dbca로 db를 생성하였음 -> 2번째 dbca에서는 위 에러메세지가 발생하지 않음
원인 : 원인 파악불가
2번노드에서 잠시 asm영역에 접근하지못해 spfile을 찾지 못해 발생한 문제일수도있고
오라클 버그일수도 있음
정확한 원인은 파악불가함
참조 :