RE: ORA600 [2103] [0] [0] [1] [900] -- Wrapping up

Dear All,

ThAnks for all your comments and advise. We have found what was the cause of this. Just before we put tablespaces in hot backup mode we mount some nfs drives. Then having placed the tbs in hot backup we use a cp command to copy the *.dbf files to nfs. Also the copy of the controlfile binary is also put to nfs. As you might have guessed the NFS drive caused the error due to some delays.

Kind Regards,

Hatzistavrou Yannis

-----Original Message-----
Sent: Sunday, June 15, 2003 7:19 PM
To: Multiple recipients of list ORACLE-L

So, did you get the same error when writing the backup to /tmp as well ? And also if you delete the previous backup and create a backup without the REUSE ? If the problem is really a Control File Enqueue timeout, is the server really that busy ?
How about trying the controlfile backup at a time when the server is "less busy" --- to
verify the "busy"ness being the cause of the Control File Enqueue

Hemant

At 11:44 PM 12-06-03 -0800, you wrote:

>It is a local filesystem
>
>
>
>Kind Regards,
>
>
>
>Hatzistavrou Yannis
>
>
>-----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 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:
><mailto:[EMAIL PROTECTED]>[EMAIL PROTECTED]
>
>Hemant K Chitale
>Oracle 9i Database Administrator Certified Professional
>My personal web site is : 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).

Hemant K Chitale
Oracle 9i Database Administrator Certified Professional My personal web site is : 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hatzistavrou John
  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).