ora-03113 end of on communication

Hi Guys,


I am getting ora-03113 error while starting database using svrmgrl
and i am getting ORA-01092: ORACLE instance terminated. Disconnection forced error on sql*plus

please trough some valuable input.

Thanks

I would bet you need to look at your kernal parameters.

My environment is windows 2000 and i am running on my local pc. I you can guide me where do i have to look for kernal parameters?


Thanks

where is the alert log? Can Oracle write to the
bdump dest? Do the permissions/space allow this
on your filesystem?

steve

istributed_transactions = 10
instance_name = des85
service_names = des85
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = des85
open_cursors = 400
ifile = C:\oracle\admin\des85\pfile\initdes85.ora
os_authent_prefix =
optimizer_mode = RULE
job_queue_processes = 1
job_queue_interval = 60
parallel_max_servers = 5
background_dump_dest = C:\oracle\admin\des85\bdump
user_dump_dest = C:\oracle\admin\des85\udump
max_dump_file_size = 10240
oracle_trace_collection_name=
PMON started with pid=2
DBW0 started with pid=4
RECO started with pid=8
My trace log file

LGWR started with pid=5
SNP0 started with pid=3
CKPT started with pid=6
SMON started with pid=7
Thu Oct 24 12:46:35 2002
alter database mount exclusive
***
Corrupt block relative dba: 0x00000003 (file 0, block 3)
Fractured block found during controlfile block read
Data in bad block -
type: 21 format: 2 rdba: 0x00000003
last change scn: 0xefff.0000069c seq: 0x1 flg: 0x04
consistency value in tail: 0x069c0501
check value in block header: 0xabfe, computed block checksum: 0x0
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
LGWR: terminating instance due to error 227
Thu Oct 24 12:47:03 2002
Instance terminated by LGWR, pid = 1148


Please help or any suggestion

Your controlfile is corrupt.

If you have multiplexed controlfiles try starting your instance by using only one of them at a time (try each one of them), hoping that not all of them are corrupt.

If that doesn't work, try recreating your controlfile.

If that doesn't work, call Oracle Support.

Thanks for reply

following are my controle file location. can i use second control file to start database ? if yes the how please guide me for that or suggestion cause i am relatively very new to recovery kind a thing.

processes = 150
shared_pool_size = 7637094
large_pool_size = 614400
java_pool_size = 32768
control_files = C:\oracle\oradata\des85\control01.ctl, C:\oracle\oradata\des85\control02.ctl, C:\oracle\oradata\des85\control03.ctl
db_block_buffers = 2796


Again thanks for reply