Re: Oracle-ports

I just went through this nightmare, so here is what I learned;

Although the two ports are used for inbound communications, outbound traffic is assigned to random sockets. Use_shared_sockets is a work-around, and will allow only 50 concurrent sockets to be used. Also, if you shutdown the database, you need to shut down and restart the listener service. If you are using Oracle 8 or above, install and configure Connection Manager (consult its documentation). if you are using 7.x, have you network people either install your firewall vendor's sqlnet proxy, or set up the firewall with IP pass-through, although this method may or not be appropriate for your situation.

<sybrandb_at_my-deja.com> wrote in message news:8v3fno$he5$1_at_nnrp1.deja.com...
> In article <8v3bkm$9pm$1_at_news.sns-felb.debis.de>,
> "Gawdi Azem" <gawdi.azem_at_debis.com> wrote:
> > If I want to communicate between the client and the server through a
> > firewall,
> >
> > I have opened the ports 1521 and 1526...
> >
> > But it is not enough...
> >
> > The Oracle-Client uses more than the two ports.
> >
> > Is it possible to handle it, to make a fix-port.
> >
> > Is there any possibility to fix the TCP/IP-Port for communication
> >
> > between the oracle-client and the oracle-server.
> >
> > I have to modify the Registry of the Client and Server,
> >
> > but I do not know what for Values...
> >
> > Thanks for your reply...
> >
> >
>
> If you are on Oracle 8i and higher you can set
> sqlnet.use_shared_sockets= true
> in sqlnet.ora
> This will force sqlnet to use 1 port only.
> The last few days I answered this question several times a day.
> Archives of the Oracle related newsgroups are located at www.deja.com.
> Please try to search them (and always include your platform and version
> in your post, as you might get inadequate responses)
>
> Hth,
>
>
> --
> Sybrand Bakker, Oracle DBA
>
> All standard disclaimers apply
> ------------------------------------------------------------------------
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Nov 17 2000 - 15:17:50 CST