User SYS Does Not Get ORA-28002 Nor ORA-28001 Even When PASSWORD_LIFE_TIME or PASSWORD_GRACE_TIME are Set

(Doc ID 289898.1)

Last updated on AUGUST 20, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.4 and later
Information in this document applies to any platform.
Checked for relevance on 07-Jun-2013


Goal

The PASSWORD_LIFE_TIME and PASSWORD_GRACE_TIME parameters of a resource profile seem to be working for all the users but not for SYS:

SQL> create profile test_prof
limit password_life_time 5/1440 -- 5 minutes
password_grace_time 1/1440; -- 1 minute

SQL> set time on

14:07:34 SQL> alter user SYS profile test_prof;
14:07:39 SQL> alter user SYSTEM profile test_prof;

14:08:40 SQL> connect SYS/oracle as sysdba
connected.

14:08:41 SQL> connect SYSTEM/oracle
ERROR:
ORA-28002: the password will expire within 0 days
connected.

14:33:40 SQL> connect SYS/oracle as sysdba
connected.

14:34:33 SQL> connect SYSTEM/manager
ERROR:
ORA-28001: the password has expired

 

Is there anything to be done to solve this?

 

Solution

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