Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-00202: controlfile: '/var/opt/oracle/oradata/orcl/control03.ctl'

Re: ORA-00202: controlfile: '/var/opt/oracle/oradata/orcl/control03.ctl'

From: chan01 <chandra_2000_us_at_yahoo.com>
Date: 19 Apr 2004 19:16:15 -0700
Message-ID: <480cb9d4.0404191816.78ee001d@posting.google.com>


Michel,
Errors in file /ora01/oracle/admin/orcl/bdump/orcl1_ckpt_16649.trc This trace file has been deleted by dbca, so i re-ran dbca and it created this file:



/ora01/oracle/admin/orcl1/bdump/orcl11_ckpt_17074.trc Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
ORACLE_HOME = /ora01/oracle/product/9.2.0
System name:	Linux
Node name:	rac1
Release:	2.4.20-18.10.1
Version:	#1 Tue Jul 29 13:24:24 PDT 2003
Machine:	i686

Instance name: orcl11
Redo thread mounted by this instance: 0 <none> Oracle process number: 8
Unix process pid: 17074,

Thanks

"Michel Cadot" <micadot{at}altern{dot}org> wrote in message news:<408365f6$0$21152$626a14ce_at_news.free.fr>...
> "chan01" <chandra_2000_us_at_yahoo.com> a écrit dans le message de
> news:480cb9d4.0404181454.186dcaf4_at_posting.google.com...
> > I tryed to create RAC db manually but still I endup with same problem.
> > I am seeing /var/opt/oracle/oradata/orcl/control01.ctl, cxxx02.ctl,
> > cxxx03.ctl files created during this process. So I did not suspect
> > that this was happned due to permissions or incorrect path. I would
> > appreciate your help.
> >
> > My alert.log file is
> > ===============================================================
> <snip>
> > Sun Apr 11 12:10:08 2004
> > Errors in file /ora01/oracle/admin/orcl/bdump/orcl1_ckpt_16649.trc:
> > ORA-00206: error in writing (block 3, # blocks 1) of controlfile
> > ORA-00202: controlfile: '/var/opt/oracle/oradata/orcl/control03.ctl'
> > ORA-27072: skgfdisp: I/O error
> > Linux Error: 5: Input/output error
> > Additional information: 2
> > ORA-00206: error in writing (block 3, # blocks 1) of controlfile
> > ORA-00202: controlfile: '/var/opt/oracle/oradata/orcl/control01.ctl'
> > ORA-27072: skgfdisp: I/O error
> > Linux Error: 5: Input/output error
> > Additional information: 2
> > Sun Apr 11 12:10:08 2004
> > Errors in file /ora01/oracle/admin/orcl/bdump/orcl1_ckpt_16649.trc:
> > ORA-00221: error on write to controlfile
> > ORA-00206: error in writing (block 3, # blocks 1) of controlfile
> > ORA-00202: controlfile: '/var/opt/oracle/oradata/orcl/control03.ctl'
> > ORA-27072: skgfdisp: I/O error
> > Linux Error: 5: Input/output error
> > Additional information: 2
> > ORA-00206: error in writing (block 3, # blocks 1) of controlfile
> > ORA-00202: controlfile: '/var/opt/oracle/oradata/orcl/control01.ctl'
> > ORA-27072: skgfdisp: I/O error
> > Linux Error: 5: Input/output error
> > Additional information: 2
> > Sun Apr 11 12:10:08 2004
> > CKPT: terminating instance due to error 221
> > Sun Apr 11 12:10:09 2004
> > System state dump is made for local instance
> > Sun Apr 11 12:10:09 2004
> > Trace dumping is performing id=[cdmp_20040411121009]
> > Sun Apr 11 12:10:13 2004
> > Instance terminated by CKPT, pid = 16649
> >
>
> So you have I/O errors on directory "/ora01/oracle/admin/orcl".
> Is there engouh space in it?
> What is in the trace file "/ora01/oracle/admin/orcl/bdump/orcl1_ckpt_16649.trc"?
> I see all your other files are in "/var/opt/oracle/oradata/orcl/orcl" with 2 orcl
> and your control files in "/var/opt/oracle/oradata/orcl" with only 1 orcl, is this
> what you really want?
>
> Regards
> Michel Cadot
Received on Mon Apr 19 2004 - 21:16:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US