Re: Intermittent ORA-12535 error

From: damorgan <damorgan_at_exesolutions.com>
Date: Wed, 04 Dec 2002 16:14:19 GMT
Message-ID: <3DEE29D8.99A54D47@exesolutions.com>

Craig Buchanan wrote:

> We are attempting to connect SQL Server to Oracle via SQL Server's
> Link Server.
>
> Occassionally, we experience a connectivity problem. The error reads:
> ORA-12535 TNS:operation timed out. Other times, the connection works
> fine.
>
> Oddly, another machine, identically configured (as much as this is
> possible...) does not have any such problems.
>
> What is happening? Is this an Oracle issue, a firewall issue, a
> network issue or something else?
>
> Thanks in advance,
>
> Craig Buchanan

Given that you have provided no information on version, edition, firewall, hardware, operating system, etc. I'm not sure anyone can really help you.

How about providing some information from which to formulate a response?

Daniel Morgan Received on Wed Dec 04 2002 - 10:14:19 CST