How to Unlock a user in Oracle DB



Check User is Locked

SELECT username, account_status FROM dba_users;

List of Locked Users

SELECT username,account_status,lock_date from dba_users where lock_date IS NOT NULL;

Unlock User

ALTER USER user_name IDENTIFIED BY password ACCOUNT UNLOCK;

1 comment:

  1. 18/06/16-07:30:48 Optic: requestRetry(/dump?type=dms&dmsarg=[name=/&format=pdml]): Failed to create secure socket for OPMN at Roby.home:9501
    requestRetry(/dump?type=dms&dmsarg=[name=/&format=pdml]) at 18/06/16-07:30:48
    InetSocketAddress: Roby.home:9501
    dialOpmn: SSL Roby.home:9501 wallet=C:\obiee_weblogic\user_projects\domains\bifoundation_domain\opmn\instance1\wallet timeout=60000ms
    dialOpmn: SSL connect failed (Failed to create secure socket for OPMN at Roby.home:9501): Roby.home:9501
    18/06/16-07:30:48 Optic: requestRetry(/dump?type=dms&dmsarg=[name=/&format=pdml]): Failed to create secure socket for OPMN at Roby.home:9501

    ReplyDelete