내맘대로긍정이 알려주는
Oracle 23ai 신기능
무료 세미나 발표자료
다운로드
trending_flat
OS환경 : Oracle Linux 7.6 (64bit)
DB 환경 : Oracle Database 19.3.0.0
방법 : crsctl start crs -wait 옵션
crs 기동 시 wait 옵션을 사용하면 crsctl stop crs 시 처럼
시작되는 grid 프로세스를 확인 할 수 있음
crsctl stop 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 | # crsctl stop crs CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'ora19db2' CRS-2673: Attempting to stop 'ora.crsd' on 'ora19db2' CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on server 'ora19db2' CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'ora19db2' CRS-2673: Attempting to stop 'ora.ora19db2.vip' on 'ora19db2' CRS-2673: Attempting to stop 'ora.qosmserver' on 'ora19db2' CRS-2673: Attempting to stop 'ora.chad' on 'ora19db2' CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'ora19db2' CRS-33673: Attempting to stop resource group 'ora.asmgroup' on server 'ora19db2' CRS-2673: Attempting to stop 'ora.OCR_VOTE.dg' on 'ora19db2' CRS-2673: Attempting to stop 'ora.cvu' on 'ora19db2' CRS-2677: Stop of 'ora.ora19db2.vip' on 'ora19db2' succeeded CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'ora19db2' succeeded CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'ora19db2' succeeded CRS-2673: Attempting to stop 'ora.scan1.vip' on 'ora19db2' CRS-2677: Stop of 'ora.OCR_VOTE.dg' on 'ora19db2' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'ora19db2' CRS-2673: Attempting to stop 'ora.ora19db1.vip' on 'ora19db2' CRS-2677: Stop of 'ora.scan1.vip' on 'ora19db2' succeeded CRS-2677: Stop of 'ora.ora19db1.vip' on 'ora19db2' succeeded CRS-2677: Stop of 'ora.chad' on 'ora19db2' succeeded CRS-2677: Stop of 'ora.cvu' on 'ora19db2' succeeded CRS-2677: Stop of 'ora.asm' on 'ora19db2' succeeded CRS-2673: Attempting to stop 'ora.ASMNET1LSNR_ASM.lsnr' on 'ora19db2' CRS-2677: Stop of 'ora.qosmserver' on 'ora19db2' succeeded CRS-2677: Stop of 'ora.ASMNET1LSNR_ASM.lsnr' on 'ora19db2' succeeded CRS-2673: Attempting to stop 'ora.asmnet1.asmnetwork' on 'ora19db2' CRS-2677: Stop of 'ora.asmnet1.asmnetwork' on 'ora19db2' succeeded CRS-33677: Stop of resource group 'ora.asmgroup' on server 'ora19db2' succeeded. CRS-2673: Attempting to stop 'ora.ons' on 'ora19db2' CRS-2677: Stop of 'ora.ons' on 'ora19db2' succeeded CRS-2673: Attempting to stop 'ora.net1.network' on 'ora19db2' CRS-2677: Stop of 'ora.net1.network' on 'ora19db2' succeeded CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'ora19db2' has completed CRS-2677: Stop of 'ora.crsd' on 'ora19db2' succeeded CRS-2673: Attempting to stop 'ora.storage' on 'ora19db2' CRS-2673: Attempting to stop 'ora.crf' on 'ora19db2' CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'ora19db2' CRS-2673: Attempting to stop 'ora.mdnsd' on 'ora19db2' CRS-2677: Stop of 'ora.crf' on 'ora19db2' succeeded CRS-2677: Stop of 'ora.drivers.acfs' on 'ora19db2' succeeded CRS-2677: Stop of 'ora.storage' on 'ora19db2' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'ora19db2' CRS-2677: Stop of 'ora.mdnsd' on 'ora19db2' succeeded CRS-2677: Stop of 'ora.asm' on 'ora19db2' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'ora19db2' CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'ora19db2' succeeded CRS-2673: Attempting to stop 'ora.ctssd' on 'ora19db2' CRS-2673: Attempting to stop 'ora.evmd' on 'ora19db2' CRS-2677: Stop of 'ora.ctssd' on 'ora19db2' succeeded CRS-2677: Stop of 'ora.evmd' on 'ora19db2' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'ora19db2' CRS-2677: Stop of 'ora.cssd' on 'ora19db2' succeeded CRS-2673: Attempting to stop 'ora.gipcd' on 'ora19db2' CRS-2673: Attempting to stop 'ora.gpnpd' on 'ora19db2' CRS-2677: Stop of 'ora.gpnpd' on 'ora19db2' succeeded CRS-2677: Stop of 'ora.gipcd' on 'ora19db2' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'ora19db2' has completed CRS-4133: Oracle High Availability Services has been stopped. |
crs 종료시에는 어떤 리소스가 종료되는지 눈으로 확인이 가능함
crsctl start crs 사용
1 2 | # crsctl start crs CRS-4123: Oracle High Availability Services has been started. |
crs 시작시에는 메세지 한줄만 나오고 어떤 리소스가 시작되었는지 모름
시작된 리소스를 확인하려면 crsctl stat res -t -init 명령을 사용해야함
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 | # crsctl stat res -t -init -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.asm 1 ONLINE ONLINE ora19db2 STABLE ora.cluster_interconnect.haip 1 ONLINE ONLINE ora19db2 STABLE ora.crf 1 ONLINE ONLINE ora19db2 STABLE ora.crsd 1 ONLINE ONLINE ora19db2 STABLE ora.cssd 1 ONLINE ONLINE ora19db2 STABLE ora.cssdmonitor 1 ONLINE ONLINE ora19db2 STABLE ora.ctssd 1 ONLINE ONLINE ora19db2 OBSERVER,STABLE ora.diskmon 1 OFFLINE OFFLINE STABLE ora.drivers.acfs 1 ONLINE ONLINE ora19db2 STABLE ora.evmd 1 ONLINE ONLINE ora19db2 STABLE ora.gipcd 1 ONLINE ONLINE ora19db2 STABLE ora.gpnpd 1 ONLINE ONLINE ora19db2 STABLE ora.mdnsd 1 ONLINE ONLINE ora19db2 STABLE ora.storage 1 ONLINE ONLINE ora19db2 STABLE ------------------------------------------------------------------------------- |
wait 옵션을 사용하면 stop crs 명령처럼 시작되는 리소스를 확인 할 수 있음
crsctl start crs -wait 사용
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 63 64 65 66 67 68 69 70 71 72 | # crsctl start crs -wait CRS-4123: Starting Oracle High Availability Services-managed resources CRS-2672: Attempting to start 'ora.evmd' on 'ora19db1' CRS-2672: Attempting to start 'ora.mdnsd' on 'ora19db1' CRS-2676: Start of 'ora.mdnsd' on 'ora19db1' succeeded CRS-2676: Start of 'ora.evmd' on 'ora19db1' succeeded CRS-2672: Attempting to start 'ora.gpnpd' on 'ora19db1' CRS-2676: Start of 'ora.gpnpd' on 'ora19db1' succeeded CRS-2672: Attempting to start 'ora.gipcd' on 'ora19db1' CRS-2676: Start of 'ora.gipcd' on 'ora19db1' succeeded CRS-2672: Attempting to start 'ora.crf' on 'ora19db1' CRS-2672: Attempting to start 'ora.cssdmonitor' on 'ora19db1' CRS-2676: Start of 'ora.cssdmonitor' on 'ora19db1' succeeded CRS-2672: Attempting to start 'ora.cssd' on 'ora19db1' CRS-2672: Attempting to start 'ora.diskmon' on 'ora19db1' CRS-2676: Start of 'ora.diskmon' on 'ora19db1' succeeded CRS-2676: Start of 'ora.crf' on 'ora19db1' succeeded CRS-2676: Start of 'ora.cssd' on 'ora19db1' succeeded CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'ora19db1' CRS-2672: Attempting to start 'ora.ctssd' on 'ora19db1' CRS-2676: Start of 'ora.ctssd' on 'ora19db1' succeeded CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'ora19db1' succeeded CRS-2672: Attempting to start 'ora.asm' on 'ora19db1' CRS-2676: Start of 'ora.asm' on 'ora19db1' succeeded CRS-2672: Attempting to start 'ora.storage' on 'ora19db1' CRS-2676: Start of 'ora.storage' on 'ora19db1' succeeded CRS-2672: Attempting to start 'ora.crsd' on 'ora19db1' CRS-2676: Start of 'ora.crsd' on 'ora19db1' succeeded CRS-6023: Starting Oracle Cluster Ready Services-managed resources CRS-6017: Processing resource auto-start for servers: ora19db1 CRS-2672: Attempting to start 'ora.scan1.vip' on 'ora19db1' CRS-2672: Attempting to start 'ora.ora19db1.vip' on 'ora19db1' CRS-2672: Attempting to start 'ora.qosmserver' on 'ora19db1' CRS-2672: Attempting to start 'ora.ons' on 'ora19db1' CRS-2672: Attempting to start 'ora.cvu' on 'ora19db1' CRS-2672: Attempting to start 'ora.chad' on 'ora19db1' CRS-2672: Attempting to start 'ora.ora19db2.vip' on 'ora19db1' CRS-2676: Start of 'ora.cvu' on 'ora19db1' succeeded CRS-2676: Start of 'ora.chad' on 'ora19db1' succeeded CRS-2676: Start of 'ora.ora19db2.vip' on 'ora19db1' succeeded CRS-2676: Start of 'ora.ora19db1.vip' on 'ora19db1' succeeded CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'ora19db1' CRS-2676: Start of 'ora.scan1.vip' on 'ora19db1' succeeded CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'ora19db1' CRS-2676: Start of 'ora.LISTENER.lsnr' on 'ora19db1' succeeded CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'ora19db1' succeeded CRS-2676: Start of 'ora.ons' on 'ora19db1' succeeded CRS-2676: Start of 'ora.qosmserver' on 'ora19db1' succeeded CRS-6016: Resource auto-start has completed for server ora19db1 CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources CRS-6017: Processing resource auto-start for servers: CRS-2673: Attempting to stop 'ora.ora19db2.vip' on 'ora19db1' CRS-2672: Attempting to start 'ora.chad' on 'ora19db2' CRS-2672: Attempting to start 'ora.ons' on 'ora19db2' CRS-2677: Stop of 'ora.ora19db2.vip' on 'ora19db1' succeeded CRS-2672: Attempting to start 'ora.ora19db2.vip' on 'ora19db2' CRS-2676: Start of 'ora.ora19db2.vip' on 'ora19db2' succeeded CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'ora19db2' CRS-2676: Start of 'ora.chad' on 'ora19db2' succeeded CRS-2676: Start of 'ora.LISTENER.lsnr' on 'ora19db2' succeeded CRS-33672: Attempting to start resource group 'ora.asmgroup' on server 'ora19db2' CRS-2672: Attempting to start 'ora.asmnet1.asmnetwork' on 'ora19db2' CRS-2676: Start of 'ora.asmnet1.asmnetwork' on 'ora19db2' succeeded CRS-2672: Attempting to start 'ora.ASMNET1LSNR_ASM.lsnr' on 'ora19db2' CRS-2676: Start of 'ora.ASMNET1LSNR_ASM.lsnr' on 'ora19db2' succeeded CRS-2672: Attempting to start 'ora.asm' on 'ora19db2' CRS-2676: Start of 'ora.ons' on 'ora19db2' succeeded CRS-2676: Start of 'ora.asm' on 'ora19db2' succeeded CRS-33676: Start of resource group 'ora.asmgroup' on server 'ora19db2' succeeded. CRS-6016: Resource auto-start has completed for server ora19db2 CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources CRS-4123: Oracle High Availability Services has been started. |
어떤 리소스가 시작되었는지 확인 가능함
참조 : https://docs.oracle.com/database/121/CWADD/GUID-0CD28B7A-476F-4095-82D6-54E1BB3DCBD5.htm#CWADD92228
'ORACLE > Admin' 카테고리의 다른 글
오라클 19c 리스너 상태 READY와 UNKNOWN 차이 (0) | 2020.09.15 |
---|---|
오라클 19c Oracle Database In-Memory BASE_LEVEL 기능 (2) | 2020.09.02 |
오라클 11g R2 ADRCI 를 이용한 IPS(Incident Packaging Service) 가이드 (0) | 2020.08.16 |
오라클 11g DB 재기동시 sql_id 는 남아있을까? (v$sql) (0) | 2020.08.13 |
오라클 11g R2 tfa(ahf) SQL 성능 진단 자동 수집 가이드(SRDC) (0) | 2020.08.12 |