1 2 Previous Next 15 Replies Latest reply: Mar 26, 2013 7:21 AM by Osama_Mustafa RSS

    ORA -Errors

    madala03
      Hi , i got few errors in the midnight , i checked for the documentation but i havent got proper clue on these errors please help me on these.


      ORA-00447: fatal error in background process
      ORA-22303: type "SYS"."AQ$_HISTORY" not found
      ORA-00604: error occurred at recursive SQL level 1
      ORA-04031: unable to allocate 704 bytes of shared memory ("shared pool","unknown object","KGLH0^b23236d","kkscs")

      Kind Regards

      Venkat
        • 1. Re: ORA -Errors
          madala03
          SGA:0x7556fc68 Flags=ae3
          DebugContext: DebugNameSpace=0 DebugType=0 DebugLevel=0x0 Did Not dump SGA Heap desc=0x60001190.
          Current time: 03/26/2013 01:25:36
          Last SGA heap dump at 03/26/2013 01:11:00
          SGA Heap Dump Count = 9
          ===============================
          End 4031 Diagnostic Information
          ===============================
          KSV 22303 error in slave process

          *** 2013-03-26 01:25:37.264
          ORA-22303: type "SYS"."AQ$_HISTORY" not found
          ORA-00604: error occurred at recursive SQL level 1
          ORA-04031: unable to allocate 704 bytes of shared memory ("shared pool","unknown object","KGLH0^b23236d","kkscs")
          OPIRIP: Uncaught error 447. Error stack:
          ORA-00447: fatal error in background process
          ORA-22303: type "SYS"."AQ$_HISTORY" not found
          ORA-00604: error occurred at recursive SQL level 1
          ORA-04031: unable to allocate 704 bytes of shared memory ("shared pool","unknown object","KGLH0^b23236d","kkscs")

          i am updating the full error message please go through this
          • 2. Re: ORA -Errors
            oralicious
            support. use the ora-4031 lookup tool. looks like a bug.
            • 3. Re: ORA -Errors
              moreajays
              Venkat,

              It looks issues with the shared pool & sga memory allocation , can you post show parameter sga & show parameter shared

              Refer this also

              ORA-04031: unable to allocate 4032 bytes of shared memory


              Thanks,
              Ajay More
              http://www.moreajays.com
              • 4. Re: ORA -Errors
                madala03
                These is my SGA size i gone through the error message which it says to increase the size of memory can you please check my memory below .please let me know if need to increase, how much i need to increase ?

                QL> show sga

                Total System Global Area 622149632 bytes
                Fixed Size 2230912 bytes
                Variable Size 520095104 bytes
                Database Buffers 92274688 bytes
                Redo Buffers 7548928 bytes
                SQL> show parameter sga

                NAME TYPE
                ------------------------------------ --------------------------------
                VALUE
                ------------------------------
                lock_sga boolean
                FALSE
                pre_page_sga boolean
                FALSE
                sga_max_size big integer
                596M
                sga_target big integer
                596M
                • 5. Re: ORA -Errors
                  madala03
                  HI i updated my SGA please go through my earlier message
                  • 6. Re: ORA -Errors
                    madala03
                    SQL> show parameter shared

                    NAME TYPE
                    ------------------------------------ --------------------------------
                    VALUE
                    ------------------------------
                    hi_shared_memory_address integer
                    0
                    max_shared_servers integer

                    shared_memory_address integer
                    0
                    shared_pool_reserved_size big integer
                    24956108
                    shared_pool_size big integer

                    NAME TYPE
                    ------------------------------------ --------------------------------
                    VALUE
                    ------------------------------
                    0
                    shared_server_sessions integer

                    shared_servers integer
                    1
                    SQL>
                    • 7. Re: ORA -Errors
                      moreajays
                      Hi ,

                      I would suggest to increase SGA_MAX_SIZE & SGA_TARGET by at-least 1 GB & re-try
                      Also it is recommended to review memory advisories using statspack/AWR to set optimal memory as per workload

                      Also , have look on below query to know how memory is distributed across the sga components
                      select * from v$sga_dynamic_components;
                      Thanks,
                      Ajay More
                      http://www.moreajays.com
                      • 8. Re: ORA -Errors
                        Osama_Mustafa
                        Check MOS note
                        OERR: ORA 447 fatal error in background process [ID 18446.1]
                        • 9. Re: ORA -Errors
                          madala03
                          COMPONENT CURRENT_SIZE MIN_SIZE MAX_SIZE USER_SPECIFIED_SIZE OPER_COUNT LAST_OPER_TYPE LAST_OPER_MODE LAST_OPER_TIME GRANULE_SIZE
                          ---------- ------------ ---------- ---------- ------------------- ---------- --------------------------------------- --------------------------- ------------------------------ ------------
                          shared poo ########## 427819008 503316480 0 335603 GROW IMMEDIATE 26-MAR-13 ##########
                          l

                          large pool ########## 12582912 12582912 0 0 STATIC ##########
                          java pool ########## 4194304 37748736 0 8 SHRINK DEFERRED 26-JAN-13 ##########
                          streams po ########## 0 0 0 0 STATIC ##########
                          ol

                          DEFAULT bu ########## 58720256 167772160 0 335611 SHRINK IMMEDIATE 26-MAR-13 ##########
                          ffer cache


                          COMPONENT CURRENT_SIZE MIN_SIZE MAX_SIZE USER_SPECIFIED_SIZE OPER_COUNT LAST_OPER_TYPE LAST_OPER_MODE LAST_OPER_TIME GRANULE_SIZE
                          ---------- ------------ ---------- ---------- ------------------- ---------- --------------------------------------- --------------------------- ------------------------------ ------------
                          KEEP buffe ########## 0 0 0 0 STATIC ##########
                          r cache

                          RECYCLE bu ########## 0 0 0 0 STATIC ##########
                          ffer cache

                          DEFAULT 2K ########## 0 0 0 0 STATIC ##########
                          buffer ca
                          che

                          DEFAULT 4K ########## 0 0 0 0 STATIC ##########

                          COMPONENT CURRENT_SIZE MIN_SIZE MAX_SIZE USER_SPECIFIED_SIZE OPER_COUNT LAST_OPER_TYPE LAST_OPER_MODE LAST_OPER_TIME GRANULE_SIZE
                          ---------- ------------ ---------- ---------- ------------------- ---------- --------------------------------------- --------------------------- ------------------------------ ------------
                          buffer ca
                          che

                          DEFAULT 8K ########## 0 0 0 0 STATIC ##########
                          buffer ca
                          che

                          DEFAULT 16 ########## 0 0 0 0 STATIC ##########
                          K buffer c
                          ache


                          COMPONENT CURRENT_SIZE MIN_SIZE MAX_SIZE USER_SPECIFIED_SIZE OPER_COUNT LAST_OPER_TYPE LAST_OPER_MODE LAST_OPER_TIME GRANULE_SIZE
                          ---------- ------------ ---------- ---------- ------------------- ---------- --------------------------------------- --------------------------- ------------------------------ ------------
                          DEFAULT 32 ########## 0 0 0 0 STATIC ##########
                          K buffer c
                          ache

                          Shared IO ########## 0 0 0 0 STATIC ##########
                          Pool

                          ASM Buffer ########## 0 0 0 0 STATIC ##########
                          Cache


                          14 rows selected.

                          SQL> col LAST_OPER_MODE for a30
                          SQL> /

                          COMPONENT CURRENT_SIZE MIN_SIZE MAX_SIZE USER_SPECIFIED_SIZE OPER_COUNT LAST_OPER_TYPE LAST_OPER_MODE LAST_OPER_TIME GRANULE_SIZE
                          ---------- ------------ ---------- ---------- ------------------- ---------- --------------------------------------- ------------------------------ ------------------------------ ------------
                          shared poo ########## 427819008 503316480 0 335603 GROW IMMEDIATE 26-MAR-13 ##########
                          l

                          large pool ########## 12582912 12582912 0 0 STATIC ##########
                          java pool ########## 4194304 37748736 0 8 SHRINK DEFERRED 26-JAN-13 ##########
                          streams po ########## 0 0 0 0 STATIC ##########
                          ol

                          DEFAULT bu ########## 58720256 167772160 0 335611 SHRINK IMMEDIATE 26-MAR-13 ##########
                          ffer cache


                          COMPONENT CURRENT_SIZE MIN_SIZE MAX_SIZE USER_SPECIFIED_SIZE OPER_COUNT LAST_OPER_TYPE LAST_OPER_MODE LAST_OPER_TIME GRANULE_SIZE
                          ---------- ------------ ---------- ---------- ------------------- ---------- --------------------------------------- ------------------------------ ------------------------------ ------------
                          KEEP buffe ########## 0 0 0 0 STATIC ##########
                          r cache

                          RECYCLE bu ########## 0 0 0 0 STATIC ##########
                          ffer cache

                          DEFAULT 2K ########## 0 0 0 0 STATIC ##########
                          buffer ca
                          che

                          DEFAULT 4K ########## 0 0 0 0 STATIC ##########
                          • 10. Re: ORA -Errors
                            Osama_Mustafa
                            Also When You post question mention DB version and OS version
                            • 11. Re: ORA -Errors
                              madala03
                              Hi , thanks for the update sorry it is my mistake i am updating now


                              Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
                              PL/SQL Release 11.2.0.3.0 - Production
                              CORE 11.2.0.3.0 Production
                              TNS for Linux: Version 11.2.0.3.0 - Production
                              NLSRTL Version 11.2.0.3.0 - Production

                              Regards

                              Venkat
                              • 12. Re: ORA -Errors
                                madala03
                                Hi just now i gone to my alertlog thoroughly i happens at 1:06am and finished at 1:25am those error messages which updated during that particular time after that i can see a message which is



                                ORA-22303: type "SYS"."AQ$_HISTORY" not found
                                ORA-00604: error occurred at recursive SQL level 1
                                ORA-04031: unable to allocate 704 bytes of shared memory ("shared pool","unknown object","KGLH0^b23236d","kkscs")
                                </txt>
                                </msg>
                                <msg time='2013-03-26T01:28:46.460+00:00' org_id='oracle' comp_id='rdbms'
                                msg_id='ksbcr1p:3914:1976272125' client_id='' type='NOTIFICATION'
                                group='process start' level='16' host_id='gbahevl467.gb.tntpost.com'
                                host_addr='10.210.103.181' module='' pid='25662'>
                                <txt>Restarting dead background process RECO
                                </txt>
                                </msg>
                                <msg time='2013-03-26T01:28:46.482+00:00' org_id='oracle' comp_id='rdbms'
                                msg_id='ksbrdp:4225:3697353022' type='NOTIFICATION' group='process start'
                                level='16' host_id='gbahevl467.gb.tntpost.com' host_addr='10.210.103.181'
                                pid='23143'>
                                <txt>RECO started with pid=53, OS id=23143
                                </txt>
                                </msg>
                                <msg time='2013-03-26T02:00:00.686+00:00' org_id='oracle' comp_id='rdbms'
                                client_id='' type='UNKNOWN' level='16'
                                host_id='gbahevl467.gb.tntpost.com' host_addr='10.210.103.181' module=''
                                pid='25672'>
                                <txt>Closing Resource Manager plan via scheduler window
                                </txt>
                                </msg>
                                <msg time='2013-03-26T02:00:00.687+00:00' org_id='oracle' comp_id='rdbms'
                                client_id='' type='UNKNOWN' level='16'
                                host_id='gbahevl467.gb.tntpost.com' host_addr='10.210.103.181' module=''
                                pid='25672'>
                                <txt>Clearing Resource Manager plan via parameter


                                Regards

                                Venkat
                                • 13. Re: ORA -Errors
                                  Osama_Mustafa
                                  Refer to
                                  Master Note for Diagnosing ORA-4031 [ID 1088239.1]


                                  what is your setup do you ASM , RAC , Or just stand alone ( Single Node ) ?
                                  • 14. Re: ORA -Errors
                                    madala03
                                    Hi Thanks for the update


                                    this is RAC


                                    Regards

                                    Venkat
                                    1 2 Previous Next