Re: Intermittent Oracle client errors

On 14 Oct 2005 11:10:32 -0700, "Oracle Pseudo DBA" <yoramayalon_at_gmail.com> wrote:

>any clue anyone? here is a typical error I see on a client's
>sqlnet.log:
>=================================================
>Fatal NI connect error 12535, connecting to:

12535 is usually caused by firewall. Remember, that the 1521 port is only used to contact the listener. When the listener forks a session the session is redirected to a random port. That port may be closed by your firewall administrator.
I have posted ad nauseam the various solutions to prevent the 12535 error, so I'm not going to repeat them here.

 Actually how to deal with Oracle in a firewall situation is documented in the net8 administrators manual, but I am aware most people don't like to read manuals, and don't like to google, but rather post their FAQ *yet again*

--
Sybrand Bakker, Senior Oracle DBA