Patching Issue After Database Upgrade

Patching Issue After Database Upgrade

Upgraded the database from 9i to 10g (10.2.0.2)

While applying a with adpatch following error occurs:

ORA-28000 account locked on the apps account
 
Reason:

The profile option "AD_PATCH_MONITOR_PROFILE" has not been set to "unlimited" and is still set at the default value of "3".

Solution:

1. Login as SYS or SYSTEM and run:
SQL> alter profile AD_PATCH_MONITOR_PROFILE limit failed_login_attempts unlimited;
SQL> alter profile default limit failed_login_attempts unlimited password_lock_time 1/1440;
SQL> alter user apps account unlock;

2. Retest for the issue.
 
Note: Examples of queries that can be used to check the APPS user account :
SQL> select profile , resource_name, limit from dba_profiles where resource_name like '%FAIL%';
SQL> select username, profile from dba_users where username='APPS';
SQL> select username, profile from dba_users where username='APPLSYS';

Reference Metalink id: 420001.1