Question: I am
getting the ORA-28002 error, and I want all of my users to not have
a password that expires:
ERROR: ORA-28002: the password will expire within
All of my users password control is done at the application
server, so I don't need password expiration. How do I turn-off
this automatic user password expiration?
Answer: The se steps will turn =off
password expiration in Oracle 11g and beyond:
Step 1: Create a profile to use by all Oracle ID’s:
Step 2: Alter
all users to use this profile in SQL*Plus:
set heading off
select 'alter user '||username||' profile
my_profile;' from all_users;
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.