CRS-4013: This command is not supported in a single-node configuration.

OS환경 : Oracle Linux 6.8 (64bit)

DB 환경 : Oracle Database 11.2.0.4

에러 : CRS-4013: This command is not supported in a single-node configuration. 

싱글 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.

해결 방법 : crsctl stop resource -all 이후 crsctl stop has 사용

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 프로세스 조회

# 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 프로세스 종료

# crsctl stop has
CRS-4133: Oracle High Availability Services has been stopped.

프로세스 확인

# 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 먼저 기동

# crsctl start has
CRS-4123: Oracle High Availability Services has been started.

일반 프로세스 기동

# 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.

프로세스 확인

# 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 상태 확인

# 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  

*싱글이 아닌 RAC 환경에서 메세지 발생 시 

ORACLE_HOME을 GRID_HOME으로 설정해줬는지 확인 한 후

root 계정으로 실행해야함

$ 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에서의 기동 및 중지 명령의 차이

RAC와 싱글DB에서의 기동 및 중지 명령의 차이

참조 : https://www.oraclenext.com/2018/04/starting-and-stopping-grid.html