Re: password going to expire

From: Sriram Kumar <k.sriramkumar_at_gmail.com>
Date: Fri, 7 Sep 2012 09:58:31 +0530
Message-ID: <CAEq4C0f4L3zh2VLuuR85SJE8YH4mqM67-9NuqmrLhqmDQXeo+A_at_mail.gmail.com>

Hi,
If the user is already expired and is in the grace period then you will face this. pls reset the password to same value using

alter user <username> identified by values <query from user$ for name=username>

should solve the problem

best regards

sriram kumar

On Tue, Sep 4, 2012 at 8:58 PM, dba1 mcc <mccdba1_at_yahoo.com> wrote:

> 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

Received on Thu Sep 06 2012 - 23:28:31 CDT