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