Running OIM Bulk Load Utility Remotely

Description: This post will show you how to install the Oracle Database client. An Oracle database client is needed to run the Oracle Identity Manager Bulk Load Utility when the Oracle Database and Oracle Identity Manager application server are on separate machines.

Download Link: Oracle Database 11g Release 2 Client (11.2.0.1.0) for Linux x86-64
File Name: linux.x64_11gR2_client.zip


1. Extract the "linux.x64_11gR2_client.zip" file. A "client" directory should be created.

2. Modify the "client/stage/cvu/cvu_prereq.xml" file. For installing on an OEL6 environment, I had to modify the OEL4 section by changing all the i386 packages into i686 in order to get pass the prerequisites check during installation. Below is an example of what the OEL4 section should look like.

        <OPERATING_SYSTEM RELEASE="OEL4">
            <VERSION VALUE="4"/>
            <ARCHITECTURE VALUE="x86_64"/>
            <NAME VALUE="Linux"/>
            <VENDOR VALUE="enterprise"/>
            <KERNEL_VER VALUE="2.6.9"/>
            <KERNEL>
                <PROPERTY NAME="semmsl" VALUE="250" SEVERITY="IGNORABLE"/>
                <PROPERTY NAME="semmns" VALUE="32000" SEVERITY="IGNORABLE"/>
                <PROPERTY NAME="semopm" VALUE="100" SEVERITY="IGNORABLE"/>
                <PROPERTY NAME="semmni" VALUE="128" SEVERITY="IGNORABLE"/>
                <PROPERTY NAME="shmmax" VALUE="536870912" SEVERITY="IGNORABLE"/>
                <PROPERTY NAME="shmmni" VALUE="4096" SEVERITY="IGNORABLE"/>
                <PROPERTY NAME="shmall" VALUE="2097152" SEVERITY="IGNORABLE"/>
                <PROPERTY NAME="file-max" VALUE="65536" SEVERITY="IGNORABLE"/>
                <PROPERTY NAME="ip_local_port_range" ATLEAST="9000"
                     ATMOST="65500" SEVERITY="IGNORABLE"/>
                <PROPERTY NAME="rmem_default" VALUE="262144" SEVERITY="IGNORABLE"/>
                <PROPERTY NAME="rmem_max" VALUE="4194304" SEVERITY="IGNORABLE"/>
                <PROPERTY NAME="wmem_default" VALUE="262144" SEVERITY="IGNORABLE"/>
                <PROPERTY NAME="wmem_max" VALUE="262144" SEVERITY="IGNORABLE"/>
            </KERNEL>

            <PACKAGES>
                <PACKAGE NAME="make" VALUE="3.80" SEVERITY="IGNORABLE"/>
                <PACKAGE NAME="binutils" VALUE="2.15.92.0.2" SEVERITY="IGNORABLE"/>
                <PACKAGE NAME="gcc" VALUE="3.4.6" SEVERITY="IGNORABLE"/>
                <PACKAGE NAME="libaio" VALUE="0.3.105" SEVERITY="IGNORABLE" ARCHITECTURE="i686"/>
                <PACKAGE NAME="libaio" VALUE="0.3.105" SEVERITY="IGNORABLE" ARCHITECTURE="x86_64"/>
                <PACKAGE NAME="libaio-devel" VALUE="0.3.105" SEVERITY="IGNORABLE" ARCHITECTURE="i686"/>
                <PACKAGE NAME="libaio-devel" VALUE="0.3.105" SEVERITY="IGNORABLE" ARCHITECTURE="x86_64"/>
                <PACKAGE NAME="libstdc++" VALUE="3.4.6" SEVERITY="IGNORABLE" ARCHITECTURE="i686"/>
                <PACKAGE NAME="libstdc++" VALUE="3.4.6" SEVERITY="IGNORABLE" ARCHITECTURE="x86_64"/>
                <PACKAGE NAME="elfutils-libelf-devel" VALUE="0.97" SEVERITY="IGNORABLE"/>
                <PACKAGE NAME="sysstat" VALUE="5.0.5" SEVERITY="IGNORABLE"/>
                <PACKAGE NAME="libgcc" VALUE="3.4.6" SEVERITY="IGNORABLE" ARCHITECTURE="i686"/>
                <PACKAGE NAME="libgcc" VALUE="3.4.6" SEVERITY="IGNORABLE" ARCHITECTURE="x86_64"/>
                <PACKAGE NAME="libstdc++-devel" VALUE="3.4.6" SEVERITY="IGNORABLE" ARCHITECTURE="x86_64"/>
                <PACKAGE NAME="unixODBC" VALUE="2.2.11" SEVERITY="IGNORABLE" ARCHITECTURE="i686"/>
                <PACKAGE NAME="unixODBC" VALUE="2.2.11" SEVERITY="IGNORABLE" ARCHITECTURE="x86_64"/>
                <PACKAGE NAME="unixODBC-devel" VALUE="2.2.11" SEVERITY="IGNORABLE" ARCHITECTURE="i686"/>
                    <PACKAGE NAME="unixODBC-devel" VALUE="2.2.11" SEVERITY="IGNORABLE" ARCHITECTURE="x86_64"/>
                <PACKAGE NAME="elfutils-libelf" VALUE="0.97" SEVERITY="IGNORABLE" ARCHITECTURE="x86_64"/>
                <PACKAGE NAME="glibc-common" VALUE="2.3.4" SEVERITY="IGNORABLE"/>
                <PACKAGE NAME="glibc-devel" VALUE="2.3.4" SEVERITY="IGNORABLE" ARCHITECTURE="x86_64"/>
                <PACKAGE NAME="gcc-c++" VALUE="3.4.6" SEVERITY="IGNORABLE"/>
                <PACKAGE NAME="compat-libstdc++-33" VALUE="3.2.3" SEVERITY="IGNORABLE" ARCHITECTURE="i686"/>
                <PACKAGE NAME="compat-libstdc++-33" VALUE="3.2.3" SEVERITY="IGNORABLE" ARCHITECTURE="x86_64"/>
                    <PACKAGE NAME="glibc" VALUE="2.3.4-2.41" SEVERITY="CRITICAL" ARCHITECTURE="i686"/>
                    <PACKAGE NAME="glibc" VALUE="2.3.4-2.41" SEVERITY="CRITICAL" ARCHITECTURE="x86_64"/>
                <PACKAGE NAME="expat" VALUE="1.95.7" SEVERITY="IGNORABLE" ARCHITECTURE="x86_64"/>
            </PACKAGES>

            <SYSTEM_FILES>
                <DHCP FILENAME="/etc/network_sysconfig"/>
            </SYSTEM_FILES>
        </OPERATING_SYSTEM>

3. Execute the "client/runInstaller" script to start the installer. Below are screen shots of the installation process.

Select Administrator

Oracle Base = /home/oracle/Oracle
Software Location = /home/oracle/Oracle/product/11.2.0/dbhome_1

Ensure all prerequisite checks passed

Save response file

Execute "/home/oracle/Oracle/product/11.2.0/dbhome_1/root.sh" script

Message when executing root.sh script

4. Validate by running the OIM Bulk Load Utility script located in "$MW_HOME/Oracle_IDM1/server/db/oim/oracle/Utilities/oimbulkload/script/oim_blkld.sh" script. When prompted to enter ORACLE_HOME, enter the Software Location (specified in Step 3 of the Oracle Database client installation) of the Oracle DB client.