ORA-3113 in database startup(open) URGENT ?

Hi all.
OS==> NT 4.0 SP6
DB==> Oracle 8.1.6.0.0 EE
This server was running for a year.
A month ego we switch to MTS and all was ok until today.
Today because SHUTDOWN IMMEDIATE was very long I do SHUTDOWN ABORT (with down oracle service ).
After this action :
connect as internal to sql*plus :
SQL>STARTUP NOMOUNT;
OK.
BUT :
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel


SQL>
-----------------------------------------------------
Why ORA-03113 ocuured?any suggestion?
We have not METALINK support.
I search this error in this forum and any suggestion was unsuccesfull.
I reboot NT server and drop MTS parameter from init.ora , but this error still exists.
If anybody access to metalink and knows solution for this problem(with search in metalink) please help me.

Sorry for my english!!!
Best Regards.

Hi, 2nd Sep 2001 18:25 hrs chennai

I too have faced simillar problem and solved it but now i dont remember the solution.

Before going in to that i would like to Know

1)Whether you are successfull connecting via SVRMGRL ?

2)Do You have multiple instances running in your system ?

To Problem
========

Oracle Docs says:

Cause: An unexpected end-of-file was processed on the communication channel. The problem could not be
handled by the Net8, two task, software. This message could occur if the shadow two-task process associated
with a Net8 connect has terminated abnormally, or if there is a physical failure of the interprocess communication vehicle, that is, the network or server machine went down.

Action: If this message occurs during a connection attempt, check the setup files for the appropriate Net8 driver and confirm Net8 software is correctly installed on the server. If the message occurs after a connection is well established, and the error is not due to a physical failure, check if a trace file was generated on the server at failure time. Existence of a trace file may suggest an Oracle internal error that requires the assistance of customer support.

Awaiting your reply to proceed further.

Cheers

Padmam

Did you log in as administrator? If not, then you must explicitly name the owner of the NT services.

Do the following:

1. Open the "Services" dialog box from the NT Control Panel.

2. Click on the OracleService then click the "Startup..." button.

3. Change the "Log on as:" information to "This Account: " plus the appropriate password where username> = the person who created the services.

4. Repeat steps 2 & 3 for the OracleStart service.

In some cases the ORA-3113 occurs even if you are logged on as the NT administrator. In this case = Administrator.

1) I connect to SVRMGRL but same error occured.
2) I have one instance on this machine.
3) I log on NT with Administrator.
4) after mount database :
select * from v$recover_file returns no rows.
I restored backup and recover database .
But I can't find solution for this error.

Best Regards.

Quote:

---

But I can't find solution for this error.
[/B]

---

Try to do the following:

1. SHUTDOWN IMMEDIATE
2. STOP all Oracle services (from the Control Panel)
3. START the services again
4 SVRMGRL> SET ORACLE_SID=NAME
5. SVRMGRL> STARTUP PFILE=...

Tell me what ORA Error you get now (if you get any).

Hello julian.
First of all , this server is production server , and I have cold backup of one day ego , I restored backup in another machin and it is ok.
But in main production server still this error exists.
I do 5 step that you say, but ORA-3113 after mount and when open database occured.
SVRMGR> startup pfile=...
ORACLE instance started.
Total System Global Area 178218252 bytes
Fixed Size 70924 bytes
Variable Size 116629504 bytes
Database Buffers 61440000 bytes
Redo Buffers 77824 bytes
Database mounted.

ERROR at line 1:
ORA-03113: end-of-file on communication channel.

and then disconnect from oracle.

Sorry for my english!!!
Best regards.

my experience with this error says that
it's most likely due to underlyng network problem
provided nothing changed at net8 level during the period
under observation.

ajay

Can you startup DB by using NT Service?

Shutdown the NT Server and restart and try starting the database. It believe it will work.

Sometimes shutdown immediate will not shutdown the db. It will take a long time than expected. Use shutdown transactional. Pls don't use shutdown abort. When u use shutdown abort, startup the db and shutdown using either shutdown transactional or shutdown immediate.

These are documented(Ref to Admin Guide)

From Dos prompt
start the listener using lsnrctl start

c:\> set ORACLE_SID=

c:\>svrmgrl
svrmgrl>connect internal
svrmgrl>startup


This will surely startup the database.

Get back to me if u need more clarifications.
Venkat

Quote:

---

Originally posted by csvenkata
Shutdown the NT Server and restart and try starting the database. It believe it will work.

---

I also think that this should work. And that's what I suggested him but he say it doesn't help.

Now, do that:

1. Open the "Services" dialog box from the NT Control Panel.

2. Click on the OracleService then click the "Startup..." button.

3. Change the "Log on as:" information to "This Account: "
plus the appropriate password where = the person who created
the services.

4. Repeat steps 2 & 3 for the OracleStart service.

5. Try again to startup the DB

Tell me: have you rebooted the server during the last few days and do you find ORA-00600 in the trace files.

Dear Freinds,

Don't use SHUTDOWN IMMEDIATE on Oracle 8.1.6. If you shoutdown with IMMEDIATE option sometimes datafile will corrupt. This is a Bug in Oracle 8.1.6. We have financial running under Oracle 8.1.6. Last month what happened know our DBA shutdown our database with IMMEDIATE option. Its takes along time to shutdown. Finally one datafile was corrupted we could 't startup the Database again. some Java classes having problem. So please don't use IMMEDIATE option in Oracle 8.1.6.

Thanks

Ram

Check if all the Oracle services are running. If yes try stopping all the services and then restart all the services.

This might help

Quote:

---

Originally posted by Ram
Don't use SHUTDOWN IMMEDIATE on Oracle 8.1.6. If you shoutdown with IMMEDIATE option sometimes datafile will corrupt. This is a Bug in Oracle 8.1.6.

---

One of the many bugs in 8.1.6 :-)

Refer the metalink on the ORA-3113. This can occour on a wide range of scenarios. Oracle has a note on this error.

Sam

I had this problem before. The solution for my case was:

1. set the sid.
2. net stop oracleservicesid.
3. using oradim to drop and recreate oracleservicesid.
4.startup database.

It appears as if it is mounted but having trouble opening. Check the alert log and see if there is an error relating to the startup. Post the information on the startup from the alert so we can review.

Quote:

---

Originally posted by lgaorcl
I had this problem before. The solution for my case was:

1. set the sid.
2. net stop oracleservicesid.
3. using oradim to drop and recreate oracleservicesid.
4.startup database.

---

I have also had it and your solution is the right one. I think it even worked without 3.