Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: tnsping works, SQL/Plus does not
I have seen this behaviour when the remote server is behind a firewall. If
this is the case then the explanation is that although port 1521 is open on
the firewall allowing tnsping to work, the listener allocates a random port
for the actual database session. This port will be blocked resulting in the
behaviour you see. Of course if this is not the case I have no idea without
error messages. you could try setting tracing on your net8 connections and
seeing what the logfile says.
-- Niall Litchfield Oracle DBA Audit Commission UK "Cory Phillips" <cory_at_localhost.localdomain> wrote in message news:slrn9ou799.124.cory_at_localhost.localdomain...Received on Fri Aug 31 2001 - 02:54:52 CDT
> On 30 Aug 2001 09:20:32 -0700, C. R. Soza <crsoza_at_hotmail.com> wrote:
> >Can you telnet the linux server. Is TCP/IP running on the linux
> >server. These are some of the things you could check.
>
> Yes, I can telnet. TCP is working. When I start SQL/Plus it just
> hangs with no error messages and no response. I usually have to kill it
> in the task manager dialog box.
>
> --
> Cory Phillips
> cory_h_phillips_at_yahoo.com