ORA-07445 with a Web Application
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-07445 with a Web Application

  1. #1
    Join Date
    May 2005
    Location
    Guayaquil - Ecuador
    Posts
    1

    ORA-07445 with a Web Application

    Hi people: I had ORACLE 8.0.5 in Solaris 7, and a Web application development with PHP 3.
    Every day around 8 a.m. found a error in my alert_.ora and a various trace files in my
    USER_DUMP_DEST and very big core files that full my directory.

    The only DML that i found in the trace file is:

    SELECT P.CODIGO_PERSONAL,P.PRIMER_NOMBRE||' '||P.PRIMER_APELLIDO NOMBRE,
    P.CODIGO_DEPARTAMENTO
    FROM MGA_USUARIOS_SISTEMA U, MGA_PERSONAL P
    WHERE U.CODIGO_USUARIO = UPPER(:Lv_Usuario)
    AND P.CODIGO_PERSONAL = U.CODIGO_PERSONAL
    AND P.CODIGO_EMPRESA = U.CODIGO_EMPRESA


    And The trace files have this information:


    Dump file /oracle/8.0.5/admin/SOLC/udump/solc_ora_26684.trc
    Oracle8 Release 8.0.5.0.0 - Production
    PL/SQL Release 8.0.5.0.0 - Production
    ORACLE_HOME = /oracle/8.0.5
    System name: SunOS
    Node name: produccion
    Release: 5.7
    Version: Generic_106541-08
    Machine: sun4u
    Instance name: SOLC
    Redo thread mounted by this instance: 1
    Oracle process number: 108
    Unix process pid: 26684, image: oracleSOLC

    *** SESSION ID:(129.28) 2005.05.17.08.06.21.000
    Exception signal: 10 (SIGBUS), code: 1 (Invalid address alignment), addr: 0x30343a0d, PC: kzdurtc()+4
    *** 2005.05.17.08.06.22.000
    ksedmp: internal or fatal error
    ORA-07445: exception encountered: core dump [kzdurtc()+4] [SIGBUS] [Invalid address alignment] [808729101] [] []
    ----- Call Stack Trace -----
    calling call entry argument values in hex
    location type point (? means dubious value)
    -------------------- -------- -------------------- ----------------------------
    ksedmp()+148 CALL ksedst()+0 380 ? 1 ? FFBEC9AC ?
    FFBEC450 ? FFBEC434 ? 0 ?
    ssexhd()+368 CALL ksedmp()+0 3 ? 0 ? 1 ? FFBECEC4 ? 1 ?


    Thanks people, i need your help...!

    Christian Chan

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    raise a TAR with oracle support (if you sill have a contract)

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    i see oracle version is 8.0.5 i am not sure whether support guys would be helpful

    regards
    Hrishy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width