Q

"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.

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.
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 last published in March 2006

Dig Deeper on Oracle database design and architecture

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close