【Linux远程连接Oracle数据库】

工具下载地址

[root@node1 instantclient_12_2]# pwd
/home/oracle/instantclient_12_2
[root@node1 instantclient_12_2]# mkdir -p network/admin
[root@node1 instantclient_12_2]# cd network/admin
[root@node1 admin]# touch tnsnames.ora 
[root@node1 admin]# vim tnsnames.ora
myorcl =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.130.100)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = mysid)
    )
  )
  [root@node1 ~]# vim ~/.bashrc     
# 加上这一段
export ORACLE_HOME=/home/oracle/instantclient_12_2    #你的客户端包的真实路径
export PATH=$ORACLE_HOME:$PATH
export TNS_ADMIN=$ORACLE_HOME/network/admin       #拼接你的新建的连接配置文件
export LD_LIBRARY_PATH=$ORACLE_HOME:$LD_LIBRARY_PATH
export NLS_LANG='american_america.AL32UTF8'             #设置编码


刷新配置文件
source ~/.bashrc