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 11.2.0.3.0 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 11.2.0.3.0 - 64bit Production
  With the Partitioning, OLAP, Data Mining and Real Application Testing opt
  
  SQL>

• 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;

  ALTER PROFILE "DEFAULT" LIMIT PASSWORD_VERIFY_FUNCTION NULL;

Categories: Oracle

Zpanel Webalizer Stats Module fix Determine the Oracle Database Uptime