By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.