ORA-3113 in database startup(open) URGENT ?

[mahoori]

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.

[padmam]

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

[julian]

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.

[mahoori]

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.

[julian]

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).

[mahoori]

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.

[deswal_aja]

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

[ligang]

Can you startup DB by using NT Service?

[csvenkata]

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

[csvenkata]

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