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: dias <ydias_at_hotmail.com>
Date: 19 Apr 2004 14:32:52 -0700
Message-ID: <55a68b47.0404191332.65baedce@posting.google.com>


Hi,

Can you check also the os messages ?

Creating your db with 3 controlfiles is not the problem, in your first post, only the 3trd controlfile seems to have a problem. It's not the case.

Dias

chandra_2000_us_at_yahoo.com (chan01) wrote in message news:<480cb9d4.0404190505.704fb076_at_posting.google.com>...
> 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?
> >
> Michel,
> - I have enough space in /ora01/oracle/admin/orcl volume.
> - I created all datafiles are in "/var/opt/oracle/oradata/orcl/orcl"
> directory(ocfs)
> - control files are in "/var/opt/oracle/oradata/orcl" dirctory (ocfs)
> - I am going to send my trace file this evening. ( After I reach home)
>
> Dias,
> - I did not tryed create RAC DB without 3rd control file. Do you think
> this could be the problem?
>
> Thanks for your help.
>
> "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 - 16:32:52 CDT

Original text of this message

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