Problem:
~~~~~~~~
When you upgrade the database from Oracle V7 to V8, and then create a profile
which limits password_life_time, existing users cannot login to the database.
New users can login without a problem.
To reproduce this problem:
1. Create a test user (test1) in a V7 database:
grant connect, resource to test1 identified by test1;
connect test1/test1
2. Upgrade this database to V8 and test if user test1 can connect:
sqlplus test1/test1
connected
3. Create and assign a profile that limits password_life_time:
create profile testprofile limit password_life_time 10;
alter user test1 profile testprofile;
4. Try to connect as user test1:
sqlplus test1/test1
ERROR:
ORA 1841: (full) year must be between -4713 and +4713 / +9999
Solution:
~~~~~~~~~
Alter the user and change the password,
– or –
Alter the profile and change password_life_time to unlimited.
You can ‘change’ the password for every user in such a way that it keeps the
original value (useful when you do not want to trouble users with a password
change) by using the method from Note 1051962.101
Explanation:
~~~~~~~~~~~~
This is Bug 711547