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;

Adadmin And Adpatch APPS Password Issue

Recent Posts

Recent Comments

RSS