4 Replies Latest reply: Jan 22, 2013 4:54 AM by JohnWatson RSS

    Resource Manager issue.

    864988
      Hello,

      Database version: 11.2.0.3 HP_UX
      SQL> execute DBMS_RESOURCE_MANAGER.CREATE_PENDING_AREA();
      
      PL/SQL procedure successfully completed.
      
      SQL> execute DBMS_RESOURCE_MANAGER.VALIDATE_PENDING_AREA;
      
      PL/SQL procedure successfully completed.
      
      SQL> execute DBMS_RESOURCE_MANAGER.SUBMIT_PENDING_AREA;
      
      PL/SQL procedure successfully completed.
      
      
      SQL> BEGIN
      dbms_resource_manager.create_plan('SYSTEM_PLAN','Plan to give system sessions priority','EMPHASIS','ACTIVE_SESS_POOL_ABSOLUTE','PARALLEL_DEGREE_LIMIT_ABSOLUTE','FIFO_TIMEOUT');COMMIT; END; 2
      3 /
      BEGIN
      *
      ERROR at line 1:
      ORA-29371: pending area is not active
      ORA-06512: at "SYS.DBMS_RMIN", line 63
      ORA-06512: at "SYS.DBMS_RESOURCE_MANAGER", line 111
      ORA-06512: at line 2
      Any idea how to solve the issue?
        • 1. Re: Resource Manager issue.
          Fran
          ORA-29371:
          pending area is not active
          Cause:     An attempt was made to make changes without creating a pending area.
          Action:     Invoke procedure CREATE_PENDING_AREA before making any changes.
          • 2. Re: Resource Manager issue.
            Osama_Mustafa
            Check MOS Note
            ORA-29371 & ORA-06512 Using Resource Manager Packages [ID 114549.1]
            • 3. Re: Resource Manager issue.
              864988
              Fran wrote:
              ORA-29371:
              pending area is not active
              Cause:     An attempt was made to make changes without creating a pending area.
              Action:     Invoke procedure CREATE_PENDING_AREA before making any changes.
              I already do that, please see my previous post
              • 4. Re: Resource Manager issue.
                JohnWatson
                DBA wrote:
                Fran wrote:
                ORA-29371:
                pending area is not active
                Cause:     An attempt was made to make changes without creating a pending area.
                Action:     Invoke procedure CREATE_PENDING_AREA before making any changes.
                I already do that, please see my previous post
                Yes you did, but then you removed it with SUBMIT_PENDING_AREA. You need to do your work between the CREATE_PENDING_AREA and the VALIDATE_PENDING_AREA.