软件(版本都是12):
plsqldev1207x64.msi
instantclient-basic-windows.x64-12.2.0.1.0.zip
下载连接:
https://www.allroundautomations.com/plsqldev.html
http://www.oracle.com/technetwork/cn/topics/winia64soft-083954-zhs.html
环境:64位win7系统
1.双击plsqldev1207x64.msi,安装plsql软件(一路下一步即可)
2.解压instantclient-basic-windows.x64-12.2.0.1.0.zip至plsql的安装文件夹下。并修改名字为instantclient_12_2,如下图:
3.在instantclient_11_2目录下新建两层文件夹network\admin,并创建tnsnames.ora文件,内容如下:
sapddb1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 远程服务器ip)(PORT = 远程服务器端口))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = sapddb)
)
)
讲解:
连接名 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.132 )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL )
)
)
3.双击PLSQL,在logon上先暂时点击cancel.如下图:
4.点击configure.如下图
5.点击preferences,并且设置oracle home和oci library的值
如下图
6.重启plsql
7.双击,登录
8.连接成功