password going to expire

  • From: dba1 mcc <mccdba1@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 4 Sep 2012 08:28:40 -0700 (PDT)

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?
--
//www.freelists.org/webpage/oracle-l


Other related posts: