Cluster Health Advisor(ochad) in Oracle RAC Environment

Cluster Health Advisor(ochad) in RAC Oracle Environment

Oracle Cluster Health Advisor runs as on available cluster resource, ochad, on each node in the cluster.
Each Oracle Cluster Health Advisor daemon (ochad) monitors the operating system on the cluster node and each database instance on the RAC Nodes.

Fetch report from Cluster health check advisory

-- TEXT file
chactl query diagnosis -db oltpacdb -start "2019-02-01 02:00:00" -end "2019-02-01 03:00:00"

-- HTML
chactl query diagnosis -start "2016-07-03 20:50:00" -end "2016-07-04 03:50:00" -htmlfile ~/chaprob.html

Monitor the database
Note: CHACTL run with user Grid to turn on monitoring of the database.

chactl monitor database –db db_unique_name

Stop the monitoring of database

chactl unmonitor database –db db_unique_name

Check monitoring status of all cluster nodes and databases

chactl status -verbose

Retrieve the repository details

chactl query repository

specified max retention time(hrs) : 72
available retention time(hrs) : 212
available number of entities : 2
allocated number of entities : 0
total repository size(gb) : 2.00
allocated repository size(gb) : 0.07

Change the retention time in hours

chactl set maxretention -time number_of_hours
Example
chactl set maxretention -time 80
max retention successfully set to 80 hours

View the Status of Cluster Health Advisory Service on all nodes

srvctl status cha
Cluster Health Advisor is running on nodes racNode1, racNode2.
Cluster Health Advisor is not running on nodes racNode3, racNode4.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.