plsql developer 配置监听(不安装oracle客户端)
一、准备条件: (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 Developerinstantclient_11_2(方框一) D:Program Files (x86)PLSQL Developerinstantclient_11_2oci.dll(方框二)) 五、配置监听 打开tnsnames.ora文件,在文件内添加如下内容: # tnsnames.ora Network Configuration File: D:oracleNETWORKADMINtnsnames.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为你自己需要配置的监听内容。 (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |