Patching issue after database upgrade

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

While applying an apps patch 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