RE: password going to expire
Date: Tue, 4 Sep 2012 12:26:40 -0400
Message-ID: <C3F905167E081B418BFC63B8668D52FF245F231D28_at_GOXEXVS03.fplu.fpl.com>
Very strange. I've done the same steps and it works for me. I've never seen anything like this before. Have you raised an SR with Oracle? USER1 _at_ db1 > SELECT USERNAME,ACCOUNT_STATUS,profile,EXPIRY_DATE 2 FROM DBA_USERS
3 WHERE USERNAME = 'USER1';
USERNAME ACCOUNT_STATUS PROFILE EXPIRY_DA
------------------------------ -------------------------------- ------------------------------ ---------
USER1 OPEN DBA_PROFILE 08-SEP-12
USER1 _at_ db1 > ALTER PROFILE DBA_PROFILE LIMIT
2 PASSWORD_LIFE_TIME UNLIMITED
3 /
Profile altered.
USER1 _at_ db1 > SELECT USERNAME,ACCOUNT_STATUS,profile,EXPIRY_DATE
2 FROM DBA_USERS
3 WHERE USERNAME = 'USER1';
USERNAME ACCOUNT_STATUS PROFILE EXPIRY_DA
------------------------------ -------------------------------- ------------------------------ ---------
USER1 OPEN DBA_PROFILE
USER1 _at_ db1 > ALTER PROFILE DBA_PROFILE LIMIT PASSWORD_LIFE_TIME 60;
Profile altered.
USER1 _at_ db1 > SELECT USERNAME,ACCOUNT_STATUS,profile,EXPIRY_DATE
2 FROM DBA_USERS
3 WHERE USERNAME = 'USER1';
USERNAME ACCOUNT_STATUS PROFILE EXPIRY_DA
------------------------------ -------------------------------- ------------------------------ ---------
USER1 OPEN DBA_PROFILE 08-SEP-12
Jeremy
From: dba1 mcc [mailto:mccdba1_at_yahoo.com]
Sent: Tuesday, September 04, 2012 12:13 PM
To: Sheehan, Jeremy
Cc: oracle-l_at_freelists.org
Subject: Re: password going to expire
Enter user-name: system
Enter password:
ERROR:
ORA-28002: the password will expire within 1 days
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> set linesize 132
SQL> Select username,profile,expiry_date
2 From dba_users
3 Where username = 'USER1';
USERNAME PROFILE EXPIRY_DA
------------------------------ ------------------------------ ---------
USER1 DEFAULT 05-SEP-12 SQL>
SQL>
SQL> alter profile default limit PASSWORD_LIFE_TIME unlimited;
Profile altered.
SQL>
SQL> Select username,profile,expiry_date
2 From dba_users
3 Where username = 'USER1';
USERNAME PROFILE EXPIRY_DA
------------------------------ ------------------------------ ---------
USER1 DEFAULT 05-SEP-12 ________________________________
From: "Sheehan, Jeremy" <JEREMY.SHEEHAN_at_nexteraenergy.com> To: dba1 mcc <mccdba1_at_yahoo.com>
Sent: Tuesday, September 4, 2012 12:07 PM Subject: RE: password going to expire
What are the results when you run the following query?
Select username,profile,expiry_date
From dba_users
Where username = 'USER1'
Jeremy
From: dba1 mcc [mailto:mccdba1_at_yahoo.com]
Sent: Tuesday, September 04, 2012 12:07 PM
To: Sheehan, Jeremy
Subject: Re: password going to expire
default profile change to "unlimited" correctly.
I also tried :
alter profile default limit PASSWORD_LIFE_TIME 360;
still same warning.
From: "Sheehan, Jeremy" <JEREMY.SHEEHAN_at_nexteraenergy.com> To: "mccdba1_at_yahoo.com" <mccdba1_at_yahoo.com>; "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: Tuesday, September 4, 2012 11:58 AM Subject: RE: password going to expire
What are the results when you run the following query?
Select username,profile,expiry_date
From dba_users
Where username = 'USER1'
Jeremy
-----Original Message-----
From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> [mailto:oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>] On Behalf Of dba1 mcc
Sent: Tuesday, September 04, 2012 11:29 AM
To: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>
Subject: password going to expire
We have ORACLE database on ORACLE 11.2.0.3 when I use "sqlplus" login and get warning:
Enter user-name: user1
Enter password:
ERROR:
ORA-28002: the password will expire within 1 days
I double check password_life_time set to 180 (default). I change it to unlimited.
SQL> alter profile default limit PASSWORD_LIFE_TIME unlimited;
I still get same warning:
Enter user-name: user1
Enter password:
ERROR:
ORA-28002: the password will expire within 1 days
Anyone know why?
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 04 2012 - 11:26:40 CDT