Home » RDBMS Server » Server Administration » ORA-07445 (oracle 10.1.0.2.0,HP-UX)
ORA-07445 [message #412552] Fri, 10 July 2009 00:06 Go to next message
vinniora
Messages: 56
Registered: October 2008
Location: Mumbai
Member
WHEN I AM FIRING A QUERY
SELECT NVL(ab.c_nm,c.c_nm) , NVL(ab.cg,c.cg), ab.aqty, ab.bqty,c.cqty, NVL(ab.aqty,0)+ NVL(ab.bqty,0)+ NVL(c.cqty,0) tot, 1 SEQ FROM
(SELECT NVL(a.c_nm,b.c_nm) c_nm, NVL(A.cg,b.cg) cg , SUM(A.QTY) aqty, SUM(B.QTY) bqty, NULL cqty, SUM(A.QTY+B.QTy) sumab
FROM (SELECT SHIFT, Cargo_Name(cargo_type) C_NM, cargo_type cg, qty FROM ISP.ZJ_JETTY_OP_AUTO WHERE WORK_DATE = '08072009'
AND SHIFT = 'A') A
FULL OUTER JOIN
(SELECT SHIFT, Cargo_Name(cargo_type) c_nm, cargo_type cg, qt
FROM ISP.ZJ_JETTY_OP_AUTO
WHERE WORK_DATE = '08072009'
AND SHIFT = 'B') b
ON (a.c_nm = b.c_nm)
GROUP BY NVL(a.c_nm,b.c_nm), NVL(A.cg,b.cg)) AB
FULL OUTER JOIN
SELECT c.c_nm c_nm, c.cg , NULL aqty, NULL bqty, c.QTy cqty, c.QTy sumab
FROM(SELECT SHIFT, Cargo_Name(cargo_type) C_NM, cargo_type cg, qty
FROM ISP.ZJ_JETTY_OP_AUTO
-- where cargo_type= 10000079
WHERE WORK_DATE = '08072009'
AND SHIFT = 'C') c) c
ON (ab.c_nm = c.c_nm)
i am getting a error
Reason code: 005a
*** 2009-07-10 10:13:51.510
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [vopdup()+529] [SIGBUS] [Invalid address alignment] [0x00000002A] [] []
Why is this happening, not only this i am not able to use explain plan for that it returns a error end of communication file.plz help me out
Re: ORA-07445 [message #412555 is a reply to message #412552] Fri, 10 July 2009 00:10 Go to previous messageGo to next message
BlackSwan
Messages: 25032
Registered: January 2009
Location: SoCal
Senior Member
>ORA-07445: exception encountered: core dump [vopdup()+529] [SIGBUS] [Invalid address alignment] [0x00000002A] [] []

Solution is to submit Service Request to http:metalink.oracle.com
Re: ORA-07445 [message #412558 is a reply to message #412555] Fri, 10 July 2009 00:18 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Okay before submit service request check this metalink document 454838.1

[Updated on: Fri, 10 July 2009 00:18]

Report message to a moderator

Re: ORA-07445 [message #412571 is a reply to message #412552] Fri, 10 July 2009 01:01 Go to previous message
vinniora
Messages: 56
Registered: October 2008
Location: Mumbai
Member
thank you for the reply
Previous Topic: Multiple Ports on a Single Listener
Next Topic: UNIX SCRIPT FOR AWR
Goto Forum:
  


Current Time: Fri Dec 02 12:40:50 CST 2016

Total time taken to generate the page: 0.08640 seconds