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.

• 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.