A SQL statement fails darkly

From: Alexei Ustyuzhaninov <aiu_at_qms.e-burg.ru>
Date: 30 Oct 2001 01:39:57 -0800
Message-ID: <c42761b7.0110300139.73d5c46b@posting.google.com>

Hi!

I have two almost identical 2xPIII servers with 512M RAM and hardware RAID. Both run linux 2.4.9 and Oracle 8.1.7.0.0 with glibc patch. The databases on the servers are restored from the same dump.

But, despite of this identity, there is a SQL statement which runs perfectly on one server and fails on the other one. The error message accompanied the failure is:
ORA-03113: end-of-file on communication channel The statement is executed on the server, so it it's not a network error.

In the alert log the failure is registered as follows: Tue Oct 30 10:07:30 2001
Errors in file /u01/app/oracle/admin/main/udump/ora_984.trc: ORA-00600: internal error code, arguments: [sdbput_2], [64716], [], [], [], [], [], []

The trace file is also quite terse:
/u01/app/oracle/admin/main/udump/ora_984.trc Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option
JServer Release 8.1.7.0.0 - Production
ORACLE_HOME = /u01/app/oracle/product/8.1.7 System name: Linux

Node name:      main
Release:        2.4.9
Version:        #4 SMP Mon Oct 29 18:04:42 YEKT 2001
Machine:        i686

Instance name: ORCL
Redo thread mounted by this instance: 1
Oracle process number: 10
Unix process pid: 984, image: oracle_at_main (TNS V1-V3)

• SESSION ID:(7.9) 2001-10-30 10:07:30.676
• 2001-10-30 10:07:30.676 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [sdbput_2], [64716], [], [], [], [], [], [] Current SQL statement for this session: SELECT * FROM pricedisc WHERE rownumber NOT IN (SELECT MIN(rownumber) FROM pricedisc GROUP BY itemrelation) ----- Call Stack Trace -----

So could someone share any ideas about the situation?

Thanks,
Alexei Received on Tue Oct 30 2001 - 03:39:57 CST