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