C Configuring Oracle Fusion Middleware Application Adapter for SAP R/3 (SAP JCo 3.x)

This appendix describes how to configure Oracle Fusion Middleware Application Adapter for SAP R/3 (SAP JCo 3.x). It contains the following sections:

Overview

The installation of Oracle Fusion Middleware Application Adapter for SAP R/3 (SAP JCo 3.x) on a 11g Release 1 (11.1.1) system depends on your existing configuration.

If you already have Oracle Fusion Middleware Application Adapter for SAP R/3 (using SAP JCo 2.1.x) installed on your system with configured BPEL and Mediator processes, then follow the steps described in "Scenario I".

If you have the 11g Release 1 (11.1.1) Oracle Fusion Middleware Application Adapters installed on your system and no configuration has been performed with the Oracle Fusion Middleware Application Adapter for SAP R/3 (using SAP JCo 2.1.x), then follow the steps described in "Scenario II".

Scenario I

This scenario describes how to configure Oracle Fusion Middleware Application Adapter for SAP R/3 (SAP JCo 3.x) if you already have the previous version of the adapter (using SAP JCo 2.1.x) installed on your system with configured BPEL and Mediator processes.

  1. Start Application Explorer.

    For more information, see Chapter 2, "Installation and Configuration".

  2. Delete the following components that were created with Oracle Fusion Middleware Application Adapter for SAP R/3 (using SAP JCo 2.1.x) in Application Explorer:

    • Adapter Targets

    • Channels

    • All Web services that were created for BSE configurations

  3. Stop the Oracle WebLogic Server (Admin server) and managed Oracle WebLogic Server (SOA sever).

  4. Delete the iwmysap.jar and SAP JCo 2.1.x library files (sapjco.jar, sapjcorfc.dll, and librfc32.dll) from the Adapter lib directory and Domain lib directories. For example:

    Adapter lib directory:

    Oracle SOA Suite:

    <ORACLE_HOME>\Oracle_SOA1\soa\thirdparty\ApplicationAdapters\lib

    Oracle Service Bus (OSB):

    <OSB_HOME>\Oracle_OSB1\3rdparty\ApplicationAdapters\lib

    Domain lib directory:

    <ORACLE_HOME>\user_projects\domains\base_domain\lib

  5. Delete the iwmysap.jar file from the iwafjca.rar folder.

    Oracle SOA Suite:

    <ORACLE_HOME>\Oracle_SOA1\soa\thirdparty\ApplicationAdapters\iwafjca.jar

    Oracle Service Bus (OSB):

    <OSB_HOME>\Oracle_OSB1\3rdparty\ApplicationAdapters\iwafjca.jar

  6. Delete the SAP JCo 2.1.x library files from the WebLogic domain lib directory:

    <ORACLE_HOME>\user_projects\domains\base_domain\lib

  7. Copy the new iwmysap30.jar file from the following installation build directory:

    Oracle SOA Suite:

    <ORACLE_HOME>\Oracle_SOA1\soa\thirdparty\ApplicationAdapters\etc\mysap30

    Oracle Service Bus (OSB):

    <OSB_HOME>\Oracle_OSB1\3rdparty\ApplicationAdapters\etc\mysap30

    to the following directories:

    Adapter lib directory

    Oracle SOA Suite:

    <ORACLE_HOME>\Oracle_SOA1\soa\thirdparty\ApplicationAdapters\lib

    Oracle Service Bus (OSB):

    <OSB_HOME>\Oracle_OSB1\3rdparty\ApplicationAdapters\lib

    iwafjca.rar directory

    Oracle SOA Suite:

    <ORACLE_HOME>\Oracle_SOA1\soa\thirdparty\ApplicationAdapters\iwafjca.rar

    Oracle Service Bus (OSB):

    <OSB_HOME>\Oracle_OSB1\3rdparty\ApplicationAdapters\iwafjca.rar

  8. Copy the SAP JCo 3.0.5 library files (sapjco3.jar and sapjco3.dll) to the Adapter lib and Domain lib directories:

    Adapter lib directory

    Oracle SOA Suite:

    <ORACLE_HOME>\Oracle_SOA1\soa\thirdparty\ApplicationAdapters\lib

    Oracle Service Bus (OSB):

    <OSB_HOME>\Oracle_OSB1\3rdparty\ApplicationAdapters\lib

    Domain lib directory

    <ORACLE_HOME>\user_projects\domains\base_domain\lib

  9. Redeploy ibse.war, iwafjca.rar, and iwafjca.war using the Oracle WebLogic Server Administration Console.

    For more information, see Chapter 2, "Installation and Configuration".

  10. Start Application Explorer.

  11. Create the following components using Application Explorer for Oracle Fusion Middleware Application Adapter for SAP R/3 (SAP JCo 3.x):

    • Adapter Targets

    • Channels

    • All Web services that was created using BSE configurations

    Note:

    The names that are specified for the new adapter targets, channels, and Web services must match those that were created for Oracle Fusion Middleware Application Adapter for SAP R/3 (using SAP JCo 2.1.x).

    This ensures that the BPEL and Mediator processes that were created with Oracle Fusion Middleware Application Adapter for SAP R/3 (using SAP JCo 2.1.x) work properly with the new Oracle Fusion Middleware Application Adapter for SAP R/3 (SAP JCo 3.x).

  12. Start the Oracle WebLogic Server (Admin server) and managed Oracle WebLogic Server (SOA sever).

  13. Execute all available BPEL and Mediator processes for BSE and J2CA configurations.

Scenario II

This scenario describes how to configure Oracle Fusion Middleware Application Adapter for SAP R/3 (SAP JCo 3.x) if you have the 11g Release 1 (11.1.1) Oracle Fusion Middleware Application Adapters installed on your system and no configuration has been performed with the Oracle Fusion Middleware Application Adapter for SAP R/3 (using SAP JCo 2.1.x).

  1. Install the Oracle Fusion Middleware Application Adapters build containing Oracle Fusion Middleware Application Adapter for SAP R/3 (SAP JCo 3.x) on a 11g Release 1 (11.1.1) system.

  2. Stop the Oracle WebLogic Server (Admin server) and managed Oracle WebLogic Server (SOA sever).

  3. Delete the iwmysap.jar file from the Adapter lib directory:

    Oracle SOA Suite:

    <ORACLE_HOME>\Oracle_SOA1\soa\thirdparty\ApplicationAdapters\lib

    Oracle Service Bus (OSB):

    <OSB_HOME>\Oracle_OSB1\3rdparty\ApplicationAdapters\lib

  4. Delete the iwmysap.jar file from the iwafjca.rar folder.

    Oracle SOA Suite:

    <ORACLE_HOME>\Oracle_SOA1\soa\thirdparty\ApplicationAdapters\iwafjca.rar

    Oracle Service Bus (OSB):

    <OSB_HOME>\Oracle_OSB1\3rdparty\ApplicationAdapters\iwafjca.rar

  5. Copy the new iwmysap30.jar file from the following installation build directory:

    Oracle SOA Suite:

    <ORACLE_HOME>\Oracle_SOA1\soa\thirdparty\ApplicationAdapters\etc\mysap30

    Oracle Service Bus (OSB):

    <OSB_HOME>\Oracle_OSB1\3rdparty\ApplicationAdapters\etc\mysap30

    to the following directories:

    Adapter lib directory

    Oracle SOA Suite:

    <ORACLE_HOME>\Oracle_SOA1\soa\thirdparty\ApplicationAdapters\lib

    Oracle Service Bus (OSB):

    <OSB_HOME>\Oracle_OSB1\3rdparty\ApplicationAdapters\lib

    iwafjca.rar directory

    Oracle SOA Suite:

    <ORACLE_HOME>\Oracle_SOA1\soa\thirdparty\ApplicationAdapters\iwafjca.rar

    Oracle Service Bus (OSB):

    <OSB_HOME>\Oracle_OSB1\3rdparty\ApplicationAdapters\iwafjca.rar

  6. Copy the SAP JCo 3.0.5 library files (sapjco3.jar and sapjco3.dll) to the Adapter lib and Domain lib directories:

    Adapter lib directory

    Oracle SOA Suite:

    <ORACLE_HOME>\Oracle_SOA1\soa\thirdparty\ApplicationAdapters\lib

    Oracle Service Bus (OSB):

    <OSB_HOME>\Oracle_OSB1\3rdparty\ApplicationAdapters\lib

    Domain lib directory

    <ORACLE_HOME>\user_projects\domains\base_domain\lib

  7. Deploy ibse.war, iwafjca.rar, and iwafjca.war using the Oracle WebLogic Server Administration Console.

    For more information, see Chapter 2, "Installation and Configuration".

  8. Start Application Explorer.

    For more information, see Chapter 2, "Installation and Configuration".

  9. Create the following components using Application Explorer for Oracle Fusion Middleware Application Adapter for SAP R/3 (SAP JCo 3.x):

    • Adapter Targets

    • Channels

  10. Start the Oracle WebLogic Server (Admin server) and managed Oracle WebLogic Server (SOA sever).

  11. Execute all available BPEL and Mediator processes for BSE and J2CA configurations.

SAP Ports Requirement

If SAP GUI is not installed on your Windows system, then you must modify the services file and manually add the SAP ports to the bottom of this file.

The services file is a relational database file, where each line consists of a service name, port number, protocol name, and an alias.

On Windows platforms, the services file is located in the following directory:

C:\WINDOWS\system32\drivers\etc

On UNIX/Linux platforms, the services file is located in the “etc” directory of the root (“/”):

/etc/services

The following is an example of the services file with SAP ports that have been added:

sapdp00          3200/tcpsapdp01          3201/tcpsapdp02          3202/tcpsapdp03          3203/tcpsapdp04          3204/tcpsapdp05          3205/tcpsapdp06          3206/tcpsapdp07          3207/tcpsapdp08          3208/tcpsapdp09          3209/tcpsapdp10          3210/tcp . . .sapgw00          3300/tcpsapgw01          3301/tcpsapgw02          3302/tcpsapgw03          3303/tcpsapgw04          3304/tcpsapgw05          3305/tcpsapgw06          3306/tcpsapgw07          3307/tcpsapgw08          3308/tcpsapgw09          3309/tcpsapgw10          3310/tcp . . .sapdp01s                 4701/tcp       # SAP System Dispatcher Security Portsapgw01s             4801/tcp       # SAP System Gateway Security Portsapgw00s                4800/tcp       # SAP System Gateway Security Port

Microsoft Run Time DLLs

This section applies only for users that have Oracle installed on Windows platforms. SAP JCo 3.0.5 requires you to apply a Microsoft hotfix, which is described in the following section.

SAP Note 684106 contains the C++ run time DLLs for the SAP JCo 3.x library, which are a prerequisite for running the libraries. From the SAP Note 684106 page, download the r3dllinstll.zip file and save it to a directory on your system. Expand the contents of this .zip file and run either r3dllins.exe for a GUI install or r3dllcon.exe for console mode, to install the required run time libraries on your system.

SAP Note 1375494 describes the details of the Microsoft ATL libraries security patch. From the SAP Note 1375494 page, download the ATL_patch_ms_0935_1.zip file and save it to a directory on your system. Expand the contents of this .zip file and open the PDF that is provided.

Note:

The Microsoft hotfix to be applied is KB973544 in the MS09-035 security bulletin. Read the entire contents of hotfix issues KB969706 and KB973544.

  1. Download Microsoft hotfix KB973544 from the following URL:

    http://www.microsoft.com/technet/security/bulletin/MS09-035.mspx

    Note:

    Select the correct ATL library version with enhanced security. Select 32- or 64-bit depending on your system. Ensure that you select the correct system type.

    The hotfix installer specifies the directory on your system to install the library. You can delete the downloaded package after installation is successful. If you have other programs on your system that depend on these binaries, then you may also need to install the 2008 versions of the binaries as well.

    If you have an older version of Windows (for example, XP or 200x server), then you may be required to update the Windows installer before installing the hotfix. The URL for Windows XP users is:

    http://www.microsoft.com/downloads/details.aspx?FamilyID=5a58b56f-60b6-4412-95b9-54d056d6f9f4&displaylang=en

  2. Unpack and install this hotfix on your system.

  3. Install SAP JCo in the Adapter lib folder. For example:

    Oracle SOA Suite:

    <ORACLE_HOME>\Oracle_SOA1\soa\thirdparty\ApplicationAdapters\lib

    Oracle Service Bus (OSB):

    <OSB_HOME>\Oracle_OSB1\3rdparty\ApplicationAdapters\lib