Create a Net Service Name in an Oracle Names Server

Oracle Corporation 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 Oracle Net Configuration > Oracle Names Servers.

  2. Select the Oracle Names server.

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

  4. Select the Net Service Names tab.

  5. Select Add.

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

    The net service name can be qualified with the domain. The net service name is automatically domain qualified if the domain is specified.

     

    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.

     

    Note: Additional addresses can be created by choosing plus (+) 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, choose Advanced under the Address tab.

  9. Enter a destination service. If the destination service is Oracle9i or Oracle8i, enter the database service name in the Service Name field. If destination service is Oracle8, select Oracle8i Release 8.0 Compatible Identification, and then enter an Oracle System Identifier in the SID field.

     

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

  10. Choose Execute.

  11. Choose File > Save Network Configuration.