Oracle Database Discovery Issues on Oracle Real Application Clusters (Oracle RAC) Systems

Description:

On Oracle Real Application Clusters (Oracle RAC) systems, Oracle Orachk discovers the database resources registered in the Oracle Cluster Registry.

The ORACLE_HOME for the database resources is derived from the profile of the database resources.

Cause:

If there is a problem with any of the profiles of the database resources, then Oracle Orachk cannot recognize or connect to one or more databases. Use the -dbnames option temporarily to fix the problem.

Action:

Specify the names of the database in a comma-delimited list as follows:

$ orachk -dbnames ORCL,ORADB

Alternatively, use the space-delimited environment variable RAT_DBNAMES:

$ export RAT_DBNAMES="ORCL ORADB"

Use double quotes to specify more than one database.

Note:

Configure the RAT_DBHOMES environment variable if you,

• Configure RAT_DBNAMES as a subset of databases registered in the Oracle Clusterware
• Want to check the patch inventories of ALL databases found registered in the Oracle Clusterware for recommended patches By default, the recommended patch analysis is limited to the homes for the list of databases specified in the RAT_DBNAMES environment variable.

To perform the recommended patch analysis for additional database homes, specify space-delimited list of all database names in the RAT_DBHOMES environment variable.

For example:

export RAT_DBNAMES="ORCL ORADB"

export RAT_DBHOMES="ORCL ORADB PROD"

Best practice checks are applied to ORACL and ORADB.

Recommended patch checks are applied to ORACL, ORADB, and PROD.