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:
Ensure the listener is configured for Heterogeneous Services, as described in Configure Heterogeneous Services for the Listener.
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.
Select the net service name in the Local > Service Naming folder.
In the right pane's Service Identification box, choose Advanced. The Advanced Service Options dialog box appears.
Choose Use for Heterogeneous Services, and then choose OK.
In the right pane, choose Apply.
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.