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;

Failed to create secure socket for OPMN at localhost:9501

Starting OPMN through EM fails (coreApplicaton ->Availability -> Startall)

OPMN fails with the following error in the adminserver.log

[2013-10-16T19:45:29.227-04:00] [AdminServer] [ERROR] [] [oracle.as.management.mbeans.opmn] [tid: OpmnProcessThread-status-46] [userId: <WLS Kernel>] [ecid: 54e490aa440fd7d3:53495834:141c3910d0a:-8000-00000000000000b1,0] [APP: NonJ2EEManagement] OPMN.queryProcessStatus failed with the following exception[[
oracle.as.management.opmn.optic.OpticBadConnectException: Failed to create secure socket for OPMN at hostname:9501

Cause

The processes were not started in the correct order

Once OPMN is started, EM is able to contact opmn, and request for a process to be started.
but if you try to do the same without opmn.exe running then you would get the error above
oracle.as.management.opmn.optic.OpticBadConnectException: Could not get secure socket for localhost  and port 9501

Solution

Start opmn.exe by the following

Start --> cmd --> opmnctl start


Then once OPMN is started, EM is able to contact opmn, and request for a process to be started.
but if you try to do the same .. without opmn.exe running then you would get the error that we are seeing now ...
So the conclusion is that you cannot start the BI processes thru EM if the OPMN process is not started
.