os: centos 7.4
db: oracle 11.2.0.4 instantclient

下載 oracle 11g instantclient

nodepg11 節點需要安裝 oracle 11g instantclient，下載地址
https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html

instantclient-basic-linux.x64-11.2.0.4.0.zip
instantclient-sdk-linux.x64-11.2.0.4.0.zip
instantclient-sqlplus-linux.x64-11.2.0.4.0.zip

常用的上面三個就足夠了。

安裝 oracle 11g instantclient

只需要解壓，配置環境變量即可

# mkdir -p /usr/oracle11g_instantclient # cd /opt # rz # unzip ./instantclient-basic-linux.x64-11.2.0.4.0.zip -d /usr/oracle11g_instantclient/ # unzip ./instantclient-sdk-linux.x64-11.2.0.4.0.zip -d /usr/oracle11g_instantclient/ # unzip ./instantclient-sqlplus-linux.x64-11.2.0.4.0.zip -d /usr/oracle11g_instantclient/# cd /usr/oracle11g_instantclient/instantclient_11_2 # ln -s libclntsh.so.11.1 libclntsh.so # chown -R postgres:postgres /usr/oracle11g_instantclient # vi /etc/profileexport ORACLE_HOME=/usr/oracle11g_instantclient/instantclient_11_2export NLS_LANG=AMERICAN_AMERICA.AL32UTF8 export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'export PATH=.:${PATH}:$HOME/bin:$ORACLE_HOME:$ORACLE_HOME/bin export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin export PATH=${PATH}:$ORACLE_BASE/common/oracle/binexport LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME:$ORACLE_HOME/lib export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/libexport CLASSPATH=${CLASSPATH}:$ORACLE_HOME/JRE export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlibexport TEMP=/tmp export TMP=/tmp export TMPDIR=/tmp # vi /etc/ld.so.conf.d/oracle.conf /usr/oracle11g_instantclient/instantclient_11_2 /usr/oracle11g_instantclient/instantclient_11_2/lib# ldconfig

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

總結

以上是生活随笔為你收集整理的oracle 11g instantclient的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。