HDBSetup database configuration failure - Data source name not found
Article ID: 437407
Updated On:
Products
Issue/Introduction
After providing the required information to hdbsetup, it complained it could not find the data source name, default driver or the specified connect identifier
0 [unixODBC][Driver Manager]Data source name not found and no default driver specified
DBMS administrator username [system]:
xxxxxx DSN: harvest
Press the Enter key to continue [Y/N]
When I then tried to test the connection, I got the message
Enter password for DBMS Administrator XXXX:
*****
12154 [Oracle][ODBC][Ora]ORA-12154: TNS: Could not resolve the connect identifier specified
Press the Enter key to continue
Environment
Harvest Software Change Manager v14.5.0
Linux and Unix OS
Oracle v19c
Cause
The /opt/CA/odbc/odbc.ini file was missing the following lines, causing hdbsetup to fail in trying to create the ODBC data source entry in odbc.ini.
[ODBC]
[ODBC Data Sources]
Resolution
If you have other Harvest environments with a working connection to the database, review the /opt/CA/odbc/odbc.ini on those servers to compare with the problematic server. If needed, add the following two lines to the /opt/CA/odbc/odbc.ini file on the problematic server.
[ODBC]
[ODBC Data Sources]
If this does not resolve the problem, an EFix is available that allows HDBSetup to work successfully even if those lines are missing. For this Efix, please contact support.
Additional Information
If you encounter these errors, please contact Support for the same EFix.
See also
HDBSetup error [unixODBC][Driver Manager]Data source name not found and no default driver specified
Can't Open lib '/export/home/oracle/product/19.3.0_client32/lib/libsqora.so.19.1' : file not found
Feedback
