Trying to connect using APPS_JDBC_URL
Exception occurred: java.sql.SQLException: ORA-28000: the account is locked
We see from the logs that the account we are using is locked.
so login into the db and check the default profile for the user:
SELECT username, account_status,profile FROM dba_users WHERE username= 'APPS'
APPS LOCKED DEFAULT
SELECT resource_name,resource_type,limit FROM dba_profiles WHERE profile='DEFAULT' AND RESOURCE_NAME ='FAILED_LOGIN_ATTEMPTS'
FAILED_LOGIN_ATTEMPTS PASSWORD 10
So after 10 attempts the account gets locked.
You can unlock and live with it :
SQL>
alter user apps account unlock;
or
Increase the FAILED_LOGIN_ATTEMPTS limit in the default profile
alter profile default limit FAILED_LOGIN_ATTEMPTS 50;
or
create a new whole profile and assign it to the user
Experience: is what you get soon after you need it.
****************I am authoring a Book on Oracle Database Cloud Services.......More details to follow.***************
Title : Oracle Database Cloud Revealed
Publisher : Apress
Release Date : June-2018
**********************************************************************************
I am certified Oracle Cloud Architect:
Oracle Cloud Infrastructure 2018 Certified Architect Associate
Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate

No comments:
Post a Comment