ORA-01092: ORACLE instance terminated. Disconnection forced.

[satishpc]

hi friends,

when starting my sql plus, oracle gives an error message
ORA-01092: ORACLE instance terminated. Disconnection forced. When i tried starting the database from svrmgrl, it tries starting the database but gave an end-of-communication channel error message. what is the solution ?

satishpc

[pando]

is it NT or UNIX?

[satishpc]

oh, so sorry for that. should have specified earlier. it is oracle 8i enterprise edition running on NT

[pando]

you have to stop the database from services and start from services, then if the database is still not up try again from svrmgrl.
I think you are experiencing problems with SGA, are you using MTS?
Is it 8i?

[satishpc]

hi
i tried both throught the services and svrmgrl. but it doesnt work. when starting from svrmgrl, it give the end-of-communication file problem. will reducing the SGA help ? it is oracle 8i. i am not using MTS
waiting for ur reply

satish

[pando]

check your alert.log see if the instance was initiated at all. I said SGA because when I faced this problem in NT was because large pool was full but this was because I was using MTS and my large pool size were too small.
When I start the db from svrmgrl I didnt get the error message you got, instead it simply says oracle not available and when i tried to shut it down it just hangs even with abort option however these shutdown and process were still recorded in alert.log I fixed it by shutting the db from services and start from either svrmgrl or services.

I cant think of anything since our situation might be different

[mnicoras]

HI,
try to decrease the size of SGA and normally check alert.log in the background_dump_dest.

[satishpc]

hi,

here is my alert file. i think there might be a bad block. please interpret for me. this was working fine till yesterday.
i dont even know whether i got the right part. if anyone needs any more info, please feel free to ask. thanks .

satish

here it is

Tue Dec 12 20:02:10 2000
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Tue Dec 12 20:02:11 2000
alter database mount
***
Corrupt block relative dba: 0x00000003 file=0. blocknum=3.
Bad check value found during controlfile block read
Data in bad block - type:21. format:2. rdba:0x00000003
last change scn:0xffff.00001790 seq:0x1 flg:0x04
consistancy value in tail 0x17901501
check value in block header: 0x7b75, calculated check value: 0x2
spare1:0x0, spare2:0x0, spare2:0x0
LGWR: terminating instance due to error 227
Instance terminated by LGWR, pid = 275
Tue Dec 12 20:07:08 2000
Starting ORACLE instance (force)
License high water mark = 5
Tue Dec 12 20:12:08 2000
Instance terminated by USER, pid = 105
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes = 59
shared_pool_size = 5728640
large_pool_size = 614400
java_pool_size = 20971520
control_files = D:\Oracle\oradata\finsati\control01.ctl, D:\Oracle\oradata\finsati\control03.ctl, D:\Oracle\oradata\finsati\control02.ctl
db_block_buffers = 2048
db_block_size = 8192
compatible = 8.1.0
log_archive_dest_1 = LOCATION=D:\Oracle\Ora81\RDBMS
log_buffer = 32768
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
db_files = 1024
db_file_multiblock_read_count= 8
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
global_names = TRUE
distributed_transactions = 500
instance_name = finsati
service_names = finsati
mts_dispatchers = (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
open_links = 4
sort_area_size = 65536
sort_area_retained_size = 65536
db_name = finsati
open_cursors = 100
os_authent_prefix =
query_rewrite_enabled = TRUE
job_queue_processes = 4
job_queue_interval = 10
parallel_max_servers = 5
background_dump_dest = D:\Oracle\admin\finsati\bdump
user_dump_dest = D:\Oracle\admin\finsati\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
Tue Dec 12 20:12:12 2000
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...

[ligang]

It seems you need to recreate the corrupted control file.

[satishpc]

hi,

i am a bit new to this field. in fact i am just a makeshift DBA. can anyone please tell me how do i solve this problem. if i need to recreate this control file, how do i do it. can anyone give me a detailed explanation. i would surely appreciate any help.

satish