1.下载oracle客户端
我下载的版本是instantclient-basic-windows.x64-12.2.0.1.0.zip ,下载后解压到本地硬盘,我放到了:D:\Program Files\instantclient_12_2
2.创建tnsnames.ora文件
在根目录D:\Program Files\instantclient_12_2下新建network目录及子目录admin,在里面新建一个tnsnames.ora文件
tnsnames.ora文件内容:
orcl_db =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.104)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
orcl_db:pl/sql连接时的database,192.168.1.104:远程数据库的ip,1521:端口号,orcl:服务名。
3.下载并安装pl/sql developer
下载地址:https://www.allroundautomations.com/bodyplsqldevreg.html