신문지한장

[Tech] single ASM 기동 및 정지 본문

Oracle

[Tech] single ASM 기동 및 정지

신문지한장 2024. 5. 2. 10:46

싱글 DB 환경에서 grid 사용 시 아래 명령으로 grid가 중지되지 않음

[grid@test ~]$ crsctl stop crs
CRS-4013: This command is not supported in a single-node configuration.
CRS-4000: Command Stop failed, or completed with errors.

 

종료 방법

1. 모든 리소스 종료

[grid@test ~]$ crsctl stop res -all
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.evmd' on 'test'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'test'
CRS-2673: Attempting to stop 'ora.CRS.dg' on 'test'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'test'
CRS-2675: Stop of 'ora.CRS.dg' on 'test' failed
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'test' succeeded
CRS-2677: Stop of 'ora.evmd' on 'test' succeeded
CRS-5017: The resource action "ora.DATA.dg stop" encountered the following error:
ORA-15032: not all alterations performed
ORA-15027: active use of diskgroup "DATA" precludes its dismount
. For details refer to "(:CLSN00108:)" in "/grid/diag/crs/test/crs/trace/ohasd_oraag  ent_grid.trc".
CRS-2675: Stop of 'ora.DATA.dg' on 'test' failed
CRS-2673: Attempting to stop 'ora.CRS.dg' on 'test'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'test'
CRS-2673: Attempting to stop 'ora.orclasm.db' on 'test'
CRS-2677: Stop of 'ora.DATA.dg' on 'test' succeeded
CRS-2677: Stop of 'ora.CRS.dg' on 'test' succeeded
CRS-2677: Stop of 'ora.orclasm.db' on 'test' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'test'
CRS-2677: Stop of 'ora.asm' on 'test' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'test'
CRS-2677: Stop of 'ora.cssd' on 'test' succeeded
CRS-4000: Command Stop failed, or completed with errors.

 

2. ohasd.bin 프로세스 조회

[grid@test ~]$ ps -ef | grep d.bin
grid     12673     1  0 11:04 ?        00:01:47 /oracle/app/grid/bin/ohasd.bin reboot
grid     24540 23012  0 15:41 pts/1    00:00:00 grep --color=auto d.bin

 

3. ohasd.bin 프로세스 종료

[grid@test ~]$ crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'test'
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'test' has completed
CRS-4133: Oracle High Availability Services has been stopped.

 

4. ohasd.bin 프로세스 재조회

[grid@test ~]$ ps -ef | grep d.bin
grid     25618 23012  0 15:43 pts/1    00:00:00 grep --color=auto d.bin

 

 

기동 방법

1. ohasd.bin 먼저 기동

[grid@test ~]$ crsctl start has
CRS-4123: Oracle High Availability Services has been started.

 

2. 일반 프로세스 기동

[grid@test ~]$ crsctl start res -all
CRS-5702: Resource 'ora.evmd' is already running on 'test'
CRS-2501: Resource 'ora.ons' is disabled
CRS-2672: Attempting to start 'ora.diskmon' on 'test'
CRS-2672: Attempting to start 'ora.cssd' on 'test'
CRS-2676: Start of 'ora.diskmon' on 'test' succeeded
CRS-2676: Start of 'ora.cssd' on 'test' succeeded
CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'test'
CRS-2676: Start of 'ora.LISTENER.lsnr' on 'test' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'test'
CRS-2676: Start of 'ora.asm' on 'test' succeeded
CRS-2672: Attempting to start 'ora.DATA.dg' on 'test'
CRS-2672: Attempting to start 'ora.CRS.dg' on 'test'
CRS-2676: Start of 'ora.CRS.dg' on 'test' succeeded
CRS-2676: Start of 'ora.DATA.dg' on 'test' succeeded
CRS-2672: Attempting to start 'ora.orclasm.db' on 'test'
CRS-2676: Start of 'ora.orclasm.db' on 'test' succeeded
CRS-4000: Command Start failed, or completed with errors.

 

3. 프로세스 확인

[grid@test ~]$ ps -ef | grep d.bin
grid     26078     1  6 15:44 ?        00:00:10 /oracle/app/grid/bin/ohasd.bin reboot
grid     26364     1  1 15:44 ?        00:00:01 /oracle/app/grid/bin/oraagent.bin
grid     26431     1  0 15:44 ?        00:00:00 /oracle/app/grid/bin/evmd.bin
grid     26599 26431  0 15:44 ?        00:00:00 /oracle/app/grid/bin/evmlogger.bin -o /oracle/app/grid/log/[HOSTNAME]/evmd/evmlogger.info -l /oracle/app/grid/log/[HOSTNAME]/evmd/evmlogger.log
grid     27097     1  0 15:45 ?        00:00:00 /oracle/app/grid/bin/cssdagent
grid     27127     1  1 15:45 ?        00:00:01 /oracle/app/grid/bin/ocssd.bin
grid     27248     1  0 15:45 ?        00:00:00 /oracle/app/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit
grid     28153 23012  0 15:46 pts/1    00:00:00 grep --color=auto d.bin