This chapter describes information unique to certain component products.
For this release, this chapter includes the following topics:
You can deploy the Oracle Virtual Assembly Builder Deployer to a single server only, not a cluster. You can deploy it to an Administration Server in a single server domain.
See Also:
For more information on Oracle Virtual Assembly Builder, see Using Oracle Virtual Assembly Builder.
This topic describes considerations for configuring Oracle Data Integrator repository connections to Oracle Real Application Clusters:
Section 9.2.1, "Oracle RAC Retry Connectivity for Source and Target Connections"
Section 9.2.2, "Configuring Repository Connections to Oracle RAC"
When you configure Oracle Data Integrator (ODI) Oracle Real Application Clusters (RAC) connections, Oracle RAC retry is supported for the ODI master or ODI work repository. ODI uses transactional connections to source and target connections while running ODI scenarios. For these source and target connections, ODI does not support RAC retry connectivity. You cannot migrate these transactions to another node in Oracle RAC.
When you create an ODI repository using the Repository Creation Utility (RCU), you specify the work repository connection JDBC URL. RCU stores the URL in the master repository contents. If the work repository JDBC URL is a single node URL, you should modify the URL to include the Oracle Real Application Clusters (Oracle RAC) failover address.
If Oracle RAC is not configured with Single Client Access Name (SCAN), you can provide details of the Oracle RAC instances. In the work repository JDBC Url field, enter the Oracle RAC connectivity address in the format host:port. See Example 9-1.
If Oracle RAC is configured with SCAN, provide Oracle RAC instance details with the SCAN address.
Example 9-1 shows the JDBC URL format to connect to an Oracle RAC with two hosts when it does not use SCAN:
Example 9-1 JDBC URL Format (Oracle RAC Not Configured with SCAN)
jdbc:oracle:thin:(DESCRIPTION = (LOAD_BALANCE=ON) (ADDRESS = (PROTOCOL = tcp) (HOST = host1)(PORT = port1)) (ADDRESS = (PROTOCOL = tcp)(HOST = host2) (PORT = port2)) (CONNECT_DATA = (SERVER=dedicated) (SERVICE_NAME=service_name)))
See the topic "Creating a Work Repository" in the Oracle Fusion Middleware Developer's Guide for Oracle Data Integrator for more information.