6 OPLA Installation on Real Application Cluster

This chapter lists the prerequisites, installation procedure, and post-installation guidelines for installing OPLA on Real Application Cluster.

6.1 Prerequisites

1. Install Oracle Database cluster. For more information, see Oracle Database documentation.

2. Install supported ODI version. For more information, see ODI Installation documentation.

6.2 Installing Oracle PLA on Real Application Cluster

1. Create TNS entries for Agile PLM source on each node in the cluster.

   ETL will fail if the TNS entries are not created. This is not required while installing Agile PLM for Process.

2. Install OPLA in any of the nodes in the cluster environment by following the installation procedure provided.

6.3 Post Installation Tasks

After you install OPLA on RAC, perform the following steps:

1. Launch the ODI Operator.

   Note OPLA can be installed on any of the nodes in the cluster.

2. 2. In the Work Repository Connection window, the URL is displayed in the format Jdbc:oracle:thin:@<host>:port:sid. Replace the URL with the corresponding details of the two nodes.

   For example:

   Jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)

   (ADDRESS=(PROTOCOL=TCP) (HOST=<NODE # 1 HOSTNAME> (PORT=1521))

   (ADDRESS=(PROTOCOL=TCP)(HOST=<NODE # 2 HOSTNAME> (PORT=1521))

   (CONNECT_DATA=(SERVICE_NAME=<SID NAME>)))

   For more information on setting up ODI Users, refer to Setting up ODI Users.

3. Launch the Topology Manager and update the target JDBC database configuration for both Staging and MDS. Please refer to the example provided in Step 2.

   For more information, see ODI documentation or contact Oracle Support.