Oracle® Application Server

1.1 Meeting Prerequisites

You must meet the following prerequisites before installing Oracle Changed Data Capture Adapters 10.1.3.4:

• Installing Oracle Application Server 10.1.3.1

• Applying Oracle Application Server 10g Release 3 (10.1.3) Patch Set 4 (10.1.3.4.0)

• Downloading the Installable Files for Oracle Changed Data Capture Adapters 10.1.3.4

1.2 Installing Oracle Changed Data Capture Adapters Client by Using the Oracle Enterprise Manager

1. Download the installable files for Oracle Changed Data Capture Adapters 10.1.3.4 as mentioned in the preceding steps.

2. Navigate to http://servername:portnumber/em. The EM page appears, as shown in Figure 2.

   Figure 2 The Oracle Enterprise Manager Application Server Control Page

   
   Description of "Figure 2 The Oracle Enterprise Manager Application Server Control Page"
   
   

3. Click Home in the Members section in the Name column.

   The OC4J: home page appears, as shown in Figure 3.

   Figure 3 The OC4J: home Page

   
   Description of "Figure 3 The OC4J: home Page"
   
   

4. Click the Applications tab to open the Applications page. The OC4J: home Applications page appears, as shown in Figure 4.

   Figure 4 The Applications Tab in the OC4J: home Page

   
   Description of "Figure 4 The Applications Tab in the OC4J: home Page"
   
   

5. Click Deploy. The Oracle Enterprise Manager Deploy: Select Archive page appears, as shown in Figure 5.

   Figure 5 The Oracle Enterprise Manager Deploy: Select Archive Page

   
   Description of "Figure 5 The Oracle Enterprise Manager Deploy: Select Archive Page"
   
   

6. Select the first option under Archive, and then click Browse.

7. Upload the attunityResourceAdapter.rar file, and then click Next.

   The Oracle Enterprise Manager Deploy: Application Attributes page appears, as shown in Figure 6.

   Figure 6 The Oracle Enterprise Manager Deploy: Application Attributes Page

   
   Description of "Figure 6 The Oracle Enterprise Manager Deploy: Application Attributes Page"
   
   

8. Enter a name for the adapter in the Resource Adapter Name field, and then click Next.

   The Oracle Enterprise Manager Deploy: Deployment Settings page appears, as shown in Figure 7.

   Figure 7 The Oracle Enterprise Manager Deploy: Deployment Settings Page

   
   Description of "Figure 7 The Oracle Enterprise Manager Deploy: Deployment Settings Page"
   
   

9. Review the deployment settings, and then click Deploy.

   The Oracle Enterprise Manager Confirmation page confirming that the adapters has been successfully deployed appears, as shown in Figure 8.

   Figure 8 The Oracle Enterprise Manager Confirmation Page

   
   Description of "Figure 8 The Oracle Enterprise Manager Confirmation Page"
   
   

1.3 Installing Oracle Changed Data Capture Adapters Client by Using the Windows Command Prompt

At the Windows command prompt, use the following commands to install the Oracle Changed Capture Adapters:

<JAVA> -jar
<ORACLE_HOME>\j2ee\home\admin_client.jar
deployer:oc4j:opmn://<HOST>:<PORT>/<OC4J.CONTAINER.NAME>
oc4jadmin
<IASADMIN.PASSWORD>
-deploy
-file <ORACLE_HOME>\adapters\legacy\lib\attunityResourceAdapter.rar
-deploymentName jca-legacy-adapter

Where

<JAVA> is the JavaVM executable

<ORACLE_HOME> is the Oracle Home chosen by user

<HOST> is the Virtual Host Name of the SOA installation

<PORT> is the OPMN Request Port

<OC4J.CONTAINER.NAME> is the OC4J container chosen by the user

<IASADMIN.PASSWORD> is the ias admin password of the SOA installation.

1.4 Deinstalling Oracle Application Server Adapters Clients

To deinstall Oracle Application Server adapters:

1. Clean up any previous 10.1.3.1 Adapter installations by running the following commands:

   On Unix:

   cd $ORACLE_HOME/j2ee/home
   
   $ORACLE_HOME/jdk/bin/java -jar admin_client.jar
   deployer:oc4j:opmn://localhost:6003/home oc4jadmin welcome1 -undeploy
   jca-legacy-adapter -isConnector
   
   $ORACLE_HOME/jdk/bin/java -jar admin_client.jar
   deployer:oc4j:opmn://localhost:6003/home oc4jadmin welcome1 -undeploy
   jca-app-adapter -isConnector
   
   $ORACLE_HOME/jdk/bin/java -jar admin_client.jar
   deployer:oc4j:opmn://localhost:6003/home oc4jadmin welcome1 -undeploy
   jca-app-adapter-test
   
   $ORACLE_HOME/jdk/bin/java -jar admin_client.jar
   deployer:oc4j:opmn://localhost:6003/home oc4jadmin welcome1 -undeploy
   ws-app-adapter
   

   On Windows:

   cd %ORACLE_HOME%/j2ee/home
   
   %ORACLE_HOME%/jdk/bin/java -jar admin_client.jar
   deployer:oc4j:opmn://localhost:6003/home oc4jadmin welcome1 -undeploy
   jca-legacy-adapter -isConnector
   
   %ORACLE_HOME%/jdk/bin/java -jar admin_client.jar
   deployer:oc4j:opmn://localhost:6003/home oc4jadmin welcome1 -undeploy
   jca-app-adapter -isConnector
   
   %ORACLE_HOME%/jdk/bin/java -jar admin_client.jar
   deployer:oc4j:opmn://localhost:6003/home oc4jadmin welcome1 -undeploy
   jca-app-adapter-test
   
   %ORACLE_HOME%/jdk/bin/java -jar admin_client.jar
   deployer:oc4j:opmn://localhost:6003/home oc4jadmin welcome1 -undeploy
   ws-app-adapter
   

   Note:

   Ensure that the ORACLE_HOME environment variable is set to the location of your SOA installation.

   In each of the commands specified in the preceding examples, ensure that the hostname and OPMN request port number are specified correctly. This example uses localhost and 6004 respectively.

   Ignore any error message you get indicating that a certain application/resource adapter is not present.

2. Start Oracle Universal Installer, which is installed on your host.

3. Click Deinstall Products.

4. Expand the Oracle home directory that contains the products that you want to deinstall.

5. Select the specific OracleAS Adapter that you want to deinstall.

6. Click Remove.

7. Click Yes when prompted. The selected products are deinstalled.

8. Click Close.

   Note:

   The legacy J2CA resource adapter must be undeployed only if you choose to undeploy the entire set of legacy adapters.

2.1 Installation Tasks for Oracle Changed Data Capture Adapters

To install Oracle Changed Data Capture adapters use the steps mentioned in the section, Downloading the Installable Files for Oracle Changed Data Capture Adapters 10.1.3.4.

2.2 Postinstallation Tasks for Oracle Changed Data Capture Adapters Client

After the installing the Oracle Application Server Changed Data Capture adapters, you must perform the following Oracle Data Integrator (ODI) specific postinstallation tasks:

1. Navigate to the CDC_Adapter_v10134/ChangedDataCapture_Adapter/Client sub-directory of the Oracle CDC Adapter installation folder.

2. Unzip the JDBC-10134.zip file.

3. Stop all your Oracle Data Integrator instances.

4. Copy the following files in the oracledi/drivers/ directory of your Oracle Data Integrator installation:

   • · Navutil.class

   • · nvapispy2.jar

   • · nvjdbc2.jar

   • · nvlog2.jar

5. Restart Oracle Data Integrator.

For additional information refer to the Oracle Changed Data Capture Adapters chapter of the ODI Knowledge Modules Reference Guide.