Sqlldr.exe Crashes While Attempting to Install an Oracle 12c Based Repository with ca-tdm-db-installer.exe

book

Article ID: 6509

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

When attempting to install the repository on Oracle 12c via ca-tdm-db-installer.exe, sqlldr.exe will crash and the repository will fail to install. This is due to a known issue with the Oracle 12c client version 12.1.0.1.

Environment

Release: TDMTDD99000-3.6-Test Data Manager-for Test Data on Demand
Component:

Resolution

Reference Oracle Doc ID 1936068.1 for full resolution details (Oracle Support account required). However, one solution is to apply the 12.1.0.2.2 Windows DB Bundle Patch (Patch 20315685) or later.

Additional Information

Before applying the Oracle client patch, make sure the ORACLE_HOME variable is set properly on the command line:

set ORACLE_HOME=\path\to\oracle\home

Also make sure that that the PATH statement is set accordingly to ensure patching is successful:

set PATH=%ORACLE_HOME%\bin;%ORACLE_HOME%\perl\bin;%ORACLE_HOME%\OPatch;%PATH%