Home » RDBMS Server » Server Administration » non-expiring SYSTEM and SYS password (11g XE on RHEL6)
non-expiring SYSTEM and SYS password [message #564630] Mon, 27 August 2012 03:35 Go to next message
oranooob
Messages: 88
Registered: May 2009
Member
Hi

that's what I did:

SQL> select profile from DBA_USERS where username = 'SYSTEM';

PROFILE
------------------------------
DEFAULT

SQL> alter profile DEFAULT limit password_life_time UNLIMITED;

Profile altered.


But I get still the warning message every login. ORA-28002: the password will expire within 7 days.

$ sqlplus system/oracle111@XE

SQL*Plus: Release 11.2.0.2.0 Production on Mon Aug 27 10:29:03 2012

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

ERROR:
ORA-28002: the password will expire within 7 days



Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

SQL>

Re: non-expiring SYSTEM and SYS password [message #564632 is a reply to message #564630] Mon, 27 August 2012 03:52 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
Password expiry is calculated when the password is set, not when the profile is changed.
Reset the password and the new one will never expire.
Re: non-expiring SYSTEM and SYS password [message #564633 is a reply to message #564632] Mon, 27 August 2012 03:57 Go to previous message
Michel Cadot
Messages: 67295
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And regarding the title, SYS password never expires anyway.

Regards
Michel
Previous Topic: AUDIT on SYS
Next Topic: SPM: SMB space usage (1369833472) exceeds 10.000000% of SYSAUX size (4194304000)
Goto Forum:
  


Current Time: Wed Aug 12 05:09:02 CDT 2020