配置PLSQL
Tools-Preferences-Oracle(默认)-Connection(默认), 配置Oracle Home的路径为[D:\develop\oracle\instantclient_11_2_x86], 配置OCI LIbiary路径为[D:\develop\oracle\instantclient_11_2_x86\oci.dll]
在OIC目录[D:\develop\oracle\instantclient_11_2_x86]下新建[NETWORK\ADMIN]目录, 在该目录下新建名为[tnsnames.ora]的文本文件用于配置Oracle连接信息, 内容格式如下, 可配置多条
# -----------------------------------------------------
[DEV][172.19.224.159] =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.19.224.159)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SID = orcl)
)
)
# ------------------------------------------------------
这里[[DEV][172.19.224.159]]为连接名字, 不要有汉字, [172.19.224.159]为Oracle服务器IP, 1521为Oracle端口, orcl为SID
重启PLSQL测试连接