There're many articles on Metalink discussing ORA-600 [kcbgtcr_4]. Most of them don't provide immediate workarounds. But according to http://metalink.oracle.com/metalink/plsql/ml2_documents.showBUG?p_id=841636, the combination of _use_ism in Oracle which is true by default and a small shmsys:shminfo_shmmax in /etc/system may cause memory corruption. So we temporarily set _use_ism = false and bounced the database. Aaron restarted the job and is monitoring it. So far so good. Before we bounced the database, we even got that error by select count(*) from eis.descriptions in sqlplus.

[Tech details: _use_ism uses Solaris intimate shared memory so all Oracle processes can use the same virtual-to-physical address translation table, thus saving memory. shmsys:shminfo_shmmax sets the maximum shared memory segment size. Beginning with 8.1.6, Oracle recommends setting it to the theoretical maximum, 4 billion on 32-bit OS. But on mcr this is only set to 268435456. The consequence is that `/usr/proc/bin/pmap -x [wprdOracleProcess] | grep shmid` shows too many shared memory segments instead of one. This not only slightly slows down instance startup and process creation, but triggers bugs like this]

Another change we made, which is unlikely to be relevant, is alter tablespace temp temporary. It's been permanent since a very long time ago.

Yong

-----Original Message-----
Sent: Monday, March 17, 2003 10:51 PM
Subject: ERROR - Job: wfill_acctsum_interim.db



SQL*Plus: Release 8.1.7.0.0 - Production on Mon Mar 17 22:08:12 2003

(c) Copyright 2000 Oracle Corporation.  All rights reserved.

SQL> Connected.
SQL> 
DATE-TIME: 17-MAR-03 22:08:12

'fill_acctsum_interim ...'

Table truncated.

Elapsed: 00:00:00.46

Table altered.

Elapsed: 00:00:00.02
declare
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcbgtcr_4], [116597], [116762], [1049601], [1], [], [], []
ORA-06512: at line 47


Disconnected from Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production With the Partitioning option JServer Release 8.1.7.4.0 - Production

CHECKING /oracle/logs/whsemgr/wfill_acctsum_interim.db.log.031703.2208
FOR ADDITIONAL ERRORS


CTM_FINAL_CHECK_V2 FOUND ERROR: ORA-