OraFAQ Forum: Server Administration » non-expiring SYSTEM and SYS password

Home » RDBMS Server » Server Administration » non-expiring SYSTEM and SYS password (11g XE on RHEL6)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

non-expiring SYSTEM and SYS password [message #564630]

Mon, 27 August 2012 03:35

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>

Report message to a moderator

Re: non-expiring SYSTEM and SYS password [message #564632 is a reply to message #564630]

Mon, 27 August 2012 03:52

cookiemonster
Messages: 13959
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.

Report message to a moderator

Re: non-expiring SYSTEM and SYS password [message #564633 is a reply to message #564632]

Mon, 27 August 2012 03:57

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And regarding the title, SYS password never expires anyway.

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 14:41:19 CST 2024