My Oracle Support Banner

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

Last updated on AUGUST 17, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 8.0.4.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
 


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 <USERNAME> in a V7 database:
grant connect, resource to <USERNAME> identified by <PASSWORD>;
connect <USERNAME>/<PASSWORD>

2. Upgrade this database to V8 and test if user <USERNAME> can connect:
sqlplus <USERNAME>/<PASSWORD>
connected

3. Create and assign a profile that limits password_life_time:
create profile <PROFILE> limit password_life_time 10;
alter user <USERNAME> profile <PROFILE>;

4. Try to connect as user <USERNAME>:
sqlplus <USERNAME>/<PASSWORD>
ERROR:
ORA 1841: (full) year must be between -4713 and +4713 / +9999


Changes

 

Cause

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.