| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Internal Oracle Error: Looking for others
Article-ID: <Note:43495.1> Alias: OLS:11786436.61 Circulation: PUBLISHED (EXTERNAL) Platform: GENERIC Generic issue Subject: CORE DUMP OR ORA 8103 ERRORS FROM VARIOUS SQL STATEMENTS Modified-Date: 10-JUN-1998 12:05:00 Document-Type: ALERT Content-Type: TEXT/PLAIN Impact: HIGH Component: RDBMS Keywords: ORA-8103;AND-EQUAL;DUMP;QUERY;SQL;STATEMENT
Bug: 424581 Core Dump or ORA 8103 Errors from various SQL statements
Versions Affected
This problem only affects Oracle Server release 7.3.2.3 on certain platforms.
Ports Affected
Port Oracle Bug Reference
~~~~ ~~~~~~~~~~~~~~~~~~~~
Alpha OSF / Digital Unix - **1
DG Aviion 88K Bug:425100
DG Aviion Intel Bug:425102
HPUX Bug:437448 **2
IBM RS/6000 AIX Bug:436670
NCR 3000 Unix (Svr4) Bug:425217
NEC UX/4800 UP/EWS 4800 Bug:425912
Sequent PTX Bug:425040
Sun Solaris 5.x Bug:425483
Sun Solaris Intel Bug:425519
UnixWare Bug:425981
All other ports have the relevant bug fixed in the 7.3.2.3 patch release.
**1: The patch for Bug:424581 is included in the 7.3.2.3 patch release
*BUT* Digital Unix "4.0" requires the patch for <Bug:424307>
**2: Note that the HPUX 7.3.2.3 patch release notes state that this bug is
fixed in the patch. This is incorrect - you need to apply fix 437448
after installing 7.3.2.3.
Description
Certain SQL statements may fail with either an Oracle Error ORA 8103 or a core dump in the function KCBGTCR. More specifically, the problem is most likely to occur in SQL statements using AND-EQUAL access paths.
Likelihood of Occurrence
It is highly likely this problem will be encountered on any of the Oracle ports listed above on 7.3.2.3, especially if AND-EQUAL access paths are used.
Possible Symptoms
Symptoms include:
ORA 7445 with 'kcbgtcr' in the argument list or stack trace.
ORA 8103 from AND-EQUAL type queries.
Incorrect query results from AND-EQUAL type queries.
Workaround / Patches
For some queries you may be able to disable AND-EQUAL steps in the execution plan. It is recommended that a patch be applied in all cases. You should first make sure 7.3.2.3 is fully installed then apply the relevant patch.
Contact Oracle Worldwide Support regarding availability of patches for the platforms listed above.
In article <372F9D4E.805DCB31_at_death.iinet.net.au>, Simmo <famine_at_death.iinet.net.au> wrote:
> Hi, > > Recently I have recieved the dreaded ORA-00600 error. To date Oracle > Support is some what at a loss at what is causing the error. > > The exact message: > ORA:00600: internal error code, arguments: [8103], [], [], [], [], [], > [], [] > > What was running at the time of the error: > Pro*C Program performing a select join between a static table and a > table that was created at runtime of the program. The bizare thing is > that the program continued successfully, and the database has not been > affected. > > So far I have performed a DB_VERIFY on the temp, data, index and > rollback segment tablespaces, and have come up with no inconcistencies. > I have also performed a full database export to see if there was any > data inconcistencies (none) > > If anybody has come across this error or has any ideas how I can try and > track it down a little further it would be much appreciated > > System: Solaris 2.6, Oracle 7.3.4 > -- > Regards > > Paul Simmons > -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your OwnReceived on Thu May 06 1999 - 04:50:34 CDT
 |
 |