Linux下安装ORACLE即时客户端

1、下载安装包，自己下载

instantclient-basic-linux.x64-18.3.0.0.0dbru.zip
instantclient-sqlplus-linux.x64-18.3.0.0.0dbru.zip

2、解压安装包

unzip instantclient-basic-linux.x64-18.3.0.0.0dbru.zip && unzip instantclient-sqlplus-linux.x64-18.3.0.0.0dbru.zip

3、在/instantclient_18_3/network/admin/创建tnsnames.ora

vim tnsnames.ora

test =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME =test )
    )
  )

4、在root用户环境变量中添加oracle信息

vim .bash_profile

export ORACLE_BASE=/usr/local
export ORACLE_HOME=/usr/local/instantclient_18_3
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export LD_LIBRARY_PATH=$ORACLE_HOME
export PATH=$ORACLE_HOME:$PATH

5、使配置文件生效

source .bash_profile