1. 下载Oracle instantclient-basic-nt-12.1.0.2.0.zip, 解压缩到 D:\oracle\instantclient_12_1
2. 目录下新建两层文件夹\NETWORK\ADMIN,再在ADMIN文件夹下面建一个tnsnames.ora文件,然后向文件中添加如下内容:
orcl =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.52)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl )
)
)
3. 配置PLSQL
4. 完成, 启动PLSQL之后即可连接