ORA-1841 Error Connecting to Upgraded Database After Set PASSWORD_LIFE_TIME
Last updated on NOVEMBER 22, 2016
Applies to:Oracle Server - Enterprise Edition
Information in this document applies to any platform.
Checked for relevance on 12-Mar-2010
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;
2. Upgrade this database to V8 and test if user test1 can connect:
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:
ORA 1841: (full) year must be between -4713 and +4713 / +9999
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms