My Oracle Support Banner

ORA-1841 Error Connecting to Upgraded Database After Set PASSWORD_LIFE_TIME (Doc ID 130639.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Server - Enterprise Edition
Information in this document applies to any platform.
Checked for relevance on 12-Mar-2010


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

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
ORA 1841: (full) year must be between -4713 and +4713 / +9999


To view full details, 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 a vibrant support community of peers and Oracle experts.