Topic: Database Administration >> ORA-00600: internal error code, arguments: [19004], [], [], [], [], [], [], []
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: ORA-00600: internal error code, arguments: [19004], [], [], [], [], [], [], [] |
| Neeraj |
Posted: Nov 24, 2007 02:57:41 AM |
Total Post: 243
Joined: Jan, 2007
|
HI,
I GET THIS ERROR WHEN MY ONE OF PROCEES ON ON A PARTICULAR SQL QUERY , WHICH USES 4 TABLES OF MY DATABASE,
TELL WHY ITS STCKING ON THIS PROCEES
HOW TO RESOVE IT.
|
|
|
 Ratnaker |
| Posted: Nov 26, 2007 02:31:29 AM |  |
|
Total Post: 138
Joined: Apr, 2007
|
This is the generic internal error number for Oracle program exceptions. This indicates that a process has encountered an exceptional condition
|
|
|
|
|
| Neeraj |
| Posted: Nov 26, 2007 03:38:12 AM | |
|
Total Post: 243
Joined: Jan, 2007
|
yes , i know but tell me how to resolve it & what can be the resons of this bug
|
|
|
|
|
| MOH_DBA |
| Posted: Nov 26, 2007 12:45:28 PM | |
|
Total Post: 133
Joined: Nov, 2007
|
There is abook that describe these kind of error and how to avoid them,
i copy and paste what it did say.
I’d like to close this section with a discussion about those otherkinds of trace files—the oneswe did not expect that were generated as a result of an ORA-00600 or some other internalerror. Is there anything we can do with them?The short answer is that in general, they are not for you and me. They are useful to OracleSupport. However, they can be useful when we are filing an iTAR with Oracle Support. Thatpoint is crucial: if you are getting internal errors, then the only way they will ever be correctedis if you file an iTAR. If you just ignore them, they will not get fixed by themselves, except byaccident.For example, in Oracle 10gRelease 1, if you create the following table and run the query,you may well get an internal error (or not—it was filed as a bug and is corrected in later patchreleases
---------
Now, you are the DBA and all of a sudden this trace file pops up in the user dump destina-tion. Or you are the developer and your application raises an ORA-00600 error and you wantto find out what happened. There is a lot of information in that trace file (some 35,000 linesmore in fact), but in general it is not useful to you and me. We would generally just compressthe trace file and upload it as part of our iTAR processing.However, there is some information in there that can help you track down the “who,”“what,” and “where” of the error, and also help you find out if the problem is something othershave experienced—many times, the “why”—on http://metalink.oracle.com. A quick inspec-tion of the very top of the trace file will provide you with some useful information
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 816 |
| Mohammed Taj | 746 |
| Jayanta Sur | 479 |
| positive fanatic | 418 |
| Vigyan Kaushik | 386 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 250 |
| Ramesh Jois | 245 |
| neeraj sharma | 243 |
| Bishal Khetan | 207 |
|
|
