Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: end-of-communication chanel

Re: end-of-communication chanel

From: Dejan Topalovic <detop_at_fly.srk.fer.hr>
Date: Wed, 5 Oct 2005 17:47:42 +0000 (UTC)
Message-ID: <slrndk84du.o1j.detop@fly.srk.fer.hr>


On 2005-10-05, T <t_at_yahoo.com> wrote:
> table is on Oracle 9.2.0.1
>
> I run query on Oracle 9.2.0.1 >>>select * from table<<< , it
> was ok
>
> also i run the the same query (through database link) on Oracle 8.1.7
> >>>select * from table_at_databaselink<<<, then an error occured,
> end-of-communication chanell...
>
> Any idea to avoid error..???
> Should i need to run some script to make compatibility???

I had same error...
Look at your sqlnet.ora file and find, if there's something like:

SQLNET.INBOUND_CONNECT_TIMEOUT = 300
SQLNET.SEND_TIMEOUT = 300
SQLNET.RECV_TIMEOUT = 300

If yes, then comment that out:

#SQLNET.INBOUND_CONNECT_TIMEOUT = 300
#SQLNET.SEND_TIMEOUT = 300
#SQLNET.RECV_TIMEOUT = 300

and try again...

-- 
Dejan Topalovic "StRiPy"
Received on Wed Oct 05 2005 - 12:47:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US