Ask the Expert

"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

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: