ORA600 [2103] [0] [0] [1] [900]

From: Hatzistavrou John <John.Hatzistavrou.sema_at_mail.tellas.gr>
Date: Thu, 12 Jun 2003 03:22:02 -0700
Message-ID: <F001.005AFEE5.20030612024511@fatcity.com>

Dear All,

I have encountered the following message during ‘alter database backup controlfile to ‘……’ reuse after a hot backup.

We have opened a tar but still waiting. The strange think is that our Oracle versions range from 8.1.7.3 to 8.1.7.4 which according to what I have read resolved this problem. Another strange fact is that this happened concurrently on three clusters of Sun Solaris 8.

Attached please find extracts from alert and trace files

a) alert

hread 1 advanced to log sequence 41062

Thu Jun 12 02:33:43 2003

ARC1: Beginning to archive log# 1 seq# 41061

Thu Jun 12 02:33:43 2003

Current log# 2 seq# 41062 mem# 0: /be/prod/crm_oss/oracle/siebel/redo_logs/sbl_redo_2A.log

Current log# 2 seq# 41062 mem# 1: /be/prod/crm_oss/oracle/siebel/redo_logs/sbl_redo_2B.log

Thu Jun 12 02:33:44 2003

Completed: alter database backup controlfile to trace

Thu Jun 12 02:33:44 2003

alter database backup controlfile to '/hot_backup/siebelp1/control01.bak' reuse

Thu Jun 12 02:49:10 2003

Errors in file /be/prod/crm/siebel/oracle/siebelp1/admin/bdump/siebelp1_arc1_16563.trc:

ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [2103] [0] [0] [1] [900]

Thu Jun 12 02:49:12 2003

Errors in file /be/prod/crm/siebel/oracle/siebelp1/admin/bdump/siebelp1_arc1_16563.trc:

ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [2103] [0] [0] [1] [900]

Thu Jun 12 02:49:12 2003

ARC1: terminating instance due to error 600

Instance terminated by ARC1, pid = 16563

Thu Jun 12 02:49:47 2003

Starting ORACLE instance (normal)

b) trace

Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production

With the Partitioning option

JServer Release 8.1.7.4.0 - Production

ORACLE_HOME = /oracle_home/product/8.1.7

System name: SunOS

Node name: apps01-n01

Release: 5.8

Version: Generic_108528-21

Machine: sun4u

Instance name: siebelp1

Redo thread mounted by this instance: 1

Oracle process number: 21

Unix process pid: 16563, image: [EMAIL PROTECTED] (ARC1)

2003-06-12 02:49:08.500
SESSION ID:(137.947) 2003-06-12 02:49:08.463

TIMEOUT ON CONTROL FILE ENQUEUE mode=X, type=0, wait=1, eqt=900

SYSTEM STATE

System global information:

Number of NUMA instances : 1

processes: base 9010fe44, size 250, cleanup 90110864

allocation: free sessions(0) 90174724, free calls(0) 1

control alloc errors: 0 (process), 0 (session), 0 (call)

system statistics:

0 47997 logons cumulative

0 1052 logons current

0 1649040 opened cursors cumulative

0 41528 opened cursors current

0 1311839 user commits

0 7201 user rollbacks

0 30519546 user calls

0 22909587 recursive calls

0 1827715 recursive cpu usage

0 1553098488 session logical reads

0 0 session stored procedure space

0 6209740 CPU used when call started

0 143359357 CPU used by this session

8236 791247589 session connect time

8236 791247589 process last non-idle time

1020 304666384 session uga memory

Has anybody encountered such problem before? How can it be resolved? Kind Regards,

Hatzistavrou Yannis

Database Administrator

SchlumbergerSema

Phone ext. 478

Email: [EMAIL PROTECTED] Received on Thu Jun 12 2003 - 05:22:02 CDT