ODBC 20101 driver 12754

Document ID : KB000112199
Last Modified Date : 27/08/2018
Show Technical Document Details
Issue:
Installing Harvest 13.0.3 from scratch on Linux 7.5 
Oracle client 64bit on Harvest broker 
Oracle 12.1.0. DB is installed on a remote server 
SQL*Plus is ok to connect from Harvest broker to remote Oracle DB 

Problem: 
Unable to run hdbsetup cr 
[CA Harvest SCM][ODBC 20101 driver]12754 
 
Environment:
 Data Source Name  =  harvest
 Service Name  =  ORACLESRV3
 SID  =
 Host Name  =
 Port Number  =  1521
 Driver  =  /opt/CA/odbc/odbc/odbc1/lib/H_ora27.so
Cause:
Wrong Service Name specified. 
Customer had two instances of Oracle DB installed, one for Oracle 12.1.0.2.0 and the other one for Oracle 12.1.0.1.0
Resolution:
Correct Service name was ORACLESRV3, the one pointing at Oracle 12.1.0.1.0