Oracle user Account status LOCKED (TIMED)

Step 1--> connect / as sysdba user

Step 2--> Check the account status

SELECT username, account_status FROM dba_users;

SELECT username, account_status FROM dba_users where username='GSMUSER';

USERNAME ACCOUNT_STATUS PROFILE
-------------------- -------------------- ---------------
GSMUSER LOCKED(TIMED) DEFAULT

STEP 3-->Avoid this type of locking issue I have to create a new profile with FAILED_LOGIN_ATTEMPTS values as UNLIMITED and assign this new profile to the user

Step 4--> Create a new profile name for locked username for you are identification purpose only

SQL> CREATE PROFILE GSMUSER_NOEXPIRY LIMIT
  COMPOSITE_LIMIT UNLIMITED
  PASSWORD_LIFE_TIME UNLIMITED
  PASSWORD_REUSE_TIME UNLIMITED
  PASSWORD_REUSE_MAX UNLIMITED
  PASSWORD_VERIFY_FUNCTION NULL
  PASSWORD_LOCK_TIME UNLIMITED
  PASSWORD_GRACE_TIME UNLIMITED
  FAILED_LOGIN_ATTEMPTS UNLIMITED;

Step 5 - Assign New profile to the user as default profile

SQL>Alter user GSMUSER  profile GSMUSER_NOEXPIRY;

User altered. 

Step 6--> Unlock user account

SQL>Alter user GSMUSER  account unlock;

User altered.

Step 7--> Now check Status for GSMUSER user

SELECT username, account_status FROM dba_users where username='GSMUSER';