XE=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.90)(PORT = 1234))
)
(CONNECT_DATA =
(SERVICE_NAME = XE)
(SYSDBA = TRUE)
)
)
LD_LIBRARY_PATH = "C:\oracle\instantclient_18_5"
OCI_HOME = "C:\oracle\instantclient_18_5"
OCI_LIB_DIR = "C:\oracle\instantclient_18_5"
PATH = "C:\oracle\instantclient_18_5"
NLS_LANG = "AMERICAN_AMERICA.CL8MSWIN1251"
TNS_ADMIN = "C:\instantclient_12_2\network\admin"
DBQ=XE;
sudo apt update
sudo apt install unixodbc
odbcinst -j host
oracle-instantclient-basic-21.11.0.0.0-1.el8.x86_64.rpm
oracle-instantclient-odbc-21.11.0.0.0-1.el8.x86_64.rpm
oracle-instantclient-sqlplus-21.11.0.0.0-1.el8.x86_64.rpm
sudo apt install alien
sudo alien --install --scripts -v oracle-instantclient-basic-21.11.0.0.0-1.el8.x86_64.rpm
sudo alien --install --scripts -v oracle-instantclient-odbc-21.11.0.0.0-1.el8.x86_64.rpm
sudo alien --install --scripts -v oracle-instantclient-sqlplus-21.11.0.0.0-1.el8.x86_64.rpm
cd /usr/lib/oracle/21/client64/bin
./odbc_update_ini.sh /
export LD_LIBRARY_PATH=/usr/lib/oracle/21/client64/lib:$LD_LIBRARY_PATH
export PATH=/usr/lib/oracle/21/client64/bin:$PATH
export NLS_LANG=RUSSIAN_CIS.AL32UTF8
export TNS_ADMIN=/usr/lib/oracle/21/client64/lib/network/admin
source /etc/bash.bashrc
env
LD_LIBRARY_PATH=/usr/lib/oracle/21/client64/lib:
/etc/odbcinst.ini
[Oracle]
Description = Oracle ODBC driver for Oracle
Driver = /usr/lib/oracle/21/client64/lib/libsqora.so.21.1
Setup =
FileUsage =
CPTimeout =
CPReuse =
/etc/odbc.ini
[ODBC Data Sources]
TESTORA=Test Oracle Connection
# For Oracle ODBC Client
[TESTORA]
Driver = Oracle
Description = Oracle connection
HostName = <ip*.*.*.*>
Port=1251
ServerName=<!service_name>
[Default]
Driver = /usr/lib/oracle/21/client64/lib/libsqora.so.21.1