6 Replies Latest reply: Sep 28, 2010 6:16 PM by 5181139 RSS

    ORA-12850

    5181139
      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
          When did the RAC last work OK?
          What changed?

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

            Thank you
            • 3. Re: ORA-12850
              sb92075
              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
                5181139
                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
                  Salman Qureshi
                  Hello

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

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