@@@@Platform-“OnPrem”

@@@@Product-“Database”

@@@@ReleaseVersion-“26.11”

@@@@info-map-label-“Oracle Database Login Problems”

Oracle Database Login Problems

Oracle Database login problems arise if you run Oracle Orachk and Oracle Exachk without sufficient privileges. If you run Oracle Orachk and Oracle Exachk as a user other than the database software installation owner, root or grid, and if you experience problems connecting to the database, then perform the following steps:

  1. Log in to the system as grid (operating system).
  2. Run export ORACLE_HOME=*`path of Oracle database home`*
  3. Run export ORACLE_SID=*`database SID`*
  4. Run export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/lib:$PATH
  5. Add alias in the $ORACLE_HOME/network/admin/tnsnames.ora file for *`database SID`* .
  6. Connect to the database using $ORACLE_HOME/bin/sqlplus "sys@*`SID`* as sysdba" , and enter the password.
  7. 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.