PLSQL连接远程数据库

一、下载安装plsql developer

直接百度

二、下载instantclient，版本可以是11,12等

三、配置文件

上面两个位置配置，分别配置instantclient文件目录和oci库文件目录

2. 配置环境变量

NLS_LANG
SIMPLIFIED CHINESE_CHINA.ZHS16GBK

path目录添加
D:\instantclient_11_2

TNS_ADMIN
D:\instantclient_11_2

3. 配置tnsnames.ora文件
   上面的文件位置直接放置到D:\instantclient_11_2目录下即可；下面配置了三个数据库，有工作的和学习的，登录的时候可以自由选择

# tnsnames.ora Network Configuration File: ‪D:\instantclient_12_1\admin\network\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.44)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )
mub2b =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.29.158)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = mub2b)
    )
  )
B2TDB =
  (DESCRIPTION =
    (ADDRESS=(PROTOCOL=TCP)(HOST=172.28.176.175)(PORT=1531))
    (ADDRESS=(PROTOCOL=TCP)(HOST=172.28.176.176)(PORT=1531))
	(LOAD_BALANCE=OFF)
	(FAILOVER=ON)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = B2TDB)
    )
  )
EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )