oracle instantclient installation on centos

下载并安装oracle instantclient

共3个文件:

1
2
3
oracle-instantclient11.2-basic-12.2.0.1.0-1.x86_64.rpm
oracle-instantclient11.2-sqlplus-12.2.0.1.0-1.x86_64.rpm
oracle-instantclient11.2-devel-12.2.0.1.0-1.x86_64.rpm

安装:

1
yum localinstall oracle* --nogpgcheck

配置TNSNames.ora

1
mkdir /usr/lib/oracle/12.2/client64/network/admin -p

/usr/lib/oracle/12.2/client64/network/admin目录下建立TNSNames.ora连接文件

配置oracle环境变量

编辑~/.bashrc

1
2
3
4
export ORACLE_HOME=/usr/lib/oracle/12.2/client64
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export TNS_ADMIN=$ORACLE_HOME/network/admin