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

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

Symptoms

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


Cause

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