| ORA-03113 end-of-file on communication channel [message #51499] |
Mon, 27 May 2002 02:56  |
christy
Messages: 6
Registered: May 2002
|
Junior Member |
|
|
Hi, I have a problem.
pls help me out if u can give ur hands to me.
I am importing data into new user of legacy database
but i can't with this error msg, "ORA-03113: end-of-file on communication channel"
Our Server is
Machine hardware: sun4u
OS version: 5.7
Processor type: sparc
Hardware: SUNW,Ultra-4
Oracle : 8.1.7
And initSid.ora is below.
pls, pls help !!!
Thanks for reading, and sorry for disturbing u.
i'm expecting ur help.
------------------------------------------------------------------------
The initSid.ora is below sentense.
------------------------------------------------------------------------
db_name = "ORCL"
instance_name = ORCL
service_names = ORCL
control_files = ("/u02/oradata/ORCL/control01.ctl", "/u02/oradata/ORCL/control
02.ctl", "/u02/oradata/ORCL/control03.ctl")
open_cursors = 2048
max_enabled_roles = 30
db_block_buffers = 44356
shared_pool_size = 61098393
large_pool_size = 39321600
java_pool_size = 20971520
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
processes = 200
log_buffer = 163840
background_dump_dest = /u01/app/oracle/admin/ORCL/bdump
core_dump_dest = /u01/app/oracle/admin/ORCL/cdump
ger_plan = system_plan
user_dump_dest = /u01/app/oracle/admin/ORCL/udump
db_block_size = 8192
remote_login_passwordfile = exclusive
os_authent_prefix = ""
compatible = "8.1.0"
sort_area_size = 65536
sort_area_retained_size = 65536
------------------------------------------------------------------------
|
|
|
|
| Re: ORA-03113 end-of-file on communication channel [message #51518 is a reply to message #51499] |
Tue, 28 May 2002 03:11  |
Craig
Messages: 28
Registered: October 2001
|
Junior Member |
|
|
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. Check your net8 two-task sofware.
HTH
|
|
|
|
| Re: ORA-03113 end-of-file on communication channel [message #51539 is a reply to message #51499] |
Wed, 29 May 2002 07:02 |
akli
Messages: 2
Registered: April 2002
|
Junior Member |
|
|
Hi christy, I have the same problem. Your problem is a network problem. Ask your network administrator to make an audit of the network.
You can check yourself the network. Try yhis: When a 03113 happened, ping your database server with the ping command, try a ping with 10 trames and a size 10000 bytes. If you do not have a good answer this means that you have a network problem.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
