This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Mar 26, 2013 5:21 AM by Osama_Mustafa RSS

ORA -Errors

madala03 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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
    User477708-OC Journeyer
    Currently Being Moderated
    support. use the ora-4031 lookup tool. looks like a bug.
  • 3. Re: ORA -Errors
    moreajays Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    HI i updated my SGA please go through my earlier message
  • 6. Re: ORA -Errors
    madala03 Newbie
    Currently Being Moderated
    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 Pro
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    Check MOS note
    OERR: ORA 447 fatal error in background process [ID 18446.1]
  • 9. Re: ORA -Errors
    madala03 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    Also When You post question mention DB version and OS version
  • 11. Re: ORA -Errors
    madala03 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    Hi Thanks for the update


    this is RAC


    Regards

    Venkat
1 2 Previous Next

Legend

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