-
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.
-
Lead
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
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
-
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.
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|