During the post clone in EBS Application, Removed the existing node entry and try to ran autoconfig on database tier. and its completed with error,
In log file,
WARNING: Exception occurred: java.sql.SQLException: ORA-28000: the account is locked
In log file,
WARNING: Exception occurred: java.sql.SQLException: ORA-28000: the account is locked
SQL> select username,account_status from dba_users where username like 'APPS';
USERNAME                       ACCOUNT_STATUS
------------------------------ --------------------------------
APPS                           LOCKED
SQL> alter user apps account unlock;
User altered.
$ sqlplus apps/apps
SQL*Plus: Release 11.2.0.4.0 on Sat Mar 10 01:11:11 2017
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
ERROR:
ORA-28000: the account is locked
Even after unlock the apps user also, same issue exists.
Solution:
SQL> select * from dba_profiles where RESOURCE_NAME like 'FAILED%';
PROFILE                        RESOURCE_NAME                    RESOURCE
------------------------------ -------------------------------- --------
LIMIT
----------------------------------------
DEFAULT                        FAILED_LOGIN_ATTEMPTS            PASSWORD
3
AD_PATCH_MONITOR_PROFILE       FAILED_LOGIN_ATTEMPTS            PASSWORD
3
EM_OAM_MONITOR_PROFILE         FAILED_LOGIN_ATTEMPTS            PASSWORD
3
SQL> alter profile DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;
Profile altered.
After changing the profile value as unlimited, we are able to connect apps user and auto config also completed successfully.
 
No comments:
Post a Comment