Re: Question for DBA: control files and processes

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?

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!
========================================