"The account is locked" error

I need some explanation on an error: "ORA-28000: the account is locked." I am running my package procedure which has a remote link to another database. The link already exists and works. When I checked my account in SQL*Plus, I found that the account was not locked. Without any changes I was able to run the package again in 30 minutes with no errors.

    Requires Free Membership to View

    Login

From your description, it looks like your account is locked for a short while, and then is unlocked. The most common reason is that your user's profile is locking the account due to too many invalid logon attempts. After a predetermined time, the account is automatically unlocked. The FAILED_LOGIN_ATTEMPTS resource of the profile determines how many times a login attempt can fail before the account is locked. This account is locked for the number of seconds defined by the PASSWORD_LOCK_TIME resource of the profile.

This was first published in March 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top