Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    OPIRIP: Uncaught error 447. Error stack: ORA-00447: fatal error in background

    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    ARC fails, but it seems the problem began in the ALEPH oracle:

    oracle@aleph(arc2)arc2/trace$cd /exlibris/app/oracle/diag/rdbms/aleph20/aleph20/trace/alert_aleph20.log
    oracle@aleph(arc2)arc2/trace$more alert_aleph20.log
    ....

    Thu Feb 24 09:33:28 2011
    Process J000 died, see its trace file
    kkjcre1p: unable to spawn jobq slave process
    Errors in file /exlibris/app/oracle/diag/rdbms/aleph20/aleph20/trace/aleph20_cjq0_13023.trc:

    oracle@aleph(arc2)aleph20/trace$more /exlibris/app/oracle/diag/rdbms/aleph20/aleph20/trace/aleph20_cjq0_13023.trc
    *** 2011-02-24 09:33:39.123
    OPIRIP: Uncaught error 447. Error stack:
    ORA-00447: fatal error in background process
    ORA-02097: parameter cannot be modified because specified value is invalid


    In the log file of www_server:
    **********************************
    www_server.log
    **********************************
    2011-02-24 09:34:38 04 [000] [vrb] IN 20110224 093438
    ip address: 10.10.21.28 1403
    request: "/F/AEB8HLQGRADT3XC5EYIGU4HKBGKRIFMGT4UPKQIGNME499KAM3-16069?func=short-jump&jump=000241"
    Cookie: __utma <21736127.922527093.1297708962.1298553867.1298555813.31>
    Cookie: __utmz <(none)t)|utmcmd8962.1.1.utmcsr>
    Cookie: __utmb <21736127.2.10.1298555813>
    Cookie: __utmc <21736127>
    Cookie: UserContext <3fcba2546e1144ae918455864f03a479>
    Cookie: ALEPH_SESSION_ID <AEB8HLQGRADT3XC5EYIGU4HKBGKRIFMGT4UPKQIGNME499KAM3>
    Header: Accept <*/*>
    Header: Referer <http://www.usat.edu.pe:8991/F/AEB8HLQGRADT3XC5EYIGU4HKBGKRIFMGT4UPKQIGNME499KAM3-15881?func=short-jump&jump=000231>
    Header: Accept-Language <es-pe>
    Header: User-Agent <Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; .NET CLR 3.0.04506.30; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)>
    Header: Accept-Encoding <gzip, deflate>
    Header: Host <www.usat.edu.pe:8991>
    Header: Connection <Keep-Alive>
    Header: Cookie <__utma=21736127.922527093.1297708962.1298553867.1298555813.31; __utmz=21736127.1297708962.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); __utmb=21736127.2.10.1298555813; __utmc=21736127; UserConte>

    Oracle error: update_cursor z63
    ORA-03135: connection lost contact
    Process ID: 9910
    Session ID: 390 Se

    Oracle error: io_commit
    ORA-03114: not connected to ORACLE

    ***************************************************
    * No ORACLE connection - process is terminated... *
    ***************************************************
    Load: /exlibris/aleph/u20_1/alephe/tab/tab_system_status
    Load: /exlibris/aleph/u20_1/alephe/tab/server_ip_allowed
    2011-02-24 09:34:38 21 [000] [vrb] IN 20110224 093438
    ip address: 10.10.21.28 1544
    request: "/F/AEB8HLQGRADT3XC5EYIGU4HKBGKRIFMGT4UPKQIGNME499KAM3-16069?func=short-jump&jump=000241"

    Oracle error: handle_connection
    ORA-01034: ORACLE not available
    ORA-27101: shared memory realm does no

    <end log file of www_server>


    The failed in Aleph Oracle provoked that the system ARC was stopping:
    CM-SYS-5007
    Content Manager build {Build} failed to start Review the Content Manager log files and the contact your system administrator or customer support.

    Resolution:
    Oracle on both sides, aleph and arc, was checked and found OK.
    OPAC and ARC reports were ran and found to be without error.
    The last ORA error was shown on 24 Feb. Is it posible that the error was fixed or disappeared due to some change in the network connection?


    • Article last edited: 10/8/2013