Pl/sql和绿色oracle客户端

• 下载oracle绿色客户端Instant Client Downloads for Microsoft Windows (x64)或百度云分享
• 配置环境变量

TNS_ADMIN=D:\noinstall\instantclient_12_2

• 创建文件D:\noinstall\instantclient_12_2\tnsnames.ora
• 设置pl\sql关于oracle路径

# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

surface =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.3)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = xe.oracle.docker)
    )
  )
ecs =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = www.ling2.cn)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = xe.oracle.docker)
    )
  )
172.16.150.75 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.150.75)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = xe)
    )
  )

139.196.179.172 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 139.196.179.172)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = vatsdb)
    )
  )

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = wangbo)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )