Logo Background

Adadmin And Adpatch APPS Password Issue

  • By on August 5, 2009 | Comments Off on Adadmin And Adpatch APPS Password Issue

    Sometimes you face the error when using AD utilities, adadmin or adpatch where you can’t connect to the APPS account.

    Enter the ORACLE password of Application Object Library [APPS] : 
     
    AD Administration 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.

    But when you do a sqlplus apps/password, you are able to connect as APPS user without problem.

    So why is this happening? First you need to check the APPLSYS and APPS account whether these account expired or locked.

    SELECT USERNAME, LOCK_DATE , EXPIRY_DATE
    FROM dba_users
    WHERE USERNAME = 'APPLSYS';
    SELECT USERNAME, LOCK_DATE , EXPIRY_DATE
    FROM dba_users
    WHERE USERNAME = 'APPS';

    If yes, simply issue the command using system access to unlocked the account and try to run adadmin or adpatch again with fresh start.

    ALTER USER APPLSYS account UNLOCK;
     
    ALTER USER APPS account UNLOCK;
    Previous
    Next
    » How To Compile JSP Files In Oracle Applications