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
