Re: database in firewall

Take a look at the Oracle Net configuration guide (online at www.oracle.com). In order to connect to a database you need to be able to connect to the listener for that database. Sometimes, due to the way the system administrator has the server configured, the listener is unable to work using the default configuration. The default configuration of the listener uses port redirection. If the listener is listening on port 3152 for database connection requests and a request is received then the listener will dynamically assign a new port number for that session to communicate on. If the ports have been locked down by the sys admin then the listener will be unable to assign the session a port number and the connection will not be made.

We had a similar issue at work where we had to allow a range of ports to be available for the listener to use.

"Ste" <schen88_at_comcast.net> wrote in message news:<25mdnRFke9IAHdHcRVn-tA_at_comcast.com>...
> Hi,
>
> Has anyone implemented the configuration of putting database in firewall to
> have client access from outside? What are the tnsnames.ora IPs in two
> sides, say firewall database server is 111.1111.111.111, while client side
> is 222.222.222.0/24?
>
> Any comment is greatly appreciated.
>
> Ste
Received on Sat Sep 18 2004 - 19:54:53 CDT