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: Question for DBA: control files and processes

Re: Question for DBA: control files and processes

From: <zyman_at_my-deja.com>
Date: 2000/07/26
Message-ID: <8lnep4$2va$1@nnrp1.deja.com>#1/1

In article <397EE25E.A9C8856B_at_edcmail.cr.usgs.gov>,   Brian Peasland <peasland_at_edcmail.cr.usgs.gov> wrote:
> I had a similar problem with the control file and it had to deal with
 a
> bug with my Oracle version (8.0.4) on my platform (Solaris) and my
> current block size (16K). I'm not saying that this is your problem,
 but
> the only way to know for sure is to call Oracle Support. You did
> purchase a support contract didn't you?

I hope I have :). I just came here I believe that we have support. Any way thank You very much.
My db is 805 on Solaris.

>
> HTH,
> Brian
>
> zyman_at_my-deja.com wrote:
> >
> > Hello,
> > In my alert.log consist such "wonderfull" information:
> >
> > kccrsz: requested to expand controlfile section 9 by 660 record(s)
> > limited expansion to 191 records since maximum numrecs is 65535
> > kccrsz: expanded controlfile section 9 from 65344 to 65535 records
> >
> > the question is what is this "kccrsz" is ? Waht section it is
 talking
> > about??? which records????? why it (control file) have only 65535
> > records ? what are this records?
> > Ihaven't see any! information about such kind mesg in Oracle
> > documentation... :(
> >
> > Then lets' continue with alert.log:
> >
> > kccrsz: denied expansion of controlfile section 9 by 661 record(s)
> > the number of records is already at maximum value (65535)
> > krcpwnc: following controlfile record written over:
> > RECID #3350 Recno 62307 Record timestamp
> > 07/15/00 13:13:10
> > Thread=1 Seq#=3350 Link-Recid=3349
> > Low
> > scn: 0x0000.03e0f985
> > 07/14/00 18:16:02
> > Next
> > scn: 0x0000.03e0fa38
> > Thread 1 advanced to log sequence 68886
> > Current log# 3 seq# 68886 mem# 0:
> > /u03/oradata/oracle8/bpcd/redobpcd03.log
> > kccrsz: denied expansion of controlfile section 9 by 2026 record(s)
> > the number of records is already at maximum value (65535)
> > krcpwnc: following controlfile record written over:
> > RECID #3351 Recno 62308 Record timestamp
> > 07/15/00 17:44:30
> > Thread=1 Seq#=3351 Link-Recid=3350
> > Low
> > scn: 0x0000.03e0fa38
> > 07/15/00 13:13:10
> > Next
> > scn: 0x0000.03e12b4b
> >
> > COOLLL!!! I always become very exciting than I see such kind of
 friendly
> > information with a lot of documentation about everything but not
 about
> > this!!!
> > Does anb. knows how to translate this into English please?
> > Or the only information we can get from all this numbers and mesgs.
 is :
> > "I'm dieing, diying.... I'm already dead. Your database." ?
> >
> > Ok, The next "super" informative mesg. from alert log:
> >
> > LGWR: terminating instance due to error 204
> > Instance terminated by LGWR, pid = 848
> >
> > Database mounted in Exclusive Mode.
> > Completed: alter database mount
> > Mon Jul 24 10:04:25 2000
> > alter database open
> > Beginning crash recovery of 1 threads
> > Recovery of Online Redo Log: Thread 1 Group 3 Seq 72114 Reading mem
 0
> > Mem# 0 errs 0: /u03/oradata/oracle8/bpcd/redobpcd03.log
> > Crash recovery completed successfully
> > Mon Jul 24 10:04:25 2000
> > Rolling back half complete log switch of thread 1
> > LGWR: terminating instance due to error 204
> > Instance terminated by LGWR, pid = 17140
> >
> > Cool! there is the description of this error 204? Where should I
 look?
> > this is ora-. snp- what is this?
> >
> > Somtetimes I just "felt in love" in Oracle....
> >
> > THank You.
> > ANdy
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
> --
> ========================================
> Brian Peasland
> Raytheons Systems at
> USGS EROS Data Center
> These opinions are my own and do not
> necessarily reflect the opinions of my
> company!
> ========================================
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jul 26 2000 - 00:00:00 CDT

Original text of this message

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