Experience: is what you get soon after you need it.

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


Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

I am certified Oracle Cloud Architect:
Oracle Cloud Infrastructure 2018 Certified Architect Associate
Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate

Search This Blog

Tuesday, June 28, 2011

ORA-28000: the account is locked

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'


SELECT resource_name,resource_type,limit FROM dba_profiles WHERE profile='DEFAULT' AND RESOURCE_NAME ='FAILED_LOGIN_ATTEMPTS'


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

No comments: