내맘대로긍정이 알려주는
Oracle 23ai 신기능
무료 세미나 발표자료
다운로드
trending_flat
OS환경 : Oracle Linux 6.8 (64bit)
DB 환경 : Oracle Database 11.2.0.4
방법 : 오라클 11g R2 싱글 DB 환경에서 grid 기동 및 중지
싱글 DB 환경에서 grid 사용 시 아래 명령으로 grid가 중지되지 않음
1 2 3 | # crsctl stop crs CRS-4013: This command is not supported in a single-node configuration. CRS-4000: Command Stop failed, or completed with errors. |
RAC DB의 경우 crsctl stop crs 명령으로 모든 리소스가 함께 중지되지만
싱글 DB에서 Grid를 사용할 경우 모든 리소스를 중지시킨 다음 has(High Availability Service)를 따로 중지 시켜줘야함
모든 리소스 종료
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 | # crsctl stop resource -all CRS-2500: Cannot stop resource 'ora.backga.db' as it is not running CRS-2500: Cannot stop resource 'ora.diskmon' as it is not running CRS-2500: Cannot stop resource 'ora.ons' as it is not running CRS-2673: Attempting to stop 'ora.ASM.dg' on 'oracle50' CRS-2673: Attempting to stop 'ora.FRA.dg' on 'oracle50' CRS-2673: Attempting to stop 'ora.evmd' on 'oracle50' CRS-2677: Stop of 'ora.ASM.dg' on 'oracle50' succeeded CRS-2677: Stop of 'ora.FRA.dg' on 'oracle50' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'oracle50' CRS-2677: Stop of 'ora.evmd' on 'oracle50' succeeded CRS-2677: Stop of 'ora.asm' on 'oracle50' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'oracle50' CRS-2677: Stop of 'ora.cssd' on 'oracle50' succeeded CRS-4000: Command Stop failed, or completed with errors. |
ohasd.bin 프로세스 조회
1 2 3 4 5 | # ps -ef | grep ora root 4164 4107 0 18:25 ? 00:00:00 hald-addon-storage: polling /dev/sr0 (every 2 sec) root 4165 4107 0 18:25 ? 00:00:00 hald-addon-storage: no polling on /dev/fd0 because it is explicitly disabled oracle 4788 1 0 18:25 ? 00:00:10 /app/11.2.0/grid/bin/ohasd.bin reboot root 6231 5136 0 19:24 pts/0 00:00:00 grep ora |
다른 프로세스는 보이지 않지만 ohasd.bin 프로세스는 아직 살아있음
ohasd.bin 프로세스 종료
1 2 | # crsctl stop has CRS-4133: Oracle High Availability Services has been stopped. |
프로세스 확인
1 2 3 4 | # ps -ef | grep ora root 4164 4107 0 18:25 ? 00:00:00 hald-addon-storage: polling /dev/sr0 (every 2 sec) root 4165 4107 0 18:25 ? 00:00:00 hald-addon-storage: no polling on /dev/fd0 because it is explicitly disabled root 6231 5136 0 19:24 pts/0 00:00:00 grep ora |
정상적으로 모두 종료됨
기동 방법은 반대로 실행하면됨
ohasd.bin 먼저 기동
1 2 | # crsctl start has CRS-4123: Oracle High Availability Services has been started. |
일반 프로세스 기동
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | # crsctl start resource -all CRS-5702: Resource 'ora.ASM.dg' is already running on 'oracle50' CRS-5702: Resource 'ora.FRA.dg' is already running on 'oracle50' CRS-5702: Resource 'ora.asm' is already running on 'oracle50' CRS-5702: Resource 'ora.cssd' is already running on 'oracle50' CRS-5702: Resource 'ora.evmd' is already running on 'oracle50' CRS-2501: Resource 'ora.ons' is disabled CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'oracle50' CRS-2672: Attempting to start 'ora.diskmon' on 'oracle50' CRS-2676: Start of 'ora.diskmon' on 'oracle50' succeeded CRS-2674: Start of 'ora.LISTENER.lsnr' on 'oracle50' failed CRS-2672: Attempting to start 'ora.backga.db' on 'oracle50' CRS-2676: Start of 'ora.backga.db' on 'oracle50' succeeded CRS-4000: Command Start failed, or completed with errors. |
프로세스 확인
1 2 3 4 5 6 7 8 | # ps -ef | grep d.bin oracle 62970 1 0 20:02 ? 00:00:01 /app/11.2.0/grid/bin/ohasd.bin reboot oracle 63086 1 0 20:04 ? 00:00:00 /app/11.2.0/grid/bin/oraagent.bin oracle 63089 1 0 20:04 ? 00:00:00 /app/11.2.0/grid/bin/cssdagent oracle 63116 1 0 20:04 ? 00:00:00 /app/11.2.0/grid/bin/evmd.bin oracle 63131 1 0 20:04 ? 00:00:00 /app/11.2.0/grid/bin/ocssd.bin oracle 63167 63116 0 20:04 ? 00:00:00 /app/11.2.0/grid/bin/evmlogger.bin -o /app/11.2.0/grid/evm/log/evmlogger.info -l /app/11.2.0/grid/evm/log/evmlogger.log root 63411 5136 0 20:07 pts/0 00:00:00 grep d.bin |
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 | # crsctl status resource -t -------------------------------------------------------------------------------- NAME TARGET STATE SERVER STATE_DETAILS -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.ASM.dg ONLINE ONLINE oracle50 ora.FRA.dg ONLINE ONLINE oracle50 ora.LISTENER.lsnr ONLINE OFFLINE oracle50 ora.asm ONLINE ONLINE oracle50 Started ora.ons OFFLINE OFFLINE oracle50 -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.backga.db 1 ONLINE ONLINE oracle50 Open ora.cssd 1 ONLINE ONLINE oracle50 ora.diskmon 1 OFFLINE OFFLINE ora.evmd 1 ONLINE ONLINE oracle50 |
참조 : https://positivemh.tistory.com/118
'ORACLE > Admin' 카테고리의 다른 글
| 오라클 19c $ORACLE_HOME/dbs 디렉토리의 hc_{SID}.dat 파일과 lk{SID} 파일 (3) | 2020.06.25 |
|---|---|
| 오라클 19c 버퍼캐쉬 플러쉬 테스트(buffer cache flush) (0) | 2020.06.24 |
| 오라클 19c Hugepages 설정 방법 (3) | 2020.06.24 |
| 오라클 11g crsctl stop crs 시 db의 shutdown 명령 (0) | 2020.06.19 |
| 오라클 11g 원격지 DB sysdba 권한으로 접속 및 중지 방법 (0) | 2020.06.15 |