Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> error message in trc files
Kenny MC
post Feb 22 2005, 09:55 AM
Post #1


Advanced Member
***

Group: Members
Posts: 36
Joined: 8-October 04
Member No.: 784



hi,

i use for oracle log and trc files, a little tool how parse errors and send as a
e-mail to me.

But sometimes are Oracle errors are not really informative. sad.gif

Have anybody an Idea???

HP-UX 11.23 (Risc64) > Oracle 9.2.0.2

at this time Database seems work normal.

Tue Feb 22 13:17:14 2005
Errors in file /opt/oracle/admin/divaora/udump/divaora_ora_5015.trc:
ORA-00600: internal error code, arguments: [12333], [115], [32], [100], [], [], [], []
Tue Feb 22 13:17:33 2005
Errors in file /opt/oracle/admin/divaora/udump/divaora_ora_5015.trc:
ORA-07445: exception encountered: core dump [kghalf()+216] [SIGSEGV] [unknown code] [0x3FFFFFFFFF0] [] []
ORA-00600: internal error code, arguments: [12333], [115], [32], [100], [], [], [], []
Tue Feb 22 13:18:11 2005
Errors in file /opt/oracle/admin/divaora/udump/divaora_ora_5015.trc:
ORA-07445: exception encountered: core dump [kghalf()+216] [SIGSEGV] [unknown code] [0x3FFFFFFFFF0] [] []
ORA-07445: exception encountered: core dump [kghalf()+216] [SIGSEGV] [unknown code] [0x3FFFFFFFFF0] [] []
ORA-00600: internal error code, arguments: [12333], [115], [32], [100], [], [], [], []
Tue Feb 22 13:19:10 2005
Errors in file /opt/oracle/admin/divaora/udump/divaora_ora_5015.trc:
ORA-07445: exception encountered: core dump [kghalf()+216] [SIGSEGV] [unknown code] [0x3FFFFFFFFF0] [] []
ORA-07445: exception encountered: core dump [kghalf()+216] [SIGSEGV] [unknown code] [0x3FFFFFFFFF0] [] []
ORA-07445: exception encountered: core dump [kghalf()+216] [SIGSEGV] [unknown code] [0x3FFFFFFFFF0] [] []
ORA-00600: internal error code, arguments: [12333], [115], [32], [100], [], [], [], []
Tue Feb 22 13:26:34 2005
Errors in file /opt/oracle/admin/divaora/udump/divaora_ora_12000.trc:
ORA-00600: internal error code, arguments: [12333], [115], [32], [100], [], [], [], []
Tue Feb 22 13:26:53 2005
Errors in file /opt/oracle/admin/divaora/udump/divaora_ora_12000.trc:
ORA-07445: exception encountered: core dump [kghalf()+216] [SIGSEGV] [unknown code] [0x3FFFFFFFFF0] [] []
ORA-00600: internal error code, arguments: [12333], [115], [32], [100], [], [], [], []
Tue Feb 22 13:27:32 2005
Errors in file /opt/oracle/admin/divaora/udump/divaora_ora_12000.trc:
ORA-07445: exception encountered: core dump [kghalf()+216] [SIGSEGV] [unknown code] [0x3FFFFFFFFF0] [] []
ORA-07445: exception encountered: core dump [kghalf()+216] [SIGSEGV] [unknown code] [0x3FFFFFFFFF0] [] []
ORA-00600: internal error code, arguments: [12333], [115], [32], [100], [], [], [], []
Tue Feb 22 13:28:31 2005
Errors in file /opt/oracle/admin/divaora/udump/divaora_ora_12000.trc:
ORA-07445: exception encountered: core dump [kghalf()+216] [SIGSEGV] [unknown code] [0x3FFFFFFFFF0] [] []
ORA-07445: exception encountered: core dump [kghalf()+216] [SIGSEGV] [unknown code] [0x3FFFFFFFFF0] [] []
ORA-07445: exception encountered: core dump [kghalf()+216] [SIGSEGV] [unknown code] [0x3FFFFFFFFF0] [] []
ORA-00600: internal error code, arguments: [12333], [115], [32], [100], [], [], [], []


--------------------
Hamburg, Germany
Go to the top of the page
 
+Quote Post
burleson
post Feb 22 2005, 04:41 PM
Post #2


Advanced Member
***

Group: Members
Posts: 11,623
Joined: 26-January 04
Member No.: 13



smile.gif

The ORA-00600 means "call Oracle support".

You cannot do much with internal errors without them!


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post
Kenny MC
post Feb 23 2005, 03:36 AM
Post #3


Advanced Member
***

Group: Members
Posts: 36
Joined: 8-October 04
Member No.: 784



ok, thx i found it in metalink:


Doc ID: Note:291848.1
Subject: Clients Sharing Statement Handles Fails With ORA-00600 [12333]
Type: PROBLEM
Status: PUBLISHED

Content Type: TEXT/X-HTML
Creation Date: 24-NOV-2004
Last Revision Date: 24-NOV-2004

The information in this document applies to:
Oracle Server - Enterprise Edition - Version: 8.1.7 to 9.2.0.4
This problem can occur on any platform.
Errors
ORA-00600 "internal error code, arguments: [%s],[%s],[%s], [%s], [%s],
Symptoms
ORA-600[12333] in PRO/OCI clients sharing statement handles

Current cursor in the tracefile created by the ORA-00600 could show
Dumping cursor sharing failures: #
Cause
ORA-600 [12333] when sharing statement handles if the SQL raises a client side error

<Bug:2855665> ORA-600[12333] in PRO/OCI clients sharing statement handles
Fix
This is fixed in Oracle9i Client 9.2.0.5.0 or higher versions.
References
<BUG:2855665> - Ora-600[12333] Occur In Insert From Procobol Program
<NOTE:2855665.8> - Support Description of Bug 2855665


--------------------
Hamburg, Germany
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 24th October 2014 - 09:45 PM