From your description, it sounds like individual Oracle database accounts are being locked, not the database itself...
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.
since there is really no way to lock the database as you've described. I have not seen any software behave in this manner. Is it possible that within the database there are profiles enabled (other than the default) to manage password expiration and complexity.
If this is the case, an account password would expire by a certain date (depending on what the frequency is set to) and the user must change their password. If the user does not change their password, and the grace period expires, the database account is locked preventing the user from logging in until the account is unlocked by a DBA. If there are complexity rules in place, the password must be a certain length, and contain numbers of other special characters. If password expiration and complexity are used within the database, the application software must be able to handle the Oracle errors that are generated so that the message is relayed back to the user and he or she can take appropriate action.
To determine whether profiles have been created, run the following query in SQL*Plus as a privileged or DBA user:
select distinct profile from dba_profiles;
If you get back more than just DEFAULT for a profile name, then there have been profiles created. To find out what limits have been set for each profile, you can run the following query:
select resource_name, resource_type from dba_profiles where profile_name='<name of profile>';
To determine where a database account has been locked, run the following SQL:
select username, account_status from dba_users;
To unlock an account:
alter user <username here> account unlock;
Related Q&A from Maria Anderson
Can I use /var/opt/oracle/oratab to specify listener information?continue reading
We would like to migrate our database from Oracle 8.1.7 to Oracle 10g. We would like to know the impact for our application developed using Delphi ...continue reading
I have been trying to install Oracle 8.1.7 on SUSE Linux 9.0 and got the error: "Error in invoking target install of makefile /opt/oracle/...../*.mk."continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.