https://blog.csdn.net/m0_74139794/article/details/137729146

https://blog.itpub.net/29990276/viewspace-2650071/

https://www.oracle.com/technetwork/topics/zlinuxsoft-087641-zhs.html
https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html
https://www.oracle.com/cn/database/technologies/releasenote-odbc-ic.html
https://www.jianshu.com/p/d0d033a95a61
https://www.oracle.com/database/technologies/instant-client/downloads.html

https://www.cnblogs.com/orachen/p/15878806.html Linux 下用unixODBC连接Oracle数据库的配置 zip安装
https://www.zealink.com/docs/uts2022/odbc/linux/oracle_odbc.html zip安装
https://www.modb.pro/db/572611

https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html
https://blog.csdn.net/2301_78312656/article/details/132008180
https://www.modb.pro/db/142583
https://blog.csdn.net/weixin_30945845/article/details/116469804

OraClient11g_home1
19.24.0.1.0

dpkg -l|grep libaio1

sudo apt-get install libaio1 -y

odbcinst -j 验证安装

ldconfig

在Ubuntu上配置Oracle ODBC可以通过以下步骤完成：

安装Oracle Instant Client和ODBC驱动。
配置Oracle Instant Client。
配置ODBC驱动。
以下是具体的命令和配置步骤：

1.安装Oracle Instant Client和ODBC驱动：

apt-get update
apt-get install -y alien libaio1 unixodbc unixodbc-dev rpm2cpio zip unzip tree odbc-postgresql

https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html

下载Oracle Instant Client和ODBC驱动的.rpm包

wget https://edelivery.oracle.com/akam/otn/linux/instantclient/11204/oracle-instantclient19.24-basic-19.24.0.0.0-1.x86_64
wget https://edelivery.oracle.com/akam/otn/linux/instantclient/11204/oracle-instantclient19.24-jdbc-19.24.0.0.0-1.x86_64.rpm
wget https://download.oracle.com/otn/linux/instantclient/11204/oracle-instantclient19.24-devel-19.24.0.0.0-1.x86_64.rpm
wget https://download.oracle.com/otn/linux/instantclient/11204/oracle-instantclient19.24-odbc-19.24.0.0.0-1.x86_64.rpm

wget https://download.oracle.com/otn/linux/instantclient/11204/

转换并安装rpm包

alien -i oracle-instantclient19.24-basic-19.24.0.0.0-1.x86_64.rpm
alien -i oracle-instantclient19.24-devel-19.24.0.0.0-1.x86_64.rpm
alien -i oracle-instantclient19.24-odbc-19.24.0.0.0-1.x86_64.rpm

alien -i oracle-instantclient19.24-jdbc-19.24.0.0.0-1.x86_64.rpm
alien -i oracle-instantclient19.24-sqlplus-19.24.0.0.0-1.x86_64.rpm

alien xx
dpkg -i xx

cp oracle-instantclient19.24-sqlplus-19.24.0.0.0-1.x86_64.rpm /
cd / && rpm2cpio oracle-instantclient19.24-sqlplus-19.24.0.0.0-1.x86_64.rpm | cpio -i –make-directories

dpkg -i oracle-instantclient19.24-basic_19.24.0.0.0-1.x86_64.deb
dpkg -i oracle-instantclient19.24-odbc_19.24.0.0.0-1.x86_64.deb

Unpacking of ‘oracle-instantclient19.24-xx-19.24.0.0.0-1.x86_64.rpm’ failed at /usr/share/perl5/Alien/Package/Rpm.pm line 168:解决方法:

cp oracle-instantclient19.24-sqlplus-19.24.0.0.0-1.x86_64.rpm /
cd /
rpm2cpio oracle-instantclient19.24-sqlplus-19.24.0.0.0-1.x86_64.rpm| cpio -i –make-directories

ln -s /usr/lib/oracle/19.24/client64/bin/sqlplus /bin/sqlplus

cd /usr/lib/oracle/19.24/client64
mkdir -p network/admin

cat >> tnsnames.ora <<EOF
ORCL_102 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.161.81.102)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCLPDB)
)
)

ORCLPDB_81_101_1521 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.161.81.101)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orclpdb)
)
)

EOF

2.配置Oracle Instant Client：

vim /etc/ld.so.conf
include /usr/lib/oracle/19.24/client64/lib/

生效

ldconfig

mkdir -p /usr/include/oracle/19.24/client64/

cp -rf /usr/include/oracle/19.24/client64/* /usr/lib/oracle/19.24/client64/include

打开/etc/profile文件
vim /etc/profile
vim ~/.bashrc

添加如下环境变量
export ORACLE_BASE=/usr/lib/oracle/19.24
export ORACLE_HOME=/usr/lib/oracle/19.24/client64
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$PATH
export TNS_ADMIN=$ORACLE_HOME/network/admin

source /etc/profile
source ~/.bashrc

4.然后，配置ODBC数据源。编辑/etc/odbc.ini文件，添加数据源配置：

vim /etc/odbcinst.ini
[Oracle]
Description=Oracle ODBC Driver
Driver=/usr/lib/oracle/19.24/client64/lib/libsqora.so.19.1

vim /etc/odbc.ini
[OracleDSN]
Description=Oracle ODBC DSN
Driver= Oracle
Servername=ORCL_102
Trace = 1
TraceFile = /var/log/oracle-odbc.log

ldd /usr/lib/oracle/19.24/client64/lib/libsqora.so.19.1

ln -s /usr/lib/x86_64-linux-gnu/libodbcinst.so /lib/x86_64-linux-gnu/libodbcinst.so.2

测试:
SQLPLUS /NOLOG
conn tss/12345@ORCL_102

isql OracleDSN tss 12345 -v

sudo wget ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.3.4.tar.gz

tar -xvzf unixODBC-2.3.4.tar.gz

cd unixODBC-2.3.4/

sudo ./configure –sysconfdir=/etc
make
sudo make install

odbcinst -j

sudo ldconfig

安装mysql odbc驱动

驱动下载地址：

MySQL :: Download Connector/ODBC

sudo tar zxvf mysql-connector-odbc-8.0.15-linux-ubuntu18.04-x86-64bit.tar.gz

cd mysql-connector-odbc-8.0.15-linux-ubuntu18.04-x86-64bit/
sudo cp bin/ /usr/local/bin
sudo cp lib/ /usr/local/lib

安装MySQL 8.0 ODBC Driver 驱动程序
// Registers the Unicode driver:
sudo myodbc-installer -a -d -n "MySQL ODBC 8.0 Driver" -t "Driver=/usr/local/lib/libmyodbc8w.so"

// Registers the ANSI driver
sudo myodbc-installer -a -d -n "MySQL ODBC 8.0" -t "Driver=/usr/local/lib/libmyodbc8a.so"

myodbc-installer -d -l

https://blog.csdn.net/m0_74139794/article/details/137729146

在Ubuntu上配置Oracle ODBC可以通过以下步骤完成：

安装Oracle Instant Client和ODBC驱动。
配置Oracle Instant Client。
配置ODBC驱动。
以下是具体的命令和配置步骤：

1.安装Oracle Instant Client和ODBC驱动：

sudo apt-get install alien libaio1 unixodbc

下载Oracle Instant Client和ODBC驱动的.rpm包

wget http://download.oracle.com/otn/linux/instantclient/122010/oracle-instantclient12.2-basic-12.2.0.1.0-1.s390x.rpm
wget http://download.oracle.com/otn/linux/instantclient/122010/oracle-instantclient12.2-odbc-12.2.0.1.0-1.s390x.rpm

wget https://download.oracle.com/otn/linux/instantclient/193000/oracle-instantclient19.3-basic-19.3.0.0.0-1.x86_64.rpm
wget https://download.oracle.com/otn/linux/instantclient/193000/oracle-instantclient19.3-odbc-19.3.0.0.0-1.x86_64.rpm

转换并安装rpm包

sudo alien -i oracle-instantclient19.3-basic-19.3.0.0.0-1.x86_64.rpm
sudo alien -i oracle-instantclient19.3-odbc-19.3.0.0.0-1.x86_64.rpm

2.配置Oracle Instant Client：

设置环境变量

echo /usr/lib/oracle/19.3/client64/lib > /etc/ld.so.conf.d/oracle-instantclient.conf
ldconfig

创建必要的目录

sudo mkdir -p /usr/include/oracle/19.3/client64/

链接头文件

sudo ln -s /usr/lib/oracle/19.3/client64/include/ /usr/include/oracle/19.3/client64/

3.配置ODBC驱动：

编辑/etc/odbcinst.ini文件，添加Oracle ODBC驱动配置：

[Oracle]
Description=Oracle ODBC Driver
Driver=/usr/lib/oracle/19.3/client64/lib/libodbcinst.so
FileUsage=1

4.然后，配置ODBC数据源。编辑/etc/odbc.ini文件，添加数据源配置：

[ORCL]
Description=Oracle ODBC DSN
Driver=Oracle
Server=myserver.example.com
User=myusername
Password=mypassword
Database=mydatabase

替换myserver.example.com、myusername、mypassword和mydatabase为您的Oracle服务器信息。

保存文件后，您可以通过isql命令测试ODBC连接：

isql -v ORCL

如果一切配置正确，您应该能够连接到Oracle数据库。

sudo wget ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.3.4.tar.gz

tar -xvzf unixODBC-2.3.4.tar.gz

cd unixODBC-2.3.4/

sudo ./configure –sysconfdir=/etc
make
sudo make install

odbcinst -j

sudo ldconfig

安装mysql odbc驱动

驱动下载地址：

MySQL :: Download Connector/ODBC

sudo tar zxvf mysql-connector-odbc-8.0.15-linux-ubuntu18.04-x86-64bit.tar.gz

cd mysql-connector-odbc-8.0.15-linux-ubuntu18.04-x86-64bit/
sudo cp bin/ /usr/local/bin
sudo cp lib/ /usr/local/lib

安装MySQL 8.0 ODBC Driver 驱动程序
// Registers the Unicode driver:
sudo myodbc-installer -a -d -n "MySQL ODBC 8.0 Driver" -t "Driver=/usr/local/lib/libmyodbc8w.so"

// Registers the ANSI driver
sudo myodbc-installer -a -d -n "MySQL ODBC 8.0" -t "Driver=/usr/local/lib/libmyodbc8a.so"

myodbc-installer -d -l

https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html

OraClient11g_home1
11.2.0.1.0

dpkg -l|grep libaio1

apt-get install libaio1 -y

odbcinst -j 验证安装

sudo ldconfig

在Ubuntu上配置Oracle ODBC可以通过以下步骤完成：

安装Oracle Instant Client和ODBC驱动。
配置Oracle Instant Client。
配置ODBC驱动。
以下是具体的命令和配置步骤：

1.安装Oracle Instant Client和ODBC驱动：

apt-get install –yes alien libaio1 unixodbc unixodbc-dev rpm2cpio

下载Oracle Instant Client和ODBC驱动的.rpm包

wget https://edelivery.oracle.com/akam/otn/linux/instantclient/11204/oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
wget https://edelivery.oracle.com/akam/otn/linux/instantclient/11204/oracle-instantclient11.2-jdbc-11.2.0.4.0-1.x86_64.rpm
wget https://download.oracle.com/otn/linux/instantclient/11204/oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm
wget https://download.oracle.com/otn/linux/instantclient/11204/oracle-instantclient11.2-odbc-11.2.0.4.0-1.x86_64.rpm
wget https://download.oracle.com/otn/linux/instantclient/11204/

转换并安装rpm包

alien -i oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
alien -i oracle-instantclient11.2-odbc-11.2.0.4.0-1.x86_64.rpm
alien -i oracle-instantclient11.2-jdbc-11.2.0.4.0-1.x86_64.rpm
alien -i oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm
alien -i oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm

Unpacking of ‘oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm’ failed at /usr/share/perl5/Alien/Package/Rpm.pm line 168:解决方法:
sudo apt-get install -y rpm2cpio

rpm2cpio /home/user/download/oracle-instantclient-sqlplus-21.14.0.0.0-1.x86_64.rpm | cpio -i –make-directories

cd /
rpm2cpio oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm | cpio -i –make-directories
rpm2cpio oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm| cpio -i –make-directories

ln -s /usr/lib/oracle/11.2/client64/bin/sqlplus /bin/sqlplus

cat >> tnsnames.ora <<EOF

oracle11g =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.xx.xx.102)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = ORCLPDB)
)
)

SQLPLUS /NOLOG

conn sss/12345@ORCL_102

isql OracleODBC-11g cs cs -v

2.配置Oracle Instant Client：

设置环境变量

echo /usr/lib/oracle/11.2/client64/lib >> /etc/ld.so.conf
ldconfig

创建必要的目录

sudo mkdir -p /usr/include/oracle/11.2/client64/

链接头文件

sudo ln -s /usr/lib/oracle/11.2/client64/include/ /usr/include/oracle/11.2/client64/

ln -s /usr/lib/oracle/11.2/client64/include/ /usr/include/oracle/11.2/client64/

cp -rf /usr/include/oracle/11.2/client64/* /usr/lib/oracle/11.2/client64/include

3.配置ODBC驱动：

编辑/etc/odbcinst.ini文件，添加Oracle ODBC驱动配置：

[Oracle]
Description=Oracle ODBC Driver
Driver=/usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1

ldd /usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1

/usr/lib/oracle/11.2/client64/lib/libodbcinst.so
FileUsage=1

配置环境

①打开/etc/ld.so.conf文件
sudo gedit /etc/ld.so.conf
添加内容：/usr/lib/oracle/11.2/client64/lib/

执行/sbin/ldconfig命令，使其生效
sudo /sbin/ldconfig

打开/etc/profile文件
sudo gedit /etc/profile

②添加如下环境变量

export ORACLE_HOME=/usr/lib/oracle/11.2/client64
export ORACLE_BASE=/usr/lib/oracle/11.2
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/lib
export PATH=$PATH:$ORACLE_HOME/bin

执行命令source /etc/profile，使其生效

4.然后，配置ODBC数据源。编辑/etc/odbc.ini文件，添加数据源配置：

[ORCL]
Description=Oracle ODBC DSN
Driver=Oracle
Server=10.xx.xx.102
User=sss
Password=12345
Database=ORCLPDB

[OracleDSN]
Description=ORACLE ODBC DSN
Driver=Oracle
SERVER=10.xx.xx.102
SERVERNAME=ORCLPDB
UID=sss
PWD=12345
PORT=1521

[OracleDSN]
Description=Oracle ODBC DSN
Driver=Oracle
ServerName=10.xx.xx.102
UserName=sss
Password=12345
Database=ORCLPDB
Port = 1521

ldd /usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1
ln -s /usr/lib/x86_64-linux-gnu/libodbcinst.so /usr/lib64/libodbcinst.so.1
ln -s /usr/lib/x86_64-linux-gnu/libodbcinst.so /usr/lib/oracle/11.2/client64/lib/libodbcinst.so.1

替换myserver.example.com、myusername、mypassword和mydatabase为您的Oracle服务器信息。

保存文件后，您可以通过isql命令测试ODBC连接：

isql oracle sss 12345 -v

isql -v ORCL

如果一切配置正确，您应该能够连接到Oracle数据库。

sudo wget ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.3.4.tar.gz

tar -xvzf unixODBC-2.3.4.tar.gz

cd unixODBC-2.3.4/

sudo ./configure –sysconfdir=/etc
make
sudo make install

odbcinst -j

sudo ldconfig

安装mysql odbc驱动

驱动下载地址：

MySQL :: Download Connector/ODBC

sudo tar zxvf mysql-connector-odbc-8.0.15-linux-ubuntu18.04-x86-64bit.tar.gz

cd mysql-connector-odbc-8.0.15-linux-ubuntu18.04-x86-64bit/
sudo cp bin/ /usr/local/bin
sudo cp lib/ /usr/local/lib

安装MySQL 8.0 ODBC Driver 驱动程序
// Registers the Unicode driver:
sudo myodbc-installer -a -d -n "MySQL ODBC 8.0 Driver" -t "Driver=/usr/local/lib/libmyodbc8w.so"

// Registers the ANSI driver
sudo myodbc-installer -a -d -n "MySQL ODBC 8.0" -t "Driver=/usr/local/lib/libmyodbc8a.so"

myodbc-installer -d -l

转载请注明：SuperIT » oracle odbc安装过程