RE: ORA600 [2103] [0] [0] [1] [900]

From: Hatzistavrou John <John.Hatzistavrou.sema_at_mail.tellas.gr>
Date: Fri, 13 Jun 2003 00:14:27 -0700
Message-ID: <F001.005B0ECB.20030612234418@fatcity.com>

It is a local filesystem

Kind Regards,

<span

lang=EN-GB style='font-size:12.0pt;color:navy'>

Hatzistavrou Yannis

<span

lang=EN-US style='font-size:10.0pt;font-family:Tahoma'>-----Original Message-----
From: Hemant K Chitale
[mailto:[EMAIL PROTECTED]
Sent: Thursday,
June 12, 2003 7:15
PM
To: Multiple recipients of list
ORACLE-L
Subject: Re: ORA600 [2103] [0] [0]
[1] [900]


1. Try writing the backup to another location alter database backup controlfile to '/tmp/cntrlfilebk.dbf'

2. Try it again with the reuse clause

3. Is the file system '/hot_backup/siebelp1' local or NFS mounted ?

Hemant

At 02:45 AM 12-06-03 -0800, you wrote:

Dear All,

I <span

style='font-size:10.0pt'>have <span
style='font-size:10.0pt'>encountered <span
style='font-size:10.0pt'>the <span style='font-size:

10.0pt'>following message
during <span

style='font-size:10.0pt'>alter <span
style='font-size:10.0pt'>database <span
style='font-size:10.0pt'>backup <span
style='font-size:10.0pt'>controlfile <span
style='font-size:10.0pt'>to <span style='font-size:

10.0pt'>&& reuse after a
hot backup.

We <span

style='font-size:10.0pt'>have <span
style='font-size:10.0pt'>opened <span
style='font-size:10.0pt'>a <span style='font-size:

10.0pt'>tar but
still <span

style='font-size:10.0pt'>waiting. <span
style='font-size:10.0pt'>The <span style='font-size:
10.0pt'>strange think

is <span

style='font-size:10.0pt'>that <span
style='font-size:10.0pt'>our <span style='font-size:
10.0pt'>Oracle versions

range <span

style='font-size:10.0pt'>from <span
style='font-size:10.0pt'>8.1.7.3 <span
style='font-size:10.0pt'>to <span style='font-size:

10.0pt'>8.1.7.4 which
according to <span

style='font-size:10.0pt'>what <span
style='font-size:10.0pt'>I <span style='font-size:
10.0pt'>have read

resolved this <span

style='font-size:10.0pt'>problem. <span
style='font-size:10.0pt'>Another <span
style='font-size:10.0pt'>strange <span
style='font-size:10.0pt'>fact <span
style='font-size:10.0pt'>is <span style='font-size:

10.0pt'>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: <a
href="mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]

<span

style='font-size:12.0pt'>Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : <a href="http://hkchital.tripod.com/" eudora=autourl>http://hkchital.tripod.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Jun 13 2003 - 02:14:27 CDT