• ORA-28001 the password has expired

    Here are the steps to solve the problem of expired and locked accounts :

    • log into your host running oracle and become the oracle user :
      -bash-4.1$ sqlplus / 'as sysdba'
      SQL*Plus: Release Production on Sun Nov 8 14:33:23 2015  
      Copyright (c) 1982, 2011, Oracle.  All rights reserved.
      Connected to:
      Oracle Database 11g Enterprise Edition Release - 64bit Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing opt
    • List all Expired accounts:
      select username, account_status from dba_users where ACCOUNT_STATUS LIKE '%EXPIRED%';
    • Unlock the user which is locked :
      ALTER USER <user name> IDENTIFIED BY <password> ACCOUNT UNLOCK;
    • You can show the profile of the user and disable the expiry date for it (most users will have the profile name default) :
      SELECT username, profile FROM DBA_USERS;


    Categories: Oracle

    Comments are currently closed.