ora-03113 end of on communication

[Minesh]

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

[marist89]

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

[Minesh]

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

[stmontgo]

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

steve

[Minesh]

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

[jmodic]

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.

[Minesh]

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