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

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

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]

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'

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

No comments: