Edit

Share via

Configure the Oracle client for the E-Business Suite adapter

  • Article

Important

This topic is relevant only if you are using tnsnames.ora to connect to the Oracle database.

To establish a connection to the Microsoft BizTalk Adapter for Oracle E-Business Suite, the adapter connects to the underlying Oracle database through the Oracle client installed on your computer. The Oracle E-Business adapter passes the net service name that you specify in the connection URI to the Oracle client to establish a connection to Oracle E-Business Suite. The net service name is an alias that the Oracle client uses to acquire connection information for the target Oracle database service.

The Oracle client resolves the net service name according to the naming method that it is configured to use. You use the Oracle Net Configuration Assistant to configure the naming methods to be used by the Oracle client. The Oracle E-Business adapter supports the Local Naming method for connecting to Oracle E-Business Suite. This method uses a local file, tnsnames.ora, to resolve the net service name.

The tnsnames.ora file associates net service names with connect descriptors that contain the information that the Oracle client needs to establish a connection to a specific Oracle database service (instance). The following is a sample entry from tnsnames.ora.

ADAPTER =  
  (DESCRIPTION =  
    (ADDRESS_LIST =  
      (ADDRESS = (PROTOCOL = TCP)(HOST = yourOracleServer)(PORT = 1521))  
    )  
    (CONNECT_DATA =  
      (SERVICE_NAME = yourOracleDatabaseServiceName)  
    )  
  )

In this sample entry, ADAPTER is the net service name. The connect descriptor specifies address information and the service name of the Oracle database service associated with ADAPTER. You can use the Oracle Net Configuration Assistant to create and configure net service names in tnsnames.ora. After you have configured the net service name, you can specify it in a connection URI as in the following example.

oracleebs://ADAPTER

For more information about using the Oracle Net Configuration Assistant and about tnsnames.ora, see the Oracle Database Net Services Administrator's Guide. Consult your database administrator about configuration details for your specific installation.

See Also

Create a connection to Oracle E-Business Suite