[CA Harvest SCM][ODBC Oracle Wire Protocol driver]Connection refused. Verify Host Name and Port Number

Products

• CA Harvest Software Change Manager

Issue/Introduction

We are working on upgrading to v14 in our development environment, on a new instance with a copy of existing Oracle database.

We are getting the above error, though we are able to connect to the database using sqlplus, but not during upgrade from install.sh .

 

---------------------------------------
        CA Harvest Software Change Manager
    Database Config utility
---------------------------------------
Confirm following information:

 Service Name  =  harvest
 SID  = 
 Host Name  =  
 Port Number  =  
 Driver  =  /opt/CA/odbc/lib/H_ora28.so
 SCM Database User  =  harvest

Select value to change:

  0 =  No changes
  1 =  Service Name
  2 =  SID
  3 =  Host Name
  4 =  Port Number
  5 =  Driver
  6 =  SCM Database User

Enter selection [0]:
0 [CA Harvest SCM][ODBC Oracle Wire Protocol driver]Connection refused. Verify Host Name and Port Number.
-1 [CA Harvest SCM][ODBC Oracle Wire Protocol driver][Oracle]ORA-12203: unable to connect to destination

Press the Enter key to continue.

Please let me know if you need any more details.

Thanks

 

 

Environment

Release : 14.0

Component : CA HARVEST SCM INTERFACES (CLI/API/SDK)

Cause

Hdbsetup was picking up the wrong ODBC software.  Adding the Harvest ODBC software to the beginning of the PATH variable will resolve the problem.

Resolution

We added "/opt/CA/caiptodbc" to the beginning of his PATH environment variable and made sure his tnsnames.ora file was in the $ORACLE_HOME/network/admin folder. In HDBSetup, when filling out the information for the "CO" option, only provide the TNS service name.  Leave Host Name, Port, and SID blank as those values will be retrieved from the tnsnames.ora file.

After that hdbsetup could connect with no further problems.