ORA-01017: invalid username/password logon denied

When we are trying to connect database as

$sqlplus / as sysdba

Error:

ORA-01017: invalid username/password; logon denied

SP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus

Solution:

We need to change the password file

Connect to oracle user and change directory to

$cd $ORACLE_HOME/dbs

$orapwd file=$ORACLE_HOME/dbs/oraSID password=xyz force=y

Here you have to enter your password instead of xyz and your DB name instead of SID.

Posted by: Anil Bandi

Oracle Apps DBA