To 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 protocol addresses of Oracle Connection Manager and the listener.
To configure a client for Oracle Connection Manager:
Configure a protocol address for Oracle Connection Manager:
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.
Enter any name in the Net Service Name field.
Choose Next. The Protocol page appears.
Select the protocol the Oracle Connection Manager is configured to listen on. By default this protocol is TCP/IP.
Choose Next. The Protocol Settings page appears.
Enter the appropriate protocol parameters for the chosen protocol in the fields provided. If you are using TCP/IP, the default port is 1630.
Choose Next. The Service page appears.
If the destination service is Oracle9i or Oracle8i, select Oracle8i or later, and enter a service name in the Service Name field. If destination service is Oracle8 or Oracle7, select Oracle8i release 8.0 or Previous, and enter an Oracle System Identifier in the Database SID field.
Choose Next. The Service page appears.
Click Finish to save your configuration and dismiss Net Service Name Wizard.
Configure a protocol address for the listener:
In the Oracle Net Manager's navigator pane, select the net service name that you created in Step 1.
In the Address Configuration box, choose plus (+). A new address tab displays.
Select a protocol configured for the listener, and then enter the appropriate parameter information for that protocol. If you are using TCP/IP, the default port number is 1521.
In the Address Configuration box, click Advanced. The Address List Options dialog box appears.
Select "Use each address in order until destination reached", and then choose OK. This option sets SOURCE_ROUTE=on. It tells the client to connect to the first protocol address, the Oracle Connection Manager, and from the first protocol address to the second protocol address, the listener.
Choose File > Save Network Configuration.
The new net service name and the Oracle Connection Manager address is added to the Service Naming folder.
|
See Also: Chapter 13, Configuring Oracle Connection Manager, in the Oracle9i Net Administrator's Guide to fully enable Oracle Connection Manager features |