web analytics
ORA-28002: the password will expire within 7 days Options
davegate
Posted: Friday, October 20, 2017 10:38:39 PM

Rank:Advanced Member
Groups: Member
Joined: 12/14/2015
Posts: 182
Points: 894

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

Sponsor
Posted: Friday, October 20, 2017 10:38:39 PM
davegate
Posted: Friday, October 20, 2017 10:41:54 PM

Rank:Advanced Member
Groups: Member
Joined: 12/14/2015
Posts: 182
Points: 894

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
Posted: Friday, October 20, 2017 11:37:32 PM

Rank:Advanced Member
Groups: Member
Joined: 12/14/2015
Posts: 182
Points: 894

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

Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.


© 2017 Digcode.com. All rights reserved.