@@@@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:
- Log in to the system as
grid(operating system). - Run
export ORACLE_HOME=*`path of Oracle database home`* - Run
export ORACLE_SID=*`database SID`* - Run
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/lib:$PATH - Add alias in the
$ORACLE_HOME/network/admin/tnsnames.orafile for*`database SID`*. - 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.