| ORACLE error 3113 encountered [message #121231] |
Fri, 27 May 2005 01:49  |
8683
Messages: 2
Registered: May 2005
Location: india
|
Junior Member |
 
|
|
while importing dump file. i am getting this error.
IMP-00058: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
IMP-00000: Import terminated unsuccessfully
thanks in advance
[Updated on: Fri, 27 May 2005 02:10] Report message to a moderator |
|
|
|
| Re: ORACLE error 3113 encountered [message #121245 is a reply to message #121231] |
Fri, 27 May 2005 02:52  |
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
|
Senior Member |
|
|
From the reference:
"ORA-03113: end-of-file on communication channel
Cause: The connection between Client and Server process was broken.
Action: There was a communication error that requires further investigation. First, check for network problems and review the SQL*Net setup. Also, look in the alert.log file for any errors. Finally, test to see whether the server process is dead and whether a trace file was generated at failure time."
You didn't state the Oracle version you work with, but it appears on Metalink that there were some problems with 8.1.6. More info on Metalink.
|
|
|
|
|
|
| Re: ORACLE error 3113 encountered [message #121488 is a reply to message #121474] |
Mon, 30 May 2005 04:14 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
From Reference:
ORA-03113: end-of-file on communication channel
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.
In addition, this message could occur when any of the following statements/commands have been issued:
ALTER SYSTEM KILL SESSION ... IMMEDIATE
ALTER SYSTEM DISCONNECT SESSION ... IMMEDIATE
SHUTDOWN ABORT/IMMEDIATE/TRANSACTIONAL
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 Oracle Support Services.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
