Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-00202: controlfile: '/var/opt/oracle/oradata/orcl/control03.ctl'
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:
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
"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