Details of the error

[sureshgane]

CKPT: terminating instance due to error 1110
Instance terminated by CKPT, pid = 293
Dump file o:\oracle816\admin\test\bdump\testALRT.LOG
Sun Nov 12 19:32:28 2000
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows NT Version 4.0 Service Pack 6, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 200
shared_pool_size = 52428800
large_pool_size = 614400
java_pool_size = 20971520
control_files = o:\oracle816\oradata\test\control01.ctl, o:\oracle816\oradata\test\control02.ctl, o:\oracle816\oradata\test\control03.ctl
db_block_buffers = 19200
db_block_size = 8192
compatible = 8.1.0
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
rollback_segments = RBS0, RBS2, RBS1, RBS3, RBS4, RBS5, RBS6
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = test
service_names = test
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
open_links = 4
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = test
open_cursors = 100
os_authent_prefix =
job_queue_processes = 4
job_queue_interval = 10
parallel_max_servers = 5
background_dump_dest = o:\oracle816\admin\test\bdump
user_dump_dest = o:\oracle816\admin\test\udump
max_dump_file_size = 10240
oracle_trace_collection_name=
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
SNP0 started with pid=8
SNP1 started with pid=9
SNP2 started with pid=10
SNP3 started with pid=11

[TerryD]

This doesn't really say much - just that CKPT failed due to some error - 1110 - which means look in another file for the error.

Are there any other log files generated.

Terry

[sureshgane]

No.Only this error is appearing in log files as well as in trace files

[TerryD]

I've just seen your other thread - you might want to delete this one and stick with the other one since it gives more info.