oracle客户端安装

1.下载安装包

Oracle Instant Client Downloads

下载  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

2.上传以上三个压缩包到服务器新建文件夹oracle文件夹下

3.解压压缩包

按顺序依次解压

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

会生成instantclient_12_2”目录，basic和sqlplus会在其根下，而sdk会在其下生成“sdk”目录

4.在其下建立目录/network/admin

mkdir -p network/admin

5.创建文件：tnsnames.ora（vi tnsnames.ora)”,并添加

ORCL =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.XX.XX)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = DB)

    )

  )

6.配置环境变量

vim /etc/profile

export ORACLE_HOME=/data/liuzc/oracle/instantclient_11_2

export PATH=$ORACLE_HOME/bin:$PATH

export TNS_ADMIN=$ORACLE_HOME/network/admin

export LD_LIBRARY_PATH=$ORACLE_HOME:$LD_LIBRARY_PATH

export NLS_LANG="SIMPLIFIED CHINESE_CHINA.AL32UTF8"

source /etc/profile （使环境变量生效）

7.执行sqlplus会发现报错，缺少依赖

sqlplus: error while loading shared libraries: libclntsh.so.12.1: cannot open shared object file: No such file or directory

解决方案：

find / -name libclntsh.so.*

要把这个路径加载上

编辑/etc/ld.so.conf

Vim /etc/ld.so.conf

在最后一行输入获取的路径

最后需要#ldconfig一下

8.执行命令进入客户端

sqlplus userName/password@//host:port/SID