Sample Header Ad - 728x90

Oracle ODBC client configuration missing variable

1 vote
1 answer
2234 views
I'm trying to configure an ODBC connection for an Oracle DB using unixODBC drivers. For that I followed this Oracle's guide . First, I successfully installed the ODBC client and driver. # dnf install unixODBC oracle-instantclient-sqlplus oracle-instantclient-odbc Odbcinst shows the driver defaults correctly. # odbcinst -j unixODBC 2.3.7 DRIVERS............: /etc/odbcinst.ini SYSTEM DATA SOURCES: /etc/odbc.ini FILE DATA SOURCES..: /etc/ODBCDataSources USER DATA SOURCES..: /root/.odbc.ini SQLULEN Size.......: 8 SQLLEN Size........: 8 SQLSETPOSIROW Size.: 8 Then, the guide suggests to configure ODBC with the odbc_update_ini.sh script. # find / -name "odbc_update_ini.sh" /usr/lib/oracle/21/client64/bin/odbc_update_ini.sh For that, I should input the as the first argument. Usage: odbc_update_ini.sh [ ] It happens that this script cannot find the INI file. # /usr/lib/oracle/21/client64/bin/odbc_update_ini.sh "/usr/local" *** INI file not found. Driver Manager not installed! It seems there should be an $ODBCDM_Home environment variable set, but it does not exist, and Oracle's guide does not instruct us on how to set it. # cat /usr/lib/oracle/21/client64/bin/odbc_update_ini.sh (...) # Check whether Driver Manager is installed or not if [ ! -f $ODBCDM_HOME/etc/odbc.ini -o ! -f $ODBCDM_HOME/etc/odbcinst.ini ] then echo " *** INI file not found. Driver Manager not installed!" exit fi (...) I could not find meaninful information about this issue for now. I'm at a loss now. Any idea on how to proceed?
Asked by markfree (131 rep)
Sep 16, 2022, 02:31 PM
Last activity: Sep 25, 2022, 03:25 AM