To create a net service name in the tnsnames.ora file:
Select Local Net Service Name configuration in the Welcome page, and then click Next.
The Net Service Name Configuration page appears.
Click Add, and then click Next. The Net Service Name Configuration, Service Name page appears.
Enter a destination service name in the Service Name field, and then click Next.
The Net Service Name Configuration, Select Protocols page appears.
Select the protocols the listener is configured to listen on (these protocols must also installed on the client), and then click Next.
The page appropriate for the selected protocol appears.
Enter the appropriate protocol parameters for the chosen protocol in the fields provided, and then click Next.
The Net Service Name Configuration, Test page appears.
If you want to verify that the net service will work with a running database and listener, select Yes, perform a test, and then click Next. The Net Service Name Configuration, Connecting page appears.
A successful test results in the following message:
Connecting....Test successful.
When the test completes, click Next.
If the database and listener are not running at this time, select No, do not test, and then click Next. The Net Service Name Configuration, Net Service Name page appears.
Accept the default net service name or enter another net service name in the Net Service Name field, and then click Next. The name you enter should be unique to the client.
The Net Service Name Configuration, Another Net Service Name? page appears.
Select No if you do not want to configure any more net service names, and then click Next.
The Net Service Name Configuration Done page appears. Or, select Yes to configure another net service name, and then click Next.
Oracle Net Services Configuration Overview
Copyright © 1996, 2011, Oracle and/or its affiliates.All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.