Re: password going to expire

  • From: Sriram Kumar <k.sriramkumar@xxxxxxxxx>
  • To: mccdba1@xxxxxxxxx
  • Date: Fri, 7 Sep 2012 09:58:31 +0530

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@xxxxxxxxx> 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


Other related posts: