一、准备条件:
(1)plsql developer
(2)根据需要instantclientwin32112010(32位)或者instantclient-basic-windows.x64-12.2.0.1.0(64位)
二、安装plsql developer
安装过程省略
三、instant client
将所下载的instant client解压之后放到plsql developer的安装目录下面,同时在instant client跟目录下面新建文件夹network,在network文件夹下新建admin,在admin下新建文件tnsnames.ora
四、配置plsql developer
打开plsql developer ,选择工具、首选项,如下图所示:
在红色方框1内选择instant client目录,在红色方框2内选择instant client目录下的oci.dll文件,如下图所示:
(我选择的内容为:D:\Program Files (x86)\PLSQL Developer\instantclient_11_2(方框一)
D:\Program Files (x86)\PLSQL Developer\instantclient_11_2\oci.dll(方框二))
五、配置监听
打开tnsnames.ora文件,在文件内添加如下内容:
# tnsnames.ora Network Configuration File: D:\oracle\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1 )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl )
)
)
testname =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.1 )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
其中testname为你自己需要配置的监听内容。