| ORA-03113: end-of-file on communication channel .. [message #122329] |
Sun, 05 June 2005 23:12  |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi
My question is as below
As i am doing export of my full database i am getting this below error .
EXP-00008: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
EXP-00000: Export terminated unsuccessfully
can any one tell me what should i do to get my export dmp.
thanks
From :- Mishra Sunilkumar Vishwanath.
[Updated on: Sun, 05 June 2005 23:14] Report message to a moderator |
|
|
|
| Re: ORA-03113: end-of-file on communication channel .. [message #122341 is a reply to message #122329] |
Mon, 06 June 2005 00:44  |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
You must be running this export command on a remote machine.
Try running this on the server itself, or on any client machine which doesn't face any network glitch like connection timeout, max conbnection time etc while connecting to database server.
Detailed error description:
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.
|
|
|
|
| Re: ORA-03113: end-of-file on communication channel .. [message #122365 is a reply to message #122329] |
Mon, 06 June 2005 03:26 |
AshokB
Messages: 3
Registered: April 2005
Location: INDIA
|
Junior Member |
|
|
Sunil,
I agree with the girish explanation about this. Mean while check your connectivity string to the server. Can u pls send your export script. There is no such rule like we have to take export on server,many times we are doing export from client system .
Thanks&Regards,
- Ashok
|
|
|
|
| Re: ORA-03113: end-of-file on communication channel .. [message #122495 is a reply to message #122365] |
Mon, 06 June 2005 14:36 |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi,
I dont know what to do ....
Note :- [1]My database is running fine there is no problem user are connecting to the database from remote location and they are working
[2] Even i am connecting to the database remotly using putty (s/w) so i get the desktop of my oracle server and i am doing export there (i.e on server)
[3] I am not using any script for export i am trying to do export from command line.
[4] I am able to do export of user but not of entire database.
[5] I dont know that.... is it problem of space on the server where i am exporting the entire database.
you can see what i am doing as below ...
===========================================================
Username: sys as sysdba
Password:
Connected to: Oracle Database 10g Release 10.1.0.2.0 - Production
Enter array fetch buffer size: 4096 >
(1)E(ntire database), (2)U(sers), or (3)T(ables): (2)U > E
Export grants (yes/no): yes > y
Export table data (yes/no): yes > y
Compress extents (yes/no): yes > n
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
EXP-00008: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
EXP-00000: Export terminated unsuccessfully
============================================================
Now tell me what should i do ... to export my complete database.
Thank you
From:- Sunilkumar Vishwanath Mishra
|
|
|
|
|
|
| Re: ORA-03113: end-of-file on communication channel .. [message #122510 is a reply to message #122496] |
Mon, 06 June 2005 20:45 |
sunil_v_mishra
Messages: 506
Registered: March 2005
|
Senior Member |
|
|
hi
Maheshji & girish .... the below is my alert log file content which is generated while i was trying to do export.
==============================================================
content of alert_sid.log
=====================
Mon Jun 6 20:21:49 2005
Private_strands 7 at log switch
Thread 1 advanced to log sequence 3608
Current log# 2 seq# 3608 mem# 0: /var/oracle/oradata/jodo/redo02.log
Current log# 2 seq# 3608 mem# 1: /var/oracle/oradata/redomirror/redo02a.log
Mon Jun 6 20:22:01 2005
Private_strands 7 at log switch
Thread 1 advanced to log sequence 3609
Current log# 3 seq# 3609 mem# 0: /var/oracle/oradata/jodo/redo03.log
Current log# 3 seq# 3609 mem# 1: /var/oracle/oradata/redomirror/redo03a.log
Mon Jun 6 20:42:03 2005
Errors in file /usr/app/oracle/admin/jodo/udump/jodo_ora_14951.trc:
ORA-07445: exception encountered: core dump [joe_well_known_internal()+102] [SIG
SEGV] [Address not mapped to object] [0x3CADA5C0] [] []
===============================================================
In alert log file you can see .... Error ORA-07445
----------------------------------
Meaning of this error is as below as per documentation of oracle
now can i have any other solution of this error ....
ORA-07445 exception encountered: core dump [string] [string] [string] [string] [string] [string]
Cause: An operating system exception occurred which should result in the creation of a core file. This is an internal error.
Action: Contact Oracle Support Services.
-----------------------------------
Thank You
From:- Sunilkumar Vishwanath Mishra
|
|
|
|
| Re: ORA-03113: end-of-file on communication channel .. [message #122530 is a reply to message #122510] |
Tue, 07 June 2005 01:10 |
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
|
Senior Member |
|
|
HI
This is OS Error.
Whats the OS you are using? In Unix versions this is caused by bad iNode reference. Process tries to access a memory block not owned by user. You need to check your system error logs as well.
Also verify the intactness of ur datafiles using dbverify utility.
2 solutions I could find out for this:
1. Contact Oracle Support
Source: Almost Every entry on net states this.
2. set EPC_DISABLED=TRUE in the users and oracle's .profile, & add a line to the listener.ora, indicating that EPC_DISABLED=TRUE.
Source: http://www.mail-archive.com/oracle-l@fatcity.com/msg07828.html
Regds
Girish
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
