Thursday, January 3, 2019

Set environment variable RAT_DBNAMES to name of the database and re-run


One day i was running exachk, immediately process stoped with below message 

root@escinfra01:/export/home/oracle/exachk# ./exachk

Searching for running databases . . . . .

Databases are not registered in Clusterware to check best practices. Set environment variable RAT_DBNAMES to name of the database and re-run.
eg. like export RAT_DBNAMES="TESTDB,PRODDB"

root@escinfra01:/export/home/oracle/exachk#

Cause

I figured out that this server was holding some databases which are not registered with Cluster as result exachk is terminating and requesting for proper SID's to be set.

Solution

I set RAT_DBNAMES to one of my database which is registered with cluster and re-executed exachk and it through.

root@escinfra01:/export/home/oracle# export RAT_DBNAMES=dbm08
root@escinfra01:/export/home/oracle#
root@escinfra01:/export/home/oracle/exachk# ./exachk
.  .
.  .
Checking Status of Oracle Software Stack - Clusterware, ASM, RDBMS
.
.  .  .  . . . .  .  .  .
-------------------------------------------------------------------------------------------------------
                                                 Oracle Stack Status
-------------------------------------------------------------------------------------------------------
  Host Name       CRS Installed  RDBMS Installed    CRS UP    ASM UP  RDBMS UP    DB Instance Name
-------------------------------------------------------------------------------------------------------
 escinfra01                 Yes          Yes          Yes      Yes       No
-------------------------------------------------------------------------------------------------------

No comments:

Post a Comment