password going to expire
From: dba1 mcc <mccdba1_at_yahoo.com>
Date: Tue, 4 Sep 2012 08:28:40 -0700 (PDT)
Message-ID: <1346772520.46778.YahooMailNeo_at_web162706.mail.bf1.yahoo.com>
We have ORACLE database on ORACLE 11.2.0.3 when I use "sqlplus" login and get warning:
Date: Tue, 4 Sep 2012 08:28:40 -0700 (PDT)
Message-ID: <1346772520.46778.YahooMailNeo_at_web162706.mail.bf1.yahoo.com>
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-lReceived on Tue Sep 04 2012 - 10:28:40 CDT