Follow the procedures in this section to troubleshoot and fix Oracle Clusterware or Oracle Database issues.
12.5.1 Oracle Clusterware Software is Installed, but Cannot be Found
Oracle ORAchk discovers the location of the Oracle Clusterware home from the
Problems discovering the
Problems with the
One or more paths in the
oraInventoryfiles are incorrect
Ensure that the
oraInst.locfile is located correctly and is properly formed.If the file is not in the default location, then set the
RAT_INV_LOCenvironment variable to point to the
$ export RAT_INV_LOC=oraInventory directory
If necessary, set the
RAT_CRS_HOMEenvironment variable to point to the location of the Oracle Clusterware home:
$ export RAT_CRS_HOME=CRS_HOME
12.5.2 Oracle Database Software Is Installed, but Cannot Be Found
Oracle ORAchk and Oracle EXAchk display this message if the tools cannot find the Oracle Database software installed.
If the Oracle Database software is installed, but Oracle ORAchk and
Oracle EXAchk cannot find, then set the
RAT_ORACLE_HOME environment variable to the applicable
For example, enter the following command, where
your-oracle-home is the path to the Oracle
home on your system:
$ export RAT_ORACLE_HOME=your-oracle-home
Oracle ORAchk and Oracle EXAchk perform best practice and recommended
patch checks for all the databases running from the home specified in the
RAT_ORACLE_HOME environment variable.
12.5.3 Oracle Database Software Is Installed, but Version cannot Be Found
Oracle ORAchk and Oracle EXAchk display this message if the tools cannot find the version of the Oracle Database software installed.
If Oracle ORAchk and Oracle EXAchk cannot find the correct version, then
RAT_DB environment variable to the applicable
$ export RAT_DB=220.127.116.11.0
12.5.4 Oracle ASM Software is Installed, but Cannot be Found
Oracle ORAchk and Oracle EXAchk display this message if the tools cannot find the Oracle ASM software installed.
RAT_ASM_HOMEenvironment variable to the applicable home directory.
$ export RAT_ASM_HOME=ASM_HOME
12.5.5 Oracle Database Discovery Issues on Oracle Real Application Clusters (Oracle RAC) Systems
On Oracle Real Application Clusters (Oracle RAC) systems, Oracle ORAchk discovers the database resources registered in the Oracle Cluster Registry.
ORACLE_HOME for the database resources
is derived from the profile of the database resources.
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.
$ orachk -dbnames ORCL,ORADB
$ export RAT_DBNAMES="ORCL ORADB"
Use double quotes to specify more than one database.
variable if you,
RAT_DBNAMESas 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.
export RAT_DBNAMES="ORCL ORADB"
export RAT_DBHOMES="ORCL ORADB PROD"
Best practice checks are applied to
Recommended patch checks are applied to
12.5.6 Oracle Database Login Problems
grid, and if you experience problems connecting to the database, then perform the following steps:
- Log in to the system as
export ORACLE_HOME=path of Oracle database home
export ORACLE_SID=database SID
- Add alias in the
- Connect to the database using
$ORACLE_HOME/bin/sqlplus "sys@SID as sysdba", and enter the password.
- Ensure that you have a successful connection.
If this method of connecting to the database does not work, then Oracle ORAchk and Oracle EXAchk do not connect either.
If you have multiple homes owned by different users and you are not able to login to the target database as the user running Oracle ORAchk independently in SQL*Plus, then Oracle ORAchk does not login either.
If the operating system authentication is not set up, then it should still prompt you for user name and password.