Home » RDBMS Server » Networking and Gateways » DB LINK CONNECTION FAILURE
DB LINK CONNECTION FAILURE [message #250273] Mon, 09 July 2007 06:58 Go to next message
systemkhabir
Messages: 2
Registered: June 2007
Location: Dhaka
Junior Member

Hi everybody,
I have faced a problem with database linking and the following error is occured whenever i tried out to link to the remote DB server.

ORA-03113: end-of-file on communication channel

In the following way I have tried out to create the DB link

Create database link link_name
connect to current_user
user <service_name>

And then I have tried to link to remote DB
using the follwoing syntax:

SELECT *FROM remote_table_name@link_name


Thank u all
Mr.Khabir
Re: DB LINK CONNECTION FAILURE [message #250276 is a reply to message #250273] Mon, 09 July 2007 07:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
3113 is a generic error message.
Search on Metalink and/or contact Oracle support.

Regards
Michel
Re: DB LINK CONNECTION FAILURE [message #250319 is a reply to message #250276] Mon, 09 July 2007 11:07 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
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.

ORA-03113 issues happen due to various reasons including Network Issues, Forceful Disconnection of a Server Session,
Oracle Database Crash, Oracle Server Crash, Oracle internal errors like ORA-00600 or ORA-07445 causing aborts, Oracle Client or TNS layer inability to handle the connections and so on...

An example of this error is shown below. In this example, the ORA-3113 was generated by unavailability of Oracle as shown in ORA-01034 which indicates that either the oracle database session has been killed or the oracle database instance is down or has just crashed.

ORA-03113: end-of-file on communication channel
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

You as the dba or the user should be aware that this error can be very misleading and is also a catch-all error in the oracle software. Similar errors include the ORA-00600 and you should realize that oracle can just report this error sometimes when ever it has an internal issue.

This error requires analysis as a whole based on the accompanying error messages and should be search in Oracle Metalink. Oracle metalink Note 17613.1 will help you further analyze and understand this issue.
Re: DB LINK CONNECTION FAILURE [message #250321 is a reply to message #250319] Mon, 09 July 2007 11:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quoted from what?
It may be helpful to know.

Regards
Michel
Re: DB LINK CONNECTION FAILURE [message #250322 is a reply to message #250321] Mon, 09 July 2007 11:19 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
http://oracle.mydatabasesupport.com/oraerr/ora-03113-end-of-file-on-communication-channel.html
Re: DB LINK CONNECTION FAILURE [message #250323 is a reply to message #250322] Mon, 09 July 2007 11:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks, Thumbs Up
Michel
Re: DB LINK CONNECTION FAILURE [message #250324 is a reply to message #250323] Mon, 09 July 2007 11:36 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Razz You Welcome Wink
Previous Topic: create table xx_da as select * from table@2nd database not work
Next Topic: N-tier
Goto Forum:
  


Current Time: Wed Dec 07 12:17:54 CST 2016

Total time taken to generate the page: 0.12004 seconds