Open Account Expired/Locked in Oracle


SQL> select username,account_status from dba_users;
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
MGMT_VIEW OPEN
SYS OPEN
SYSTEM OPEN
DBSNMP OPEN
SYSMAN OPEN
RASHAD OPEN
ALIM OPEN
OUTLN EXPIRED & LOCKED
ANAR EXPIRED & LOCKED
ORDSYS EXPIRED & LOCKED
CTXSYS EXPIRED & LOCKED
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
ANONYMOUS EXPIRED & LOCKED
EXFSYS EXPIRED & LOCKED
DMSYS EXPIRED & LOCKED
WMSYS EXPIRED & LOCKED
XDB EXPIRED & LOCKED
ORDPLUGINS EXPIRED & LOCKED
SI_INFORMTN_SCHEMA EXPIRED & LOCKED
OLAPSYS EXPIRED & LOCKED
MDDATA EXPIRED & LOCKED
DIP EXPIRED & LOCKED
SCOTT EXPIRED & LOCKED
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
TSMSYS EXPIRED & LOCKED
23 rows selected.
SQL> alter user ANAR account unlock;
User altered.
SQL> conn ANAR/ANAR
ERROR:
ORA-28001: the password has expired

Changing password for ANAR
New password:
Retype new password:
SP2-0650: New passwords do not match
Password unchanged
Warning: You are no longer connected to ORACLE.
SQL> conn ANAR/ANAR
ERROR:
ORA-01017: invalid username/password; logon denied
Note: Here I Typed mismatched Password
SQL> conn /as sysdba;
Connected.
SQL> select username,account_status from dba_users;
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
MGMT_VIEW OPEN
SYS OPEN
SYSTEM OPEN
DBSNMP OPEN
SYSMAN OPEN
RASHAD OPEN
ALIM OPEN
ANAR EXPIRED
OUTLN EXPIRED & LOCKED
ORDSYS EXPIRED & LOCKED
CTXSYS EXPIRED & LOCKED
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
ANONYMOUS EXPIRED & LOCKED
EXFSYS EXPIRED & LOCKED
DMSYS EXPIRED & LOCKED
WMSYS EXPIRED & LOCKED
XDB EXPIRED & LOCKED
ORDPLUGINS EXPIRED & LOCKED
SI_INFORMTN_SCHEMA EXPIRED & LOCKED
OLAPSYS EXPIRED & LOCKED
MDDATA EXPIRED & LOCKED
DIP EXPIRED & LOCKED
SCOTT EXPIRED & LOCKED
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
TSMSYS EXPIRED & LOCKED
23 rows selected.
SQL> conn ANAR/ANAR
ERROR:
ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.
SQL> conn ANAR/ANAR
ERROR:
ORA-28001: the password has expired

Changing password for ANAR
New password:
Retype new password:
Password changed
Connected.
SQL> show user;
USER is "ANAR"
SQL> conn / as sysdba;
Connected.
SQL> select username,account_status from dba_users;
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
MGMT_VIEW OPEN
SYS OPEN
SYSTEM OPEN
ANAR OPEN
DBSNMP OPEN
SYSMAN OPEN
RASHAD OPEN
ALIM OPEN
OUTLN EXPIRED & LOCKED
ORDSYS EXPIRED & LOCKED
CTXSYS EXPIRED & LOCKED
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
ANONYMOUS EXPIRED & LOCKED
EXFSYS EXPIRED & LOCKED
DMSYS EXPIRED & LOCKED
WMSYS EXPIRED & LOCKED
XDB EXPIRED & LOCKED
ORDPLUGINS EXPIRED & LOCKED
SI_INFORMTN_SCHEMA EXPIRED & LOCKED
OLAPSYS EXPIRED & LOCKED
MDDATA EXPIRED & LOCKED
DIP EXPIRED & LOCKED
SCOTT EXPIRED & LOCKED
USERNAME ACCOUNT_STATUS
------------------------------ --------------------------------
TSMSYS EXPIRED & LOCKED
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: