Create a Net Service Name in a tnsnames.ora File

To create a net service name in the tnsnames.ora file:

  1. Click Local Net Service Name configuration in the Welcome page, then click Next. The Net Service Name Configuration page appears.
  2. Click Add, then click Next. The Net Service Name Configuration, Database Version page appears.
  3. If the destination service is Oracle8i, click Oracle8i database or service, then click Next. If destination service is Oracle8 or Oracle7, click Oracle8 release 8.0 or Oracle7 database or service, then click Next.

    Depending on your selection, the Net Service Name Configuration, Service Name or Net Service Name Configuration, Database SID page appears.

  4. Enter a destination service.

    If the destination service is release 8.1, enter a service name in the Service Name field, and click Next. If destination service is prior to release 8.1, enter an Oracle System Identifier in the Database SID field, and click Next.

    The Net Service Name Configuration, Select Protocols page appears.

  5. Select the protocols the listener is configured to listen on (these protocols must also installed on the client), then click Next. The page appropriate for the selected protocol appears.
  6. Enter the appropriate protocol parameters for the chosen protocol in the fields provided, then click Next. The Net Service Name Configuration, Test page appears.
  7. If you want to verify that the net service will work with a running database and listener, click Yes, perform a test, then click Next. The Net Service Name Configuration, Connecting page appears.

    A successful test results in the following message:

    The connection test was successful.

    When the test completes, click Next.

    If the database and listener are not running at this time, click No, do not test, then click Next. The Net Service Name Configuration, Net Service Name page appears.

  8. Accept the default net service name or enter another net service name in the Net Service Name field. The name you enter should be unique to the client. The Net Service Name Configuration, Another Net Service Name? page appears.
  9. Click No if you do not want to configure any more net service names, then Next. The Net Service Name Configuration Done page appears. Or, click Yes to configure another net service name, then click Next to repeat steps 3-8.
  10. Click Next to acknowledge the Net service name Configuration Complete! message.