Running Oracle Orachk on Microsoft Windows Throws '{oratab}' is empty Error

Description:

Running Oracle Orachk commands throws the following error:

'{oratab}' is empty.
Verify Oracle database registry entries name in '{regout}' in case Oracle database is install.
If Oracle database registry entries name does not contains 'ORA'/'OH'
then set registry key patterns using 'RAT_KEY_DB' environment variable.

Cause:

  1. Oracle Database is not present on the system.
  2. The keyword for Oracle Database registry key is different. Generally the registry key contains ORA or OH , but on some systems it can be different. Set the environment variable RAT_KEY_DB to the right Oracle Database registry keyword.
  3. The initialization parameter file initSID.ora is missing from $ORACLE_HOME/database.

Oracle Orachk looks for the initSID.ora file in $ORACLE_HOME/database for getting the instance name. If the initSID.ora file is not present, then you will encounter the aforementioned error.

Action:

Specify Oracle Database details using the -dbconfig option.

orachk -dbconfig db_home_path%db_name