SQLnet Question

From: Andrew Melikov <amelikov_at_cami.com>
Date: Sun, 5 Sep 1999 23:44:36 -0400
Message-ID: <7qvdaf$cjc@dfw-ixnews19.ix.netcom.com>

Hi All,

I am writing a network forwarder that supposed to enable access to oracle server from one net to another.

Looks like simple packets forwarding addressed to port 1521 doesn't do the job.

Does anyone know what ports SQLnet uses to communicate? In my case -- a box is listening on 1521 port. The connection request comes in -- it opens another socket to 1521 on a real (the target) machine and begins crossforwading.

Now, I open up SQL*plus and at the same time monitoring the forwarder -- connection happens (for a few seconds) and then the server drops it (closes the port) and SQL*Plus displays an error (connection was unexpectedly lost).

Any suggestions?

Thanks!
Andrew Melikov
amelikov_at_cami.com Received on Sun Sep 05 1999 - 22:44:36 CDT