oracle 11g instantclient

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/profile

export ORACLE_HOME=/usr/oracle11g_instantclient/instantclient_11_2

export 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/bin

export 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/lib

export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/JRE
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib

export 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