If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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 ?

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?

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

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.

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 .

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.