Create a Net Service Name

Notes:

  • Only users that are members of either the OracleNetAdmins or the OracleContextAdmins group can create net service name entries in a directory.

  • You can export existing net service names from an Oracle Names server. See Chapter 10, "Exporting Naming Data to a Directory Server," of the Oracle9i Net Services Administrator's Guide for further information.

 

To add net service names to a tnsnames.ora file or a directory server:

  1. In the navigator pane, expand Oracle Net Configuration > Directory or Local > Service Naming.

  2. Choose plus (+) from the toolbar, or choose Edit > Create from the menu bar. The Welcome page of the Net Service Name Wizard appears.

  3. 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.

     

    See Also: Configure Default Domains for Clients

  4. Choose Next. The Protocol page appears.

  5. Select the protocol on which the listener is configured to listen. Note that this protocol must also installed on the client.

  6. Choose Next. The Protocol Settings page appears.

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

  8. Choose Next. The Service page appears.

  9. 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 Oracle9i or Oracle8i, 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 shared server is configured in the initialization parameter file and you want to guarantee the connection always uses a shared server, select Shared Server.

  10. Choose Next. The Test page appears.

  11. 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 16, Establishing a Connection and Testing the Network, in the Oracle9i 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.

  12. Choose Finish to save your configuration and dismiss the Net Service Name Wizard.

  13. Ensure the profile reflects the local (LOCAL) or directory naming (LDAP) method.

     

    See Also: Prioritize Naming Methods for further information about prioritizing naming methods