Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Linux--Oracle Control File Errors
Hi,
I'm doing some stress testing, experimental tuning specifically for INSERTs, and am getting control file errors in the alert log (below), on every checkpoint/log switch.
The error does not affect anything in the running instance. It does not affect startup and shutdown either. It just makes an entry in the alert log, with a trace file.
I'm probably pushing the envelope trying to use a 16K block size, but it took it OK. However, it's after I recreated with 16K block size that these errors started.
So, I'm just wondering if anyone is seeing this error message also, and maybe if there is something for it.
This would be 8.0.5 pre-release for Linux. I'm running RH 5.1/Linux 2.0.34 with SMP turned on (2 cpus).
Thanks!
Alan.
PS: Stress test results -> 100,000 records/min. is the best yet.
Instance Setup (from alert log):
System parameters with non-default values:
processes = 50 shared_pool_size = 3500000 control_files =
/opt/oracle/database/a001/ctrl/disk01/control1.ctl
db_block_buffers = 10000 db_block_size = 16384 db_writer_processes = 4 log_archive_start = TRUE log_archive_dest = /opt/oracle/database/a001/arch/disk01 log_archive_format = T%TS%S.ARC log_buffer = 5242880 log_checkpoint_interval = 99999 db_files = 80
log_checkpoints_to_alert = TRUE rollback_segments = rbs01, rbs02, rbs03, rbs04 sequence_cache_entries = 10 sequence_cache_hash_buckets= 10 global_names = TRUE db_name = a001 parallel_max_servers = 5 background_dump_dest = /opt/oracle/admin/a001/bdump user_dump_dest = /opt/oracle/admin/a001/udump max_dump_file_size = 10240 core_dump_dest = /opt/oracle/admin/a001/cdump
Example error from alert log:
Beginning log switch checkpoint up to RBA [0x2f1.2.10], SCN:
0x0000.00038b45
Thread 1 advanced to log sequence 753
Current log# 1 seq# 753 mem# 0:
/opt/oracle/database/a001/redoA/disk01/redoA_01.rdo
Current log# 1 seq# 753 mem# 1:
/opt/oracle/database/a001/redoB/disk01/redoB_01.rdo
Sat Nov 14 20:44:25 1998
Completed checkpoint up to RBA [0x2f1.2.10], SCN: 0x0000.00038b45
Sat Nov 14 20:44:52 1998
Errors in file /opt/oracle/admin/a001/bdump/lgwr_a001_5732.trc:
ORA-00202: controlfile:
'/opt/oracle/database/a001/ctrl/disk01/control1.ctl'
ORA-27044: unable to write the header block of file
Linux Error: 14: Bad address
Additional information: 4
Sat Nov 14 20:44:52 1998
kccexpd: controlfile resize from 62 to 64 block(s) denied by OS
krcpwnc: following controlfile record written over:
RECID #299 Recno 299 Record timestamp
11/14/98 15:44:56
Thread=1 Seq#=299 Link-Recid=298
Low
scn: 0x0000.00003721
11/14/98 15:44:55
Next
scn: 0x0000.0000372f
Beginning log switch checkpoint up to RBA [0x2f2.2.10], SCN:
0x0000.00038c9c
Thread 1 advanced to log sequence 754
Current log# 2 seq# 754 mem# 0:
/opt/oracle/database/a001/redoA/disk01/redoA_02.rdo
Current log# 2 seq# 754 mem# 1:
/opt/oracle/database/a001/redoB/disk01/redoB_02.rdo
Sat Nov 14 20:44:57 1998
Completed checkpoint up to RBA [0x2f2.2.10], SCN: 0x0000.00038c9c
TRACE FILE:
Dump file /opt/oracle/admin/a001/bdump/lgwr_a001_5732.trc
Oracle8 Release 8.0.5.0.0 - Production
PL/SQL Release 8.0.5.0.0 - Production
ORACLE_HOME = /opt/oracle/product/8.0.5
System name: Linux
Node name: darkness.alangano.com
Release: 2.0.34 Version: #11 Sun Sep 27 01:32:51 CDT 1998 Machine: i686
--
Alan Gano
http://home.att.net/~alangano/index.html
Received on Sat Nov 14 1998 - 23:11:35 CST