Oracle Clusterware 상태 확인

프로세스 확인 방법

[grid@node01 ~]$ ps -ef | grep d.bin | grep -v grep

root      1623     1  0 00:11 ?        00:00:09 /u01/app/12.2.0/grid/bin/ohasd.bin reboot

root      2142     1  0 00:12 ?        00:00:06 /u01/app/12.2.0/grid/bin/orarootagent.bin

grid      2213     1  0 00:12 ?        00:00:07 /u01/app/12.2.0/grid/bin/oraagent.bin

grid      2233     1  0 00:12 ?        00:00:09 /u01/app/12.2.0/grid/bin/evmd.bin

grid      2234     1  0 00:12 ?        00:00:02 /u01/app/12.2.0/grid/bin/mdnsd.bin

grid      2262     1  0 00:12 ?        00:00:03 /u01/app/12.2.0/grid/bin/gpnpd.bin

grid      2312  2233  0 00:12 ?        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/evmlogger.log

grid      2328     1  0 00:12 ?        00:00:09 /u01/app/12.2.0/grid/bin/gipcd.bin

root      2356     1  0 00:12 ?        00:00:03 /u01/app/12.2.0/grid/bin/cssdmonitor

root      2375     1  0 00:12 ?        00:00:03 /u01/app/12.2.0/grid/bin/cssdagent

grid      2390     1  0 00:12 ?        00:00:13 /u01/app/12.2.0/grid/bin/ocssd.bin

root      2480     1  0 00:12 ?        00:00:09 /u01/app/12.2.0/grid/bin/octssd.bin reboot

root      2523     1  0 00:12 ?        00:00:39 /u01/app/12.2.0/grid/bin/osysmond.bin

root      2536     1  0 00:12 ?        00:00:18 /u01/app/12.2.0/grid/bin/crsd.bin reboot

root      2635     1  0 00:12 ?        00:00:18 /u01/app/12.2.0/grid/bin/ologgerd -M

root      2817     1  0 00:12 ?        00:00:15 /u01/app/12.2.0/grid/bin/orarootagent.bin

grid      3589     1  0 00:13 ?        00:00:19 /u01/app/12.2.0/grid/bin/oraagent.bin

grid      3635     1  0 00:13 ?        00:00:00 /u01/app/12.2.0/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit

grid      3658     1  0 00:13 ?        00:00:00 /u01/app/12.2.0/grid/bin/tnslsnr LISTENER_SCAN1 -no_crs_notify -inherit

grid      3681     1  0 00:13 ?        00:00:00 /u01/app/12.2.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit

root      3737  2523  0 00:13 ?        00:00:03 /u01/app/12.2.0/grid/perl/bin/perl /u01/app/12.2.0/grid/bin/diagsnap.pl start

oracle    4403     1  0 00:14 ?        00:00:04 /u01/app/12.2.0/grid/bin/oraagent.bin

[grid@node01 ~]$

 

[grid@node01 ~]$ crsctl stat res -t -w "TYPE = ora.database.type"

--------------------------------------------------------------------------------

Name           Target  State        Server                   State details      

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.orcl.db

      1        ONLINE  ONLINE       node01                   Open,HOME=/u01/app/o

                                                             racle/product/12.2.0

                                                             /dbhome_1,STABLE

      2        ONLINE  ONLINE       node02                   Open,HOME=/u01/app/o

                                                             racle/product/12.2.0

                                                             /dbhome_1,STABLE

--------------------------------------------------------------------------------

[grid@node01 ~]$

 

[root@node01 bin]# ./crsctl stat res ora.LISTENER.lsnr -p | grep -w CHECK_INTERVAL

CHECK_INTERVAL=60

[root@node01 bin]# ./crsctl modify res ora.LISTENER.lsnr -attr "CHECK_INTERVAL=30"

CRS-4995:  The command 'Modify  resource' is invalid in crsctl. Use srvctl for this command.

[root@node01 bin]# ./crsctl modify resource ora.LISTENER.lsnr -attr "CHECK_INTERVAL=30"

CRS-4995:  The command 'Modify  resource' is invalid in crsctl. Use srvctl for this command.

[root@node01 bin]# ./crsctl modify resource ora.LISTENER.lsnr -attr "CHECK_INTERVAL=30" -unsupported

[root@node01 bin]# ./crsctl stat res ora.LISTENER.lsnr -p | grep -w CHECK_INTERVAL

CHECK_INTERVAL=30

[root@node01 bin]# ./crsctl modify resource ora.LISTENER.lsnr -attr "CHECK_INTERVAL=60"

CRS-4995:  The command 'Modify  resource' is invalid in crsctl. Use srvctl for this command.

[root@node01 bin]# ./crsctl modify resource ora.LISTENER.lsnr -attr "CHECK_INTERVAL=60" -unsupported

[root@node01 bin]# ./crsctl stat res ora.LISTENER.lsnr -p | grep -w CHECK_INTERVAL

CHECK_INTERVAL=60

[root@node01 bin]#

 

12c 이후로는 속성 변경을 임의 수정하는 것을 방지하고 있음.