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.
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
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
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.
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.
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.
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
Reply With Quote
Bookmarks