Not able to change the password of Oracle user '<alter user <username> identified by <password>;' is
<alter user <username> identified by <password>; is hanging forever until we kill the process manually.
i have checked the lock on the user_history$ table and it was locked by this SID and no one else able to change their passwords as well as there is already lock on that.
Please help me in understanding what needs to be done here.
----------------------------------------------------------------------
Oracle session identified by:
{
instance: 1 (svwprd1b.svwprd1b_1)
os id: 44171644
process id: 363, oracle@ghacpdb040bhrx8
session id: 2167
session serial #: 136
}
is waiting for 'CRS call completion' with wait info:
{
p1: 'clsrrestype'=0xe
p2: 'kjha_action'=0x6
time in wait: 23 min 2 sec