Tuesday, August 09, 2011

What is ora.crf in 11.2.0.2 RAC?

I read some Oracle Document and curious with ora.crf !!! What is ora.crf? It's resource name on Oracle Clusterware 11gR2(new in 11.2.0.2).
$ crsctl stat res ora.crf -init
NAME=ora.crf
TYPE=ora.crf.type
TARGET=ONLINE
STATE=ONLINE on db01
ora.crf is the Cluster Health Monitor resource name that ohasd manages. On a single node, non-RAC server: You can download the Cluster Health Monitor from OTN.
I remember -) I posted Oracle Cluster Health Monitor(IPD/OS). In Today, it's used on Oracle RAC 11.2.0.2 with ora.crf resource name.

The Cluster Health Monitor collects OS statistics (system metrics) such as memory and swap space usage, processes, IO usage, and network related data. The Cluster Health Monitor collects information in real time and usually once a second. The Cluster Health Monitor collects OS statistics using OS API to gain performance and reduce the CPU usage overhead. The Cluster Health Monitor collects as much of system metrics and data as feasible that is restricted by the acceptable level of resource consumption by the tool.

You can check processes about it.
$ ps -aef | grep osysmond
root 10222 1 0 Jun24 ? 06:08:29 /u01/app/11.2.0/grid/bin/osysmond.bin
$ ps -aef | grep ologgerd
root 17379 1 0 Jun24 ? 04:12:30 /u01/app/11.2.0/grid/bin/ologgerd -M -d /u01/app/11.2.0/grid/crf/db/db01
Check what in "/u01/app/11.2.0/grid/crf/db/db01" folder.
$ find /u01/app/11.2.0/grid/crf/db/db01/
/u01/app/11.2.0/grid/crf/db/db01/
/u01/app/11.2.0/grid/crf/db/db01/db01.ldb
/u01/app/11.2.0/grid/crf/db/db01/__db.001
/u01/app/11.2.0/grid/crf/db/db01/__db.002
/u01/app/11.2.0/grid/crf/db/db01/__db.003
/u01/app/11.2.0/grid/crf/db/db01/__db.004
/u01/app/11.2.0/grid/crf/db/db01/__db.005
/u01/app/11.2.0/grid/crf/db/db01/__db.006
/u01/app/11.2.0/grid/crf/db/db01/log.0000016452
/u01/app/11.2.0/grid/crf/db/db01/log.0000016451
/u01/app/11.2.0/grid/crf/db/db01/crfconn.bdb
/u01/app/11.2.0/grid/crf/db/db01/crfclust.bdb
/u01/app/11.2.0/grid/crf/db/db01/crfhosts.bdb
/u01/app/11.2.0/grid/crf/db/db01/crfts.bdb
/u01/app/11.2.0/grid/crf/db/db01/crfalert.bdb
/u01/app/11.2.0/grid/crf/db/db01/crfcpu.bdb
/u01/app/11.2.0/grid/crf/db/db01/crfloclts.bdb
/u01/app/11.2.0/grid/crf/db/db01/repdhosts.bdb
It stills use Berkeley Database.
You can use "oclumon " command-line. Example:
$ oclumon -h
For help from command line : oclumon <verb> -h
For help in interactive mode : <verb> -h
Currently supported verbs are :
showtrail, showobjects, dumpnodeview, manage, version, debug, quit, exit, and help
$ oclumon dumpnodeview
dumpnodeview: Node name not given. Querying for the local host

----------------------------------------
Node: db01 Clock: '08-09-11 22.43.47' SerialNo:1111111
----------------------------------------

SYSTEM:
#cpus: 24 cpu: 3.76 cpuq: 2 physmemfree: 5250488 physmemtotal: 98848968 mcache: 24354864 swapfree: 25103500 swaptotal: 25165816 ior: 0 iow: 0 ios: 0 swpin: 0 swpout: 0 pgin: 0 pgout: 0 netr: 489.65 netw: 376.53 procs: 764 rtprocs: 58 #fds: 9493 #sysfdlimit: 6815744 #disks: 1 #nics: 4 nicErrors: 0

TOP CONSUMERS:
topcpu: 'ora_lms1_db1(7808) 11.20' topprivmem: 'crsd.bin(11581) 310456' topshm: 'ora_arc2_db1(7969) 61880' topfd: 'ocssd.bin(10510) 246' topthread: 'java(16503) 51'

----------------------------------------
Node: db01 Clock: '08-09-11 22.43.49' SerialNo:1111111
----------------------------------------

SYSTEM:
#cpus: 24 cpu: 3.76 cpuq: 2 physmemfree: 5256324 physmemtotal: 98848968 mcache: 24354868 swapfree: 25103500 swaptotal: 25165816 ior: 0 iow: 980 ios: 190 swpin: 0 swpout: 0 pgin: 0 pgout: 980 netr: 493.95 netw: 367.90 procs: 764 rtprocs: 58 #fds: 9491 #sysfdlimit: 6815744 #disks: 1 #nics: 4 nicErrors: 0

TOP CONSUMERS:
topcpu: 'ora_lms1_db1(7808) 8.94' topprivmem: 'crsd.bin(11581) 310456' topshm: 'ora_arc2_db1(7969) 61880' topfd: 'ocssd.bin(10510) 246' topthread: 'java(16503) 51'

----------------------------------------
Node: db01 Clock: '08-09-11 22.43.50' SerialNo:1111111
----------------------------------------

SYSTEM:
#cpus: 24 cpu: 4.68 cpuq: 1 physmemfree: 5252968 physmemtotal: 98848968 mcache: 24354876 swapfree: 25103500 swaptotal: 25165816 ior: 0 iow: 157 ios: 5 swpin: 0 swpout: 0 pgin: 0 pgout: 157 netr: 462.18 netw: 343.68 procs: 767 rtprocs: 58 #fds: 9515 #sysfdlimit: 6815744 #disks: 1 #nics: 4 nicErrors: 0

TOP CONSUMERS:
topcpu: 'ora_j000_db1(22431) 15.63' topprivmem: 'crsd.bin(11581) 310456' topshm: 'ora_arc2_db1(7969) 61880' topfd: 'ocssd.bin(10510) 246' topthread: 'java(16503) 51'

----------------------------------------
Node: db01 Clock: '08-09-11 22.43.50' SerialNo:1111111
----------------------------------------

SYSTEM:
#cpus: 24 cpu: 4.68 cpuq: 1 physmemfree: 5252968 physmemtotal: 98848968 mcache: 24354876 swapfree: 25103500 swaptotal: 25165816 ior: 0 iow: 157 ios: 5 swpin: 0 swpout: 0 pgin: 0 pgout: 157 netr: 462.18 netw: 343.68 procs: 767 rtprocs: 58 #fds: 9515 #sysfdlimit: 6815744 #disks: 1 #nics: 4 nicErrors: 0

TOP CONSUMERS:
topcpu: 'ora_j000_db1(22431) 15.63' topprivmem: 'crsd.bin(11581) 310456' topshm: 'ora_arc2_db1(7969) 61880' topfd: 'ocssd.bin(10510) 246' topthread: 'java(16503) 51'
Good -)

However, Bad news for me... There is currently no GUI tool available that can be used with the 11.2.0.2 version of the Cluster Health Monitor. The OTN-version of the GUI tool and the 11.2.0.2 version are incompatible.

Read more Cluster Health Monitor (CHM) FAQ [ID 1328466.1]
Related Post: Oracle Cluster Health Monitor(IPD/OS)

2 comments:

Anuj Tripathi said...

The latest version of OTN-GUI available on RACPACK website works with the GUI on Linux.

Surachart said...

Thank You for your commend. I checked on My Oracle Support and It inform The OTN-version of the GUI tool and the 11.2.0.2 version are incompatible.

no "crfgui" command on 11.2.0.2 RAC.

I will check more on 11.2.0.2 noe-rac again.