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 :
alter user apps account unlock;
Increase the FAILED_LOGIN_ATTEMPTS limit in the default profile
alter profile default limit FAILED_LOGIN_ATTEMPTS 50;
create a new whole profile and assign it to the user