ORA-28002: the password will expire within 7 days Options

davegate Posts: 182 Points: 894
Posted: Friday, October 20, 2017 10:38:39 PM

SQL*Plus: Release 12.1.0.2.0 Production on Fri Oct 20 22:35:09 2017

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

ERROR:
ORA-28002: the password will expire within 7 days


Last Successful login time: Fri Oct 20 2017 22:27:38 -04:00

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing opt
ions


davegate Posts: 182 Points: 894
Posted: Friday, October 20, 2017 10:41:54 PM

Solutions 1: change the password to avoid it temporary

SQL> PASSWORD

Changing password for SCOTT

Old password:

New password:

Retype new password:

Password changed

 


davegate Posts: 182 Points: 894
Posted: Friday, October 20, 2017 11:37:32 PM

Solution 2

Set PASSWORD_LIFE_TIME of the profile assigned user to UNLIMITEDthen change the password to avoid it permanently
  
  c:\> sqlplus scott/tiger

  SQL> connect / as sysdba
  Connected.
 
  SQL> SELECT PROFILE FROM dba_users WHERE username = 'SCOTT';

  PROFILE
  ------------------------------
  DEFAULT

  SQL> SELECT  LIMIT FROM DBA_PROFILES WHERE PROFILE='DEFAULT'
  AND RESOURCE_NAME='PASSWORD_LIFE_TIME';

  LIMIT
  ----------------------------------------
  60

  SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

  Profile altered.

  SQL> SELECT ACCOUNT_STATUS FROM DBA_USERS WHERE USERNAME='SCOTT';

  ACCOUNT_STATUS
  --------------------------------
  EXPIRED(GRACE)

  SQL> connect scott/tiger
  Connected.
 
  SQL> PASSWORD
  Changing password for SCOTT
  Old password:
  New password:
  Retype new password:
  Password changed

Users browsing this topic
Guest