Tuesday, May 29, 2012

AutoPatch is verifying your username/password....Unable to connect.

Adpatch Issue:

Even though giving correct 'apps' password, adpatch again and again prompts for 'apps' password saying unable to connect.

Error:


Enter the ORACLE password of Application Object Library [APPS] :

AutoPatch is verifying your username/password....Unable to connect.

Error: The given ORACLE password is not the correct password.
Please re-enter the ORACLE username and password.

Enter the ORACLE password of Application Object Library [APPS] :

Fix:

Issue could be 'applsys' account got locked. Check for it.

SQL> select username,ACCOUNT_STATUS, LOCK_DATE from dba_users where USERNAME in ('APPS','APPLSYS','SYSTEM');

USERNAME                       ACCOUNT_STATUS                   LOCK_DATE
------------------------------ -------------------------------- ---------------
SYSTEM                         OPEN
APPLSYS                        LOCKED(TIMED)                    29-MAY-12
APPS                           OPEN

SQL> alter user APPLSYS account unlock;

User altered.

UR's Key Run ;-) 

No comments:

Post a Comment