Configuring Preferred Oracle Names Servers

If you are using Oracle Names as a naming method, you can specify the name and address of preferred Oracle Names servers to take precedence over any other available Oracle Names server addresses. Net8 will route connect requests to each preferred Oracle Names Server until a response is received.

The addresses for Preferred Oracle Names servers are stored in the SQLNET.ORA file.

Note: This is an alternative to using the Discover Oracle Names Servers option, a newer feature that creates a list of Oracle Names servers in a SDNS.ORA file. The SDNS.ORA file is based on what is available throughout the network, ranked in the order of fastest response time. Preferred Oracle Names servers override any other Oracle Names servers found in the discovery process. Once you have initially discovered an Oracle Names Server and generated an Oracle Names server list file, you may want to delete preferred Oracle Names Servers.

To specify a preferred Oracle Names server:

  1. Click the Profile icon.

  2. Choose Preferred Names Server from the drop-down list box.

  3. Choose a protocol used by the Oracle Names server from the Protocol drop-down list box.

  4. Enter information in the fields as appropriate:

    Protocol
    		Parameter
    		Description
    IPC


    		KEY


    		Identifies the Oracle Names server.


    Named Pipes


    		SERVER


    		Identifies the name of the Oracle Names server.



    		PIPE


    		Identifies the pipe name to use to connect to the Oracle Names server (the same PIPE keyword you specified on the server with Named Pipes). This name can be any name.


    SPX


    		SERVICE


    		Defines the name of the TNS-based application on the network.


    TCP/IP


    		HOST


    		Identifies the Oracle Names server host name.



    		PORT


    		Identifies the Oracle Names server listening port number. Oracle Corporation recommends port 1575.


    TCP/IP with SSL
    Note: Choosing this protocol configures a default implementation of SSL for this machine.


    		HOST


    		Identifies the Oracle Names server host name.



    		PORT


    		Identifies the Oracle Names server listening port number. Oracle Corporation recommends port 1575.


  5. Choose Save Network Configuration from the File menu to save changes to SQLNET.ORA in $ORACLE_HOME/network/admin on UNIX or ORACLE_HOME\network\admin on Windows platforms, or choose Save As from the File menu to save under a different file name or path.

To create additional preferred Oracle Names servers:

Click New.

To delete a preferred Oracle Names server:

Click Delete.