Creating a Net Service Name
Note: Only users that are members of either the OracleNetAdmins or the OracleContextAdmins group can create net service name entries in a directory.
To add net service names to a tnsnames.ora file or a directory server:
-
In the navigator pane, expand Oracle Net Configuration > Directory or Local > Service Naming.
-
Choose plus (+) from the toolbar, or choose Edit > Create from the menu bar. The Welcome page of the Net Service Name Wizard appears.
-
In the Net Service Name field, enter any name. The net service name can be qualified with the client's domain. The net service name is automatically domain if the client domain is specified.
-
Choose Next. The Protocol page appears.
-
Select the protocol on which the listener is configured to listen. Note that this protocol must also installed on the client.
-
Choose Next.The Protocol Settings page appears.
-
Enter the appropriate protocol parameters for the chosen protocol in the fields provided.
-
Choose Next. The Service page appears.
-
Select a release, enter a destination service, and, optionally, select a database connection type from the Oracle8i or Later Connection Type list.
If the destination service is Oracle8i or later, select Oracle8i or later, enter a service name in the Service Name field, and choose Next . If destination service is Oracle8 or Oracle7, select Oracle8 or Previous, enter an Oracle System Identifier in the Database SID field, and choose Next.
Oracle Corporation recommends that you use the default setting of Database Default for the connection type. If shared server is configured in the initialization parameter file, you can select Dedicated Server to force the listener to spawn a dedicated server, bypassing shared server configuration. If Database Resident Connection Pooling is enabled on the server, you can select Pooled Server to get a connection from the pool. If shared server is configured in the initialization parameter file and you want to guarantee the connection always uses a shared server, select Shared Server.
- Choose Next . The Test page appears.
- Choose Test to verify that the net service name works, or choose Finish to save your configuration and dismiss the Net Service Name Wizard.
If you choose Test , Oracle Net connects to the database server by using the connect descriptor information you configured. Therefore, the database and the listener must be running for a successful test. If they are not, see Chapter 15, Establishing a Connection and Testing the Network, in the Oracle10i Net Administrator's Guide to start the components. A successful test results in the following message:
The connection test was successful.
If the test was successful, choose Close to dismiss the Connect Test dialog box, and then proceed to Step 12.
If the test was not successful:
a. Ensure that the database and listener are running, and then choose Test.
b. Choose Change Login to change the user name and password for the connection, and then choose Test.
-
Choose Finish to save your configuration and dismiss the Net Service Name Wizard.
-
Ensure the profile reflects the local (LOCAL) or directory naming (LDAP) method.
Related Topics
Configure Default Domains for Clients
Copyright © 1996, 2009, 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.
