2018年9月，Oracle支持通過yum安裝Oracle數(shù)據(jù)庫instant client。見這里。

目前可以安裝的包如下，也可以看這里：

$ yum search instantclient Loaded plugins: langpacks, ulninfo ===================================================== N/S matched: instantclient ====================================================== oracle-instantclient12.2-basic.x86_64 : Oracle Instant Client Basic package oracle-instantclient12.2-basiclite.x86_64 : Oracle Instant Client Light package oracle-instantclient12.2-devel.x86_64 : Development headers for Instant Client. oracle-instantclient12.2-jdbc.x86_64 : Supplemental JDBC features for the Oracle Instant Client oracle-instantclient12.2-odbc.x86_64 : ODBC Instant Client. oracle-instantclient12.2-precomp.x86_64 : Precompiler support for Instant Client. oracle-instantclient12.2-sqlplus.x86_64 : SQL*Plus for Instant Client. oracle-instantclient12.2-tools.x86_64 : Tools for Oracle Instant Client oracle-instantclient18.3-basic.x86_64 : Oracle Instant Client Basic package oracle-instantclient18.3-basiclite.x86_64 : Oracle Instant Client Light package oracle-instantclient18.3-devel.x86_64 : Development headers for Instant Client. oracle-instantclient18.3-jdbc.x86_64 : Supplemental JDBC features for the Oracle Instant Client oracle-instantclient18.3-odbc.x86_64 : Oracle Instant Client ODBC oracle-instantclient18.3-precomp.x86_64 : Precompiler support for Instant Client. oracle-instantclient18.3-sqlplus.x86_64 : SQL*Plus for Instant Client. oracle-instantclient18.3-tools.x86_64 : Tools for Oracle Instant Client

要理解這些包的含義和關(guān)系，可以參考這里。簡單來說，basic是必裝的，其它如sqlplus是可選的。

在Oracle Linux上通過yum安裝最方便，無需配置repository之類。其它平臺的安裝可參見這里。

以下為示例：

$ sudo yum install -y oracle-instantclient18.3-basic oracle-instantclient18.3-sqlplus

sqlplus的目錄如下：

$ sudo find / -name sqlplus /usr/lib/oracle/18.3/client64/bin/sqlplus

需要設(shè)置以下的環(huán)境變量：

$ export CLIENT_HOME=/usr/lib/oracle/18.3/client64 $ export LD_LIBRARY_PATH=$CLIENT_HOME/lib $ export PATH=$PATH:$CLIENT_HOME/bin

然后就可以用sqlplus連接數(shù)據(jù)庫了。

總結(jié)

以上是生活随笔為你收集整理的通过yum安装Oracle instant client的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。