This discussion is archived
6 Replies Latest reply: Sep 28, 2010 4:16 PM by 684323 RSS

ORA-12850

684323 Newbie
Currently Being Moderated
Hey,

we have two nodes RAC (oracle 10.2.0.4), get error like,

ORA-12012: error on auto execute of job 396473 No severity defined for:
ORA-12850: Could not allocate slaves on all specified instances:
ORA-12850: Could not allocate slaves on all specified Err ORA12801 Sev Unknownerror signaled in parallel query server PZ96, instance lsid4137:ELFVRFI11 (1)


searching web, find answer like:

cause:

Parallel_execution_message_size is not the same on all nodes in a cluster,

how to fix

Set the parallel_execution_message_size to be same on all cluster nodes and restart them to take effect immediately

but we checked, our two nodes Parallel_execution_message_size are same, so what other reason can casue this problem/how to fix?


Thank you
Roy

Edited by: ROY123 on Aug 25, 2010 1:35 PM
  • 1. Re: ORA-12850
    sb92075 Guru
    Currently Being Moderated
    When did the RAC last work OK?
    What changed?

    Do both node pass all phases of cluvfy? Post proof
  • 2. Re: ORA-12850
    684323 Newbie
    Currently Being Moderated
    The job failed last night.
    The legancy RAC is no problem .

    Thank you
  • 3. Re: ORA-12850
    sb92075 Guru
    Currently Being Moderated
    12850, 00000, "Could not allocate slaves on all specified instances: %s needed, %s allocated"
    // *Cause: When executing a query on a gv$ fixed view, one or more 
    //         instances failed to allocate a slave to process query.
    // *Action:Check trace output for instances on which slaves failed to start.
    //         GV$ query can only proceed if slaves can be allocated on all
    //         instances.
  • 4. Re: ORA-12850
    684323 Newbie
    Currently Being Moderated
    yes, I checked alertlog,

    (I just got the access to the server, the message before is gotten form other people who need my help)

    acturally the error like below:

    ORA-12012: error on auto execute of job 396473
    ORA-12850: Could not allocate slaves on all specified instances: ORA-12850: Could not allocate slaves on all specified instances: 2 needed, 1 allocated
    ORA-12801: error signaled in parallel query server PZ96, instance lsid4137:ELFVRFI11 (1)
    ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
    ORA-06512: at "ORACLE_OCM.MGMT_CONFIG", line 135
    ORA-06512: at "ORACLE_OCM.MGMT_CONFIG", line 137
    needed, allocated
  • 5. Re: ORA-12850
    SalmanQureshi Expert
    Currently Being Moderated
    Hello

    http://ora-02391.ora-code.com/

    Salman
  • 6. Re: ORA-12850
    684323 Newbie
    Currently Being Moderated
    This problem has been resovled, I found user's profile has resource limit, (can not open session >1 ).

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points