About Me

The best place to start learning Oracle, Linux/Unix scripting, and Oracle administration skills. Currently, as Oracle DBA with 11g/10g/9i OCP certified, I want to help you with my background and knowledge. Hopefully, this info would help you as a job aid.

Friday, January 27, 2012

some RAC environment command job aid I

It's a simple note for this article to provide few command aid in the cluster environment:

here is the command and example:
cluvfy comp crs --> check CRS integrity
cluvfy comp nodecon -n all  --> check node connectivity in cluster environment
<CRS_HOME>/bin/crs_stat -t  --> check CRS stats


hostname:/opt/oracle> cluvfy comp crs

Verifying CRS integrity

Checking CRS integrity...

Checking daemon liveness...
Liveness check passed for "CRS daemon".

Checking daemon liveness...
Liveness check passed for "CSS daemon".

Checking daemon liveness...
Liveness check passed for "EVM daemon".

Checking CRS health...
CRS health check passed.

CRS integrity check passed.

Verification of CRS integrity was successful.


hostname:/opt/oracle> cluvfy comp nodecon -n all

Verifying node connectivity

Checking node connectivity...

Node connectivity check passed for subnet "10.10.10.0" with node(s) host1, host2, host3.
Node connectivity check passed for subnet "146.18.118.128" with node(s) racstress6,racstress5,racstress4.

Suitable interfaces for VIP on subnet "146.18.118.128":
host3 eth0:146.18.118.153 eth0:146.18.118.206
host2 eth0:146.18.118.154 eth0:146.18.118.205
host1 eth0:146.18.118.155 eth0:146.18.118.204

Suitable interfaces for the private interconnect on subnet "10.10.10.0":
host3 bond0:10.10.10.3
host2 bond0:10.10.10.2
host1 bond0:10.10.10.1

Node connectivity check passed.

Verification of node connectivity was successful.
hostname:/opt/oracle/product/crs/10.2.0.3/bin> ./crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....22.inst application ONLINE UNKNOWN host2
ora....23.inst application ONLINE UNKNOWN host3
ora....R21.srv application ONLINE UNKNOWN host2
ora....r21.srv application ONLINE UNKNOWN host2
ora....ss4.gsd application ONLINE ONLINE host1
ora....ss4.ons application ONLINE OFFLINE
ora....ss4.vip application ONLINE ONLINE host1
ora....ss5.gsd application ONLINE ONLINE host2
ora....ss5.ons application ONLINE OFFLINE
ora....ss5.vip application ONLINE ONLINE host2
ora....ss6.gsd application ONLINE ONLINE host3
ora....ss6.ons application ONLINE OFFLINE
ora....ss6.vip application ONLINE ONLINE host3