Re: connecting to SQL*Plus with 8i via ISP

change your connect timeout of your listener to 0 . This will solve your problem, if not, turn on tracing for further info.

CONNECT_TIMEOUT_LISTENER = 0 Mohamed Buhari
DBA Dana Reed wrote:

> We can't connect to an 8i server with SQL*Plus (version 8.1.5) through
> the internet; the error is "ORA-12535: TNS:operation timed out".
> However, we CAN connect to the same server with a RAS connection. The
> tnsnames.ora and sqlnet.ora files were generated with Net8 Assistant.
>
> The connection timeout on the server has been upped to 100 seconds.
> Also, the listener log shows that the connection gets to that level, but
> it never completes at the client. In fact, the listener log entries are
> identical when the connections are made either through the ISP or RAS;
> the difference is, the ISP connection times-out but the RAS connection
> succeeds.
>
> The server is behind a firewall, with the IP address for the server
> open, as well as port 1521. We have several 7.3 servers behind the same
> firewall that we've been accessing for years, and in fact can use
> SQL*Plus 8.1.5 to get to them as well (using SIDs instead of service
> names).
>
> Any ideas or thoughts are much appreciated!
Received on Wed Jan 26 2000 - 13:47:24 CST