Create a Net Service Name in an Oracle Names Server

Oracle advises creating a net service name for each service. If a net service name is not created, a user trying to connect will have to pass the global database name to make a connection. Rather than provide this information to your end users, create a net service name for the service.

To create a net service name:

  1. In the navigator pane, expand Net8 Configuration > Oracle Names Servers.

  2. Select the Oracle Names server.

  3. From the list in the right pane, select Manage Data.

  4. Click the Net Service Names tab.

  5. Click Add.

  6. Enter an easy-to-remember alias in the Service Name field.

    The net service name may be qualified with the Oracle Names server's domain. The net service name is automatically domain qualified if the client domain is specified.

    seealso.gif
    See Also: Configure Default Domains for Clients

  7. Select a protocol the listener is configured to listen on.

  8. Enter the appropriate protocol parameters for the chosen protocol in the fields provided.

    notice.gif
    Note: Additional addresses can be created by clicking "+" at the bottom of the Address tab. When multiple addresses are configured, you configure features, such as connect-time failover, client load balancing, or source routing. To configure these features, click Advanced under the Address tab.

  9. Enter a destination service. If the destination service is release 8.1, enter the database service name in the Service Name field. If destination service is prior to release 8.1, click Oracle8i Release 8.0 Compatible Identification, then enter an Oracle System Identifier in the SID field.

    notice.gif
    Note: If you want to configure advanced CONNECT_DATA options besides the destination service, click Advanced.

  10. Click Execute.

  11. Choose File > Save Network Configuration.