Configuring a Connect Descriptor for Connections to Oracle Connection Manager

T o route clients to the database server through Oracle Connection Manager configure either the tnsnames.ora file or the directory server with a connect descriptor that specifies the protocol address of Oracle Connection Manager. This address enables the client to connect to the Oracle Connection Manager computer.

To configure a protocol address for Oracle Connection Manager:

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. Enter any name in the Net Service Name field.

4. Choose Next. The Protocol page appears.

5. Select the protocol the Oracle Connection Manager is configured to listen on. By default this protocol is TCP/IP.

6. Choose Next. The Protocol Settings page appears.

7. Enter the appropriate protocol parameters for the chosen protocol in the fields provided. If you are using TCP/IP, the default port is 1630.

8. Choose Next. The Service page appears.

9. If the destination service is Oracle8i or later, select Oracle8i or later, and enter a service name in the Service Name field. If destination service is Oracle8 or Oracle7, select Oracle8 or Previous, and enter an Oracle System Identifier in the Database SID field.

10. Choose Next. The Service page appears.

11. Click Finish to save your configuration and dismiss Net Service Name Wizard.

12. Choose File > Save Network Configuration.

13. The new net service name is added to the Service Naming folder.

For more information on fully enabling Oracle Connection Manager features, see Chapter 11, Configuring and Administering Oracle Connection Manager, in the Oracle10i Net Administrator's Guide.

Related Topics

Oracle Net Services Overview

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.

Configuring a Connect Descriptor for Heterogeneous Services

Heterogeneous Services enable you to access a non-Oracle systems from the Oracle server. To initiate a connection to a non-Oracle system, the Oracle server starts an agent process through the listener on the gateway. In order for the Oracle database to connect to a non-Oracle system, configure the server with a net service name.

To configure the server for Heterogeneous Services:

1. Ensure the listener is configured for Heterogeneous Services, as described in Configure Heterogeneous Services for the Listener.

2. Create a net service name in the tnsnames.ora file that can be used for connections from the Oracle database server to a non-Oracle system. Ensure the connect descriptor information matches the information configured for the listener.

3. Select the net service name in the Local > Service Naming folder.

4. In the right pane's Service Identification box, choose Advanced. The Advanced Service Options dialog box appears.

5. Choose Use for Heterogeneous Services, and then choose OK.

6. In the right pane, choose Apply.

7. Choose File > Save Network Configuration.

Related Topics

Oracle Net Services Overview

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.

Configuring a Connect Descriptor for an Oracle Rdb Database

An Oracle Rdb database is a database for Digital's 64-bit platform. Oracle Rdb servers appear the same way to clients as an Oracle database. An Oracle Rdb database has its own listener. Client configuration consists of creating a net service name with Oracle Rdb-specific parameters to access the database.

To configure the client for an Oracle Rdb database:

1. Create a net service name, as described in Create a Net Service Name.

2. In the right pane's Service Identification box, choose Advanced. The Advanced Service Options dialog box appears.

3. Enter the file name of an Oracle Rdb database in the Rdb Database field.

4. Optionally, enter the global database name in the Global Database Name field, and, if needed, the type of service in the Type of Service field.

5. In the Advanced Service Options dialog box, choose OK.

6. In the right pane, choose Apply.

7. Choose File > Save Network Configuration.

For more information, see Oracle Rdb documentation.

Related Topics

Oracle Net Services Overview  

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.

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:

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.

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

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

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.

Related Topics

Configure Default Domains for Clients

Prioritize Naming Methods

Oracle Net Services Overview

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.

CyberSafe

The CyberSafe authentication method requires you set the following parameter:

GSSAPI Service

The name of the GSSAPI service you want to use.

Related Topics

Oracle Advanced Security: Other Params

Oracle Net Services Overview

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.

directory information tree (DIT)

A hierarchical tree-like structure in a directory server of the distinguished names (DNs) of the entries.

Related Topics

Oracle Net Services Overview

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.

Directory Naming Requirements for Oracle Net Manager

Oracle Net Manager enables you to create network route information for a database service, as well as create net service names, in a directory server

In order for Oracle Net Manager to write to a directory:

• The directory must be configured with an Oracle schema.

• The computer running Oracle Net Manager must be configured with a default Oracle Context to access and write entries.

These configuration settings are set with Oracle Net Configuration Assistant, as described in Directory Naming Configuration Overview. Oracle Net Manager does not offer this functionality

If directory access is not configured, the Oracle Net Configuration > Directory folder in the navigator pane and the Command > Directory menu will not be available.

Related Topics

Oracle Net Services Overview

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.

distinguished name (DN)

Specifies where an entry resides in a directory server hierarchy, much the way a directory path specifies the exact location of a file.

Related Topics

Oracle Net Services Overview

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.

Domain Name System (DNS)

A system for naming computers and network services that is organized into a hierarchy of domains. DNS is used in TCP/IP networks to locate computers through user-friendly names. DNS resolves a friendly name into an IP address, which is understood by computers.

In Oracle Net, DNS translates the host name used in TCP/IP addresses into an IP address.

Related Topics

Oracle Net Services Overview

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.

General: Access Rights

The Access Rights tab enables you to specify which clients to allow or deny access to the database.

Check TCP/IP client access rights

Select this checkbox if you want to specify which clients to allow and deny database access. Deselect the checkbox if you want to disable this functionality. If the checkbox is deselected, all clients are allowed access.

Clients excluded from access

Enter either a host name or an IP address to specify which clients are denied database access. Use a comma to separate entries placed on the same line.

Clients allowed to access

Enter either a host name or an IP address to specify which clients are allowed database access. Use a comma to separate entries placed on the same line.

Note: Clients allowed to access takes precedence over Clients excluded from access.

Related Topics

Oracle Net Services Overview

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.