This only answers part of your question...Ports 1521 and 1526 are the
"normal" primary and rollover ports used in most SQL*Net configurations but
I think you're free to use any ports that aren't being used by something
else. I've used 1522 and 1524 for example but the range can be much wider
than just 152x numbers.
Andrew Melikov <amelikov_at_cami.com> wrote in message
news:7qvdaf$cjc_at_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 Mon Sep 06 1999 - 13:31:04 CDT
