Database Administration (MOSC)

MOSC Banner

Not able to change the password of Oracle user '<alter user <username> identified by <password>;' is

edited Jul 20, 2015 10:00AM in Database Administration (MOSC) 1 commentAnswered

<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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center