| ORA-07445 Errors. [message #59474] |
Mon, 24 November 2003 22:08  |
Mark Chatwin
Messages: 3
Registered: November 2003
|
Junior Member |
|
|
Oracle ORA-07445 errors.
Hello I am getting lots of 07445 internal errors trying to run certain SQL queries on our Oracle 9i database. I have the .trc files from the server which contains the stack dump of the thread which is crashing. Please can you advise me how to resolve this issue.
Here is a sample of the trace file.
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x0, PC: [[0x40481760, strcpy()+64]]
*** 2003-11-25 09:50:43.023
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [[strcpy()+64]] [[SIGSEGV]] [[Address not mapped to object]] [[0x0]] [[]] [[]]
ORA-07445: exception encountered: core dump [[strcpy()+64]] [[SIGSEGV]] [[Address not mapped to object]] [[0x0]] [[]] [[]]
ORA-07445: exception encountered: core dump [[evaopn2()+282]] [[SIGSEGV]] [[Address not mapped to object]] [[0x0]] [[]] [[]]
Current SQL statement for this session:
SELECT SUBSTR(GETTIMING_UNIWOH(TBLWORKORDERS.WO_ID,'U'),1,10) AS UDATE, TBLWORKORDERS.WO_TYPE, TBLWORKORDERTYPES.WO_TYPE_DESC,
SUM(TBLINVOICECOSTS.INV_COST) AS COST, SUM(TBLINVOICECOSTS.INV_ADJUSTMENT) AS ADJUSTMENT, SUM(TBLINVOICECOSTS.INV_GST) AS GST,
COUNT(TBLWORKORDERS.WO_ID) AS QTY, SUM(TBLINVOICECOSTS.INV_COST+TBLINVOICECOSTS.INV_ADJUSTMENT+TBLINVOICECOSTS.INV_GST) AS NETT
FROM (TBLWORKORDERS LEFT JOIN TBLINVOICECOSTS ON TBLWORKORDERS.WO_ID = TBLINVOICECOSTS.WO_ID) LEFT JOIN TBLWORKORDERTYPES ON
(TBLWORKORDERS.WO_TYPE = TBLWORKORDERTYPES.WO_TYPE) AND (TBLWORKORDERS.CONTRACT_ID = TBLWORKORDERTYPES.CONTRACT_ID) WHERE
(((TBLWORKORDERS.CONTRACT_ID)='ORI001') AND ((TBLWORKORDERS.WO_STATUS)='U') AND (GETTIMING_UNIWOH(TBLWORKORDERS.WO_ID,'U') BETWEEN '01/11/2003 00:00:00' AND '30/11/2003 23:59:59')) GROUP BY SUBSTR(GETTIMING_UNIWOH(TBLWORKORDERS.WO_ID,'U'),1,10), TBLWORKORDERS.WO_TYPE,
TBLWORKORDERTYPES.WO_TYPE_DESC
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
I can send you the whole file if you need it.
The query appears to work if I replace the LEFT JOINS with INNER JOINS. Maybe I have found a bug in Oracle. We are running Oracle 9i on Red Hat Linux 7.3.
Can anyone confirm if this is a bug?
Regards,
Mark.
|
|
|
|
| Re: ORA-07445 Errors. [message #59484 is a reply to message #59474] |
Wed, 26 November 2003 02:01  |
Frank Naude
Messages: 4579
Registered: April 1998
|
Senior Member |
|
|
Hi,
Yip, this looks like a bug. Have you applied the latest Oracle patch set? If not, it might be worth a try as several issues with "ANSI Type Joins" are fixed in the latest patch set.
Best regards.
Frank
|
|
|
|
| Re: ORA-07445 Errors. [message #59487 is a reply to message #59474] |
Wed, 26 November 2003 07:39 |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Also, I've heard of some serious security issues with ANSI Joins in 9i. So you are better off applying the latest patchset as Frank suggested.
-Thiru
|
|
|
|
| Re: ORA-07445 Errors. [message #59528 is a reply to message #59484] |
Sun, 30 November 2003 17:15 |
Mark Chatwin
Messages: 3
Registered: November 2003
|
Junior Member |
|
|
Please can someone tell me where to download the patches for 9i (we have version 9.0.1.0.0)?
I have searched the Oracle page and have not found them in the download section.
|
|
|
|
| Re: ORA-0745 Errors. [message #60343 is a reply to message #59484] |
Mon, 02 February 2004 17:16 |
healthyao
Messages: 1
Registered: February 2004
|
Junior Member |
|
|
we have also the problems related with ORA-07445 Errors.
the error message is ORA-07445: åºç°å¼å¸? æ ¸å¿è½¬å¨ [[ksmarfg()+612]] [[SIGBUS]] [[Object specific hardware error]] [[0xFC8A0000]] [[]] [[]].
Could someone tell me that this problem can be solved by applying the latest paches to ORACLE 9i?
thanks!
Healthyao
|
|
|
|
| Re: ORA-07445 Errors. [message #171349 is a reply to message #59474] |
Tue, 09 May 2006 08:19 |
Fayyaz
Messages: 7
Registered: April 2005
|
Junior Member |
|
|
I am getting the same error on Red hat linux environment. The database is 9.2.0.4
The error is:
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [parhshs()+86] [SIGSEGV] [Address not mapped to object] [0xADFCD38] [] []
This error occur when i compile a form.
anyone have an idea to resolve the error?
in push button here is code:
Declare
Lv_1 Varchar2(200);
BEGIN
Lv_1 := Pkg_Test.pkg_version;
message(lv_1);
message(lv_1);
END;
and package definition is
============
CREATE OR REPLACE PACKAGE Pkg_Test IS
Lv_Full_name Partners.FULL_NAME%TYPE;
Lv_Owner Partners.Owner_Code%TYPE;
FUNCTION get_name (P1 In Partners.FULL_NAME%tYPE, P2 In Partners.Owner_Code%tYPE) RETURN VARCHAR2;
FUNCTION pkg_version RETURN VARCHAR2;
FUNCTION get_package_date RETURN DATE;
FUNCTION get_package_who RETURN VARCHAR2;
END Pkg_Test;
/
prompt Creating package body PKG_TEST
prompt ==============================
CREATE OR REPLACE PACKAGE BODY Pkg_Test Is
FUNCTION get_name (P1 In Partners.FULL_NAME%TYPE, P2 In Partners.Owner_Code%TYPE) RETURN VARCHAR2 Is
Begin
return p1||p2;
ENd;
FUNCTION pkg_version RETURN VARCHAR2 Is
Begin
Return '1.2.3';
End;
FUNCTION get_package_date RETURN DATE Is
Begin
Return Sysdate;
End;
FUNCTION get_package_who RETURN VARCHAR2 is
Begin
Return User;
End;
End Pkg_Test;
/
Thanks for any help
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
