어느 한 외국사이트에서 포스팅한 글을 보고 직접 테스트해본 후 정리했습니다. 그 사이트에서는 11.2 RAC를 기준으로 os에서 CRS process들을 강제로 kill하고 어떻게 되는지 테스트해보고 결과를 정리하였는데, 저는 12.2 RAC를 기준으로 테스트해 보았습니다.
Process Kill하기
방법 : OS상에서 ps -ef 명령어로 프로세스 number 확인 후 kill -9 명령어로 삭제
초기화면
[root@rac1 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.CRS.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.DATA.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.FRA.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.MGMT.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.chad
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.net1.network
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.ons
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac1 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE rac1 169.254.179.76 10.0.
5.10,STABLE
ora.asm
1 OFFLINE OFFLINE Instance Shutdown,ST
ABLE
2 ONLINE ONLINE rac2 Started,STABLE
3 ONLINE ONLINE rac1 Started,STABLE
ora.cvu
1 OFFLINE OFFLINE STABLE
ora.mgmtdb
1 ONLINE ONLINE rac1 Open,STABLE
ora.qosmserver
1 OFFLINE OFFLINE STABLE
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.racdb.db
1 ONLINE ONLINE rac1 Open,HOME=/u01/app/o
racle/product/12.2.0
/db_1,STABLE
2 ONLINE ONLINE rac2 Open,HOME=/u01/app/o
racle/product/12.2.0
/db_1,STABLE
ora.scan1.vip
1 ONLINE ONLINE rac1 STABLE
--------------------------------------------------------------------------------
[root@rac1 ~]# ps -ef |grep d.bin
root 4676 1 0 09:32 ? 00:00:09 /u01/app/12.2.0/grid/bin/ohasd.bin reboot
root 4781 1 0 09:32 ? 00:00:04 /u01/app/12.2.0/grid/bin/orarootagent.bin
grid 4857 1 0 09:32 ? 00:00:08 /u01/app/12.2.0/grid/bin/oraagent.bin
grid 4875 1 0 09:32 ? 00:00:07 /u01/app/12.2.0/grid/bin/evmd.bin
grid 4879 1 0 09:32 ? 00:00:01 /u01/app/12.2.0/grid/bin/mdnsd.bin
grid 4906 1 0 09:32 ? 00:00:02 /u01/app/12.2.0/grid/bin/gpnpd.bin
grid 4958 4875 0 09:32 ? 00:00:01 /u01/app/12.2.0/grid/bin/evmlogger.bin -o /u01/app/12.2.0/grid/log/[HOSTNAME]/evmd/evmlogger.info -l /u01/app/12.2.0/grid/log/[HOSTNAME]/evmd
grid 4970 1 0 09:32 ? 00:00:06 /u01/app/12.2.0/grid/bin/gipcd.bin
root 5005 1 0 09:32 ? 00:00:02 /u01/app/12.2.0/grid/bin/cssdmonitor
root 5023 1 0 09:32 ? 00:00:02 /u01/app/12.2.0/grid/bin/cssdagent
grid 5037 1 0 09:32 ? 00:00:14 /u01/app/12.2.0/grid/bin/ocssd.bin
root 5150 1 0 09:33 ? 00:00:06 /u01/app/12.2.0/grid/bin/octssd.bin reboot
root 5679 1 1 09:33 ? 00:00:29 /u01/app/12.2.0/grid/bin/osysmond.bin
root 5698 1 0 09:34 ? 00:00:14 /u01/app/12.2.0/grid/bin/crsd.bin reboot
grid 5884 1 1 09:34 ? 00:00:22 /u01/app/12.2.0/grid/bin/oraagent.bin
root 5910 1 0 09:34 ? 00:00:15 /u01/app/12.2.0/grid/bin/orarootagent.bin
grid 6052 1 0 09:34 ? 00:00:00 /u01/app/12.2.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit
grid 6087 1 0 09:34 ? 00:00:00 /u01/app/12.2.0/grid/bin/tnslsnr MGMTLSNR -no_crs_notify -inherit
grid 6088 1 0 09:34 ? 00:00:00 /u01/app/12.2.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit
grid 6163 1 0 09:34 ? 00:00:00 /u01/app/12.2.0/grid/bin/tnslsnr LISTENER_SCAN1 -no_crs_notify -inherit
root 6373 5679 0 09:35 ? 00:00:02 /u01/app/12.2.0/grid/perl/bin/perl /u01/app/12.2.0/grid/bin/diagsnap.pl start
oracle 7738 1 0 09:41 ? 00:00:02 /u01/app/12.2.0/grid/bin/oraagent.bin
root 11857 11402 0 10:06 pts/1 00:00:00 grep --color=auto d.bin
1) ohasd.bin 종료
ohasd는 Oracle High Availbility Service Daemon으로써 GPNPD,GIPC,MDNS,GNS 데몬들이 포함되어 있습니다.
삭제 결과,
ohasd.bin reboot -> ohasd.bin restart로 자동으로 재기동되었으며(프로세스 기동 시간으로 확인가능)
oraagent.bin, orarootagent.bin, cssdagent , cssdmonitor 프로세스도 같이 재기동되었습니다.(프로세스 기동시간으로 확인가능)
[root@rac1 ~]# kill -9 4676
[root@rac1 ~]# ps -ef |grep d.bin
grid 4875 1 0 09:32 ? 00:00:07 /u01/app/12.2.0/grid/bin/evmd.bin
grid 4879 1 0 09:32 ? 00:00:01 /u01/app/12.2.0/grid/bin/mdnsd.bin
grid 4906 1 0 09:32 ? 00:00:02 /u01/app/12.2.0/grid/bin/gpnpd.bin
grid 4958 4875 0 09:32 ? 00:00:01 /u01/app/12.2.0/grid/bin/evmlogger.bin -o /u01/app/12.2.0/grid/log/[HOSTNAME]/evmd/evmlogger.info -l /u01/app/12.2.0/grid/log/[HOSTNAME]/evmd
grid 4970 1 0 09:32 ? 00:00:07 /u01/app/12.2.0/grid/bin/gipcd.bin
grid 5037 1 0 09:32 ? 00:00:15 /u01/app/12.2.0/grid/bin/ocssd.bin
root 5150 1 0 09:33 ? 00:00:07 /u01/app/12.2.0/grid/bin/octssd.bin reboot
root 5679 1 1 09:33 ? 00:00:31 /u01/app/12.2.0/grid/bin/osysmond.bin
root 5698 1 0 09:34 ? 00:00:14 /u01/app/12.2.0/grid/bin/crsd.bin reboot
grid 5884 1 1 09:34 ? 00:00:24 /u01/app/12.2.0/grid/bin/oraagent.bin
root 5910 1 0 09:34 ? 00:00:16 /u01/app/12.2.0/grid/bin/orarootagent.bin
grid 6052 1 0 09:34 ? 00:00:00 /u01/app/12.2.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit
grid 6087 1 0 09:34 ? 00:00:00 /u01/app/12.2.0/grid/bin/tnslsnr MGMTLSNR -no_crs_notify -inherit
grid 6088 1 0 09:34 ? 00:00:00 /u01/app/12.2.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit
grid 6163 1 0 09:34 ? 00:00:00 /u01/app/12.2.0/grid/bin/tnslsnr LISTENER_SCAN1 -no_crs_notify -inherit
root 6373 5679 0 09:35 ? 00:00:02 /u01/app/12.2.0/grid/perl/bin/perl /u01/app/12.2.0/grid/bin/diagsnap.pl start
oracle 7738 1 0 09:41 ? 00:00:02 /u01/app/12.2.0/grid/bin/oraagent.bin
root 12087 4311 7 10:08 ? 00:00:00 /u01/app/12.2.0/grid/bin/ohasd.bin restart
grid 12155 1 3 10:08 ? 00:00:00 /u01/app/12.2.0/grid/bin/oraagent.bin
root 12165 1 7 10:08 ? 00:00:00 /u01/app/12.2.0/grid/bin/orarootagent.bin
root 12167 1 1 10:08 ? 00:00:00 /u01/app/12.2.0/grid/bin/cssdagent
root 12169 1 0 10:08 ? 00:00:00 /u01/app/12.2.0/grid/bin/cssdmonitor
root 12284 11402 0 10:08 pts/1 00:00:00 grep --color=auto d.bin
2)cssdmonitor,mdnsd.bin,gpnpd.bin,osysmond.bin,gipcd.bin 프로세스 종료
프로세스를 전부 삭제하고 다시 확인결과 전부 자동 재기동된것으로 확인됩니다.
(아마 ohasd.bin이 살아있기 때문에 자동으로 죽은 프로세스를 살리지 않을까 생각됩니다. 이부분은 추가로 정리해서 내용 추가하겠습니다.)
[root@rac1 ~]# kill -9 12169
[root@rac1 ~]# kill -9 4879
[root@rac1 ~]# kill -9 4906
[root@rac1 ~]# kill -9 5679
[root@rac1 ~]# kill -9 4970
[root@rac1 ~]# ps -ef |grep d.bin
grid 4875 1 0 09:32 ? 00:00:10 /u01/app/12.2.0/grid/bin/evmd.bin
grid 4958 4875 0 09:32 ? 00:00:02 /u01/app/12.2.0/grid/bin/evmlogger.bin -o /u01/app/12.2.0/grid/log/[HOSTNAME]/evmd/evmlogger.info -l /u01/app/12.2.0/grid/log/[HOSTNAME]/evmd
grid 5037 1 0 09:32 ? 00:00:20 /u01/app/12.2.0/grid/bin/ocssd.bin
root 5150 1 0 09:33 ? 00:00:09 /u01/app/12.2.0/grid/bin/octssd.bin reboot
root 5698 1 0 09:34 ? 00:00:18 /u01/app/12.2.0/grid/bin/crsd.bin reboot
grid 5884 1 1 09:34 ? 00:00:32 /u01/app/12.2.0/grid/bin/oraagent.bin
root 5910 1 0 09:34 ? 00:00:22 /u01/app/12.2.0/grid/bin/orarootagent.bin
grid 6052 1 0 09:34 ? 00:00:00 /u01/app/12.2.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit
grid 6087 1 0 09:34 ? 00:00:00 /u01/app/12.2.0/grid/bin/tnslsnr MGMTLSNR -no_crs_notify -inherit
grid 6088 1 0 09:34 ? 00:00:00 /u01/app/12.2.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit
grid 6163 1 0 09:34 ? 00:00:00 /u01/app/12.2.0/grid/bin/tnslsnr LISTENER_SCAN1 -no_crs_notify -inherit
oracle 7738 1 0 09:41 ? 00:00:03 /u01/app/12.2.0/grid/bin/oraagent.bin
root 12087 4311 0 10:08 ? 00:00:03 /u01/app/12.2.0/grid/bin/ohasd.bin restart
grid 12155 1 0 10:08 ? 00:00:02 /u01/app/12.2.0/grid/bin/oraagent.bin
root 12165 1 0 10:08 ? 00:00:02 /u01/app/12.2.0/grid/bin/orarootagent.bin
root 12167 1 0 10:08 ? 00:00:01 /u01/app/12.2.0/grid/bin/cssdagent
root 12930 1 0 10:13 ? 00:00:00 /u01/app/12.2.0/grid/bin/cssdmonitor
grid 13437 1 0 10:18 ? 00:00:00 /u01/app/12.2.0/grid/bin/mdnsd.bin
grid 13528 1 0 10:18 ? 00:00:00 /u01/app/12.2.0/grid/bin/gpnpd.bin
root 14142 1 2 10:21 ? 00:00:00 /u01/app/12.2.0/grid/bin/osysmond.bin
root 14183 14142 0 10:21 ? 00:00:00 /u01/app/12.2.0/grid/perl/bin/perl /u01/app/12.2.0/grid/bin/diagsnap.pl start
grid 14349 1 3 10:21 ? 00:00:00 /u01/app/12.2.0/grid/bin/gipcd.bin
root 14395 14183 0 10:21 ? 00:00:00 sh -c for i in {1..3}; do printf "zzz "; date; /usr/bin/pstack 5698; sleep 5; done >> "/u01/app/oracle/diagsnap/rac1/evt_1_20210204-102148/p
root 14400 14183 0 10:21 ? 00:00:00 sh -c for i in {1..3}; do printf "zzz "; date; /usr/bin/pstack 5037; sleep 5; done >> "/u01/app/oracle/diagsnap/rac1/evt_1_20210204-102148/p
root 14401 14183 0 10:21 ? 00:00:00 sh -c for i in {1..3}; do printf "zzz "; date; /usr/bin/pstack 12087; sleep 5; done >> "/u01/app/oracle/diagsnap/rac1/evt_1_20210204-102148/
root 14445 14142 11 10:21 ? 00:00:00 /u01/app/12.2.0/grid/perl/bin/perl /u01/app/12.2.0/grid/bin/diagsnap.pl snap
root 14480 11402 0 10:21 pts/1 00:00:00 grep --color=auto d.bin
3) ASMNET1LSNR_ASM,MGMTLSNR, LISTENER, LISTENER_SCAN1 프로세스 종료
리스너 관련 테몬들도 삭제 후 자동으로 재기동되었습니다.(시간으로 확인 가능)
[root@rac1 ~]# kill -9 6052
[root@rac1 ~]# kill -9 6087 6088 6163
[root@rac1 ~]# ps -ef |grep d.bin
grid 4875 1 0 09:32 ? 00:00:13 /u01/app/12.2.0/grid/bin/evmd.bin
grid 4958 4875 0 09:32 ? 00:00:03 /u01/app/12.2.0/grid/bin/evmlogger.bin -o /u01/app/12.2.0/grid/log/[HOSTNAME]/evmd/evmlogger.info -l /u01/app/12.2.0/grid/log/[HOSTNAME]/evmd
grid 5037 1 0 09:32 ? 00:00:26 /u01/app/12.2.0/grid/bin/ocssd.bin
root 5150 1 0 09:33 ? 00:00:13 /u01/app/12.2.0/grid/bin/octssd.bin reboot
root 5698 1 0 09:34 ? 00:00:23 /u01/app/12.2.0/grid/bin/crsd.bin reboot
grid 5884 1 1 09:34 ? 00:00:45 /u01/app/12.2.0/grid/bin/oraagent.bin
root 5910 1 0 09:34 ? 00:00:31 /u01/app/12.2.0/grid/bin/orarootagent.bin
oracle 7738 1 0 09:41 ? 00:00:04 /u01/app/12.2.0/grid/bin/oraagent.bin
root 12087 4311 0 10:08 ? 00:00:06 /u01/app/12.2.0/grid/bin/ohasd.bin restart
grid 12155 1 0 10:08 ? 00:00:05 /u01/app/12.2.0/grid/bin/oraagent.bin
root 12165 1 0 10:08 ? 00:00:04 /u01/app/12.2.0/grid/bin/orarootagent.bin
root 12167 1 0 10:08 ? 00:00:02 /u01/app/12.2.0/grid/bin/cssdagent
root 12930 1 0 10:13 ? 00:00:02 /u01/app/12.2.0/grid/bin/cssdmonitor
grid 13437 1 0 10:18 ? 00:00:01 /u01/app/12.2.0/grid/bin/mdnsd.bin
grid 13528 1 0 10:18 ? 00:00:01 /u01/app/12.2.0/grid/bin/gpnpd.bin
root 14142 1 1 10:21 ? 00:00:12 /u01/app/12.2.0/grid/bin/osysmond.bin
root 14183 14142 0 10:21 ? 00:00:01 /u01/app/12.2.0/grid/perl/bin/perl /u01/app/12.2.0/grid/bin/diagsnap.pl start
grid 14349 1 0 10:21 ? 00:00:03 /u01/app/12.2.0/grid/bin/gipcd.bin
grid 16811 1 0 10:38 ? 00:00:00 /u01/app/12.2.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit
grid 16969 1 0 10:39 ? 00:00:00 /u01/app/12.2.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit
grid 17012 1 0 10:39 ? 00:00:00 /u01/app/12.2.0/grid/bin/tnslsnr LISTENER_SCAN1 -no_crs_notify -inherit
root 17030 11402 0 10:39 pts/1 00:00:00 grep --color=auto d.bin
[root@rac1 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.CRS.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.DATA.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.FRA.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.MGMT.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.chad
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.net1.network
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.ons
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac1 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE rac1 169.254.179.76 10.0.
5.10,STABLE
ora.asm
1 OFFLINE OFFLINE Instance Shutdown,ST
ABLE
2 ONLINE ONLINE rac2 Started,STABLE
3 ONLINE ONLINE rac1 Started,STABLE
ora.cvu
1 OFFLINE OFFLINE STABLE
ora.mgmtdb
1 ONLINE ONLINE rac1 Open,STABLE
ora.qosmserver
1 OFFLINE OFFLINE STABLE
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.racdb.db
1 ONLINE ONLINE rac1 Open,HOME=/u01/app/o
racle/product/12.2.0
/db_1,STABLE
2 ONLINE ONLINE rac2 Open,HOME=/u01/app/o
racle/product/12.2.0
/db_1,STABLE
ora.scan1.vip
1 ONLINE ONLINE rac1 STABLE
--------------------------------------------------------------------------------
4) ohas 프로세스 종료
ohasd.bin 데몬 뿐만아니라 init/init.ohasd 데몬까지 kill로 종료해보겠습니다.
init.ohasd 데몬은 프로세스 number와 시간이 달라진것으로 보아 재기동되었으나 ohasd.bin 프로세스는 살아나지 않는것을 확인할 수 있습니다.
[root@rac1 ~]# ps -ef |grep ohasd
root 4311 1 0 09:31 ? 00:00:00 /bin/sh /etc/init.d/init.ohasd run >/dev/null 2>&1 </dev/null
root 12087 4311 0 10:08 ? 00:00:07 /u01/app/12.2.0/grid/bin/ohasd.bin restart
root 17709 11402 0 10:44 pts/1 00:00:00 grep --color=auto ohasd
[root@rac1 ~]# kill -9 4311 12087
[root@rac1 ~]# ps -ef |grep ohasd
root 17841 1 0 10:45 ? 00:00:00 /bin/sh /etc/init.d/init.ohasd run >/dev/null 2>&1 </dev/null
root 17917 11402 0 10:46 pts/1 00:00:00 grep --color=auto ohasd
5) 모든 프로세스 종료
먼저,
evmd.bin evmlogger.bin gpnpd.bin mdnsd.bin gipcd.bin oraagent.bin oraagent.bin orarootagent.bin LISTENER_SCAN1 LISTENER ASMNET1LSNR_ASM 프로세스를 강제로 종료해보겠습니다.
다시 살아나지 않는것을 확인할 수 있습니다.
[root@rac1 ~]# kill -9 4875 4958 13528 13437 14349 7738 5884 5910 17012 16969 16811
[root@rac1 ~]# ps -ef |grep d.bin
grid 5037 1 0 09:32 ? 00:00:32 /u01/app/12.2.0/grid/bin/ocssd.bin
root 5150 1 0 09:33 ? 00:00:16 /u01/app/12.2.0/grid/bin/octssd.bin reboot
root 5698 1 0 09:34 ? 00:00:28 /u01/app/12.2.0/grid/bin/crsd.bin reboot
root 12167 1 0 10:08 ? 00:00:03 /u01/app/12.2.0/grid/bin/cssdagent
root 12930 1 0 10:13 ? 00:00:03 /u01/app/12.2.0/grid/bin/cssdmonitor
root 14142 1 1 10:21 ? 00:00:21 /u01/app/12.2.0/grid/bin/osysmond.bin
root 14183 14142 0 10:21 ? 00:00:02 /u01/app/12.2.0/grid/perl/bin/perl /u01/app/12.2.0/grid/bin/diagsnap.pl start
oracle 19940 1 1 10:55 ? 00:00:00 /u01/app/12.2.0/grid/bin/oraagent.bin
root 19943 1 1 10:55 ? 00:00:00 /u01/app/12.2.0/grid/bin/orarootagent.bin
root 20304 11402 0 10:55 pts/1 00:00:00 grep --color=auto d.bin
나머지 보이는 프로세스도 다 종료하겠습니다.
전부다 삭제했지만 서버 재기동은 일어나지 않았습니다. (RAC의 특정 프로세스가 강제종료되면 서버가 재부팅된다는 이야기를 들은게 있어서.. 테스트결과로는 재부팅되지 않았습니다)
[root@rac1 ~]# kill -9 5150 5698 12167 12930 14142 14182 19940 19943 20613
[root@rac1 ~]# ps -ef |grep d.bin
grid 5037 1 0 09:32 ? 00:00:33 /u01/app/12.2.0/grid/bin/ocssd.bin
root 14183 1 0 10:21 ? 00:00:02 /u01/app/12.2.0/grid/perl/bin/perl /u01/app/12.2.0/grid/bin/diagsnap.pl start
root 20918 11402 0 10:59 pts/1 00:00:00 grep --color=auto d.bin
[root@rac1 ~]# kill -9 5037
[root@rac1 ~]# ps -ef |grep d.bin
root 14183 1 0 10:21 ? 00:00:02 /u01/app/12.2.0/grid/perl/bin/perl /u01/app/12.2.0/grid/bin/diagsnap.pl start
root 21200 11402 0 11:00 pts/1 00:00:00 grep --color=auto d.bin
[root@rac1 ~]# kill -9 14183
[root@rac1 ~]# ipcs -ma
------ Message Queues --------
key msqid owner perms used-bytes messages
------ Shared Memory Segments --------
key shmid owner perms bytes nattch status
0x00000000 196611 gdm 777 16384 1 dest
0x00000000 294916 gdm 777 4046848 2 dest
------ Semaphore Arrays --------
key semid owner perms nsems
Process 살리기(재부팅 없이)
crsctl start crs 명령어로 간단히 모든 프로세스들을 다시 살릴 수 있습니다.
[root@rac1 ~]# crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
--다시 살아남
[root@rac1 ~]# ps -ef |grep d.bin
root 21869 1 4 11:04 ? 00:00:01 /u01/app/12.2.0/grid/bin/ohasd.bin reboot
root 21952 1 1 11:04 ? 00:00:00 /u01/app/12.2.0/grid/bin/orarootagent.bin
grid 22021 1 0 11:04 ? 00:00:00 /u01/app/12.2.0/grid/bin/oraagent.bin
grid 22042 1 0 11:04 ? 00:00:00 /u01/app/12.2.0/grid/bin/evmd.bin
grid 22043 1 0 11:04 ? 00:00:00 /u01/app/12.2.0/grid/bin/mdnsd.bin
grid 22069 1 0 11:04 ? 00:00:00 /u01/app/12.2.0/grid/bin/gpnpd.bin
grid 22121 22042 0 11:04 ? 00:00:00 /u01/app/12.2.0/grid/bin/evmlogger.bin -o /u01/app/12.2.0/grid/log/[HOSTNAME]/evmd/evmlogger.info -l /u01/app/12.2.0/grid/log/[HOSTNAME]/evmd
grid 22133 1 1 11:04 ? 00:00:00 /u01/app/12.2.0/grid/bin/gipcd.bin
root 22172 1 0 11:05 ? 00:00:00 /u01/app/12.2.0/grid/bin/cssdmonitor
root 22190 1 0 11:05 ? 00:00:00 /u01/app/12.2.0/grid/bin/cssdagent
grid 22203 1 3 11:05 ? 00:00:00 /u01/app/12.2.0/grid/bin/ocssd.bin
root 22288 1 1 11:05 ? 00:00:00 /u01/app/12.2.0/grid/bin/octssd.bin reboot
root 22320 11402 0 11:05 pts/1 00:00:00 grep --color=auto d.bin
[root@rac1 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.CRS.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.DATA.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.FRA.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.MGMT.dg
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.chad
ONLINE ONLINE rac1 STABLE
OFFLINE ONLINE rac2 STABLE
ora.net1.network
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.ons
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac1 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE rac2 169.254.194.149 10.0
.5.20,STABLE
ora.asm
1 OFFLINE OFFLINE STABLE
2 ONLINE ONLINE rac2 Started,STABLE
3 ONLINE ONLINE rac1 Started,STABLE
ora.cvu
1 OFFLINE OFFLINE STABLE
ora.mgmtdb
1 ONLINE ONLINE rac2 Open,STABLE
ora.qosmserver
1 OFFLINE OFFLINE STABLE
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.racdb.db
1 ONLINE OFFLINE rac1 STARTING
2 ONLINE ONLINE rac2 Open,HOME=/u01/app/o
racle/product/12.2.0
/db_1,STABLE
ora.scan1.vip
1 ONLINE ONLINE rac1 STABLE
--------------------------------------------------------------------------------
'Oracle > 운영' 카테고리의 다른 글
Two-Phase Commit 매커니즘 (0) | 2021.03.10 |
---|---|
Index rebuild (0) | 2021.02.16 |
dba_tables 과 dba_segments의 차이 (0) | 2021.02.05 |
[Reorg] 대상 테이블 추출하기 (DBMS_ROWID,DBMS_SPACE) (0) | 2021.02.04 |
권한으로 다른유저의 Package body 확인하기 (2) | 2021.02.03 |
댓글