Re: Oracle nameserver

tuxfan wrote:
> Is there a way to bypass the oracle nameserver and connect to
> the server that is running the data base? The application server
> is behind an internal firewall and management does not want to create
> a rule to allow access to the nameserver, if there a way to connect
> directly to the database server. I typically use perl DBI and
> sqlplus to connect to Oracle. I currently have
>
> NAMES.PREFERRED_SERVERS =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = TCP.world)
> (PROTOCOL = TCP)
> (HOST = nameserver1)
> (PORT = 1575)
> )
> )
>
>
> in sqlnet.ora.

>> The application server is behind an internal firewall and management does not want to create a rule to allow access to the nameserver <<

What?

You do not have to use a nameserver to connect to Oracle. But if the database is on a different server from the application and there is a firewall between the two servers you are going to need a rule to let the Oracle traffic through. Might as well let the nameserver traffic through.

Try setting up a tnsnames.ora file on the application server that references the host of the database server and the service name or SID of the target database using the port that the listener is listening on. Test.

HTH -- Mark D Powell -- Received on Thu Jan 11 2007 - 18:59:50 CST