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
Last activity: Sep 25, 2022, 03:25 AM