Re: ORA-12535: TNS:operation timed out

This someone is correct. Oracle listens on 1521 (or 1526, which is actually the
old SQL*Net V1 port), but sets up a connection on another port. On Unix, check
with netstat.
Your firewall probably won't allow that, and block it. Finally, the client times out,
and a TNS-12535 results from that. So far the schoolteacher.

(you can try: ask to disable the firewall, and the connection will work)

This problem has been addressed before, and there is a parameter to tell the listener to use a specific port. Problem is, I can't remeber the name, and I failed
to locate it just now.

--
Kind Regards,
Frank
"Jeff" <jdcc_at_worldnet.att.net> wrote in message
news:397A7179.1007DB14_at_worldnet.att.net...


> I'm trying to connect to an instance over the internet with SQL*Plus and


>

> receive ORA-12535: TNS:operation timed out.  I can connect w/SQL*Plus

> from within my company but not from home.  The network administrator has

>

> opened a hole in the firewall and I can ping the db server w/o problem.

>

> I am using the standard port 1521.  Someone suggested that oracle

> listens on one port and perhaps responds back to the client using

> another port.  Is there a setting in TNSNAMES.ORA to force the db server

>

> to respond to the client back on port 1521?

>

> Any suggestions greatly appreciated.

>

> Jeff

>