配置PL/SQL Developer连接远程数据库

超、凢脫俗 2023-10-17 22:42 28阅读 0赞

1.安装plsql链接工具，安装完成后点击里面的注册机进行注册，把对应的信息添加注册界面。git链接地址：[https://github.com/zhangliqingyun/jarlist/tree/master/plsql%E9%85%8D%E7%BD%AE/PLSQL%2BDeveloper10.0.1.1694%2B%E6%AD%A3%E5%BC%8F%E7%89%88%2B%E4%B8%AD%E6%96%87%E8%AF%AD%E8%A8%80%E5%8C%85%2B%E6%B3%A8%E5%86%8C%E6%9C%BA][https_github.com_zhangliqingyun_jarlist_tree_master_plsql_E9_85_8D_E7_BD_AE_PLSQL_2BDeveloper10.0.1.1694_2B_E6_AD_A3_E5_BC_8F_E7_89_88_2B_E4_B8_AD_E6_96_87_E8_AF_AD_E8_A8_80_E5_8C_85_2B_E6_B3_A8_E5_86_8C_E6_9C_BA]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1pIQU5HTElaRU5H_size_16_color_FFFFFF_t_70][]

2.找到plsql的安装目录，我的安装在C:\\Program Files (x86)\\PLSQL Developer，把instantclient配置信息拷贝到此目录下，instantclient下载链接：[https://github.com/zhangliqingyun/jarlist/tree/master/plsql%E9%85%8D%E7%BD%AE/instantclient\_12\_1][https_github.com_zhangliqingyun_jarlist_tree_master_plsql_E9_85_8D_E7_BD_AE_instantclient_12_1]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1pIQU5HTElaRU5H_size_16_color_FFFFFF_t_70 1][]

3.下载tnsnames.ora安装到本地目录下，配置环境变量，指向tnsnames.ora所在的目录：计算机-》属性-》高级系统设置-》环境变量，增加两个配置：①变量名：TNS\_ADMIN 变量值： ②变量名：NLS\_LANG，变量值：SIMPLIFIED CHINESE\_CHINA.ZHS16GBK。tnsnames.ora内容含有需要链接数据库的ip、端口、服务名，修改为自己需要链接的即可。

git下载链接：[https://github.com/zhangliqingyun/jarlist/tree/master/plsql%E9%85%8D%E7%BD%AE][https_github.com_zhangliqingyun_jarlist_tree_master_plsql_E9_85_8D_E7_BD_AE]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1pIQU5HTElaRU5H_size_16_color_FFFFFF_t_70 2][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1pIQU5HTElaRU5H_size_16_color_FFFFFF_t_70 3][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1pIQU5HTElaRU5H_size_16_color_FFFFFF_t_70 4][]

4.打开安装的plsql工具，database会出现tnsnames.ora中配置的数据库名，此时点击cancel进入plsql,开始配置instantclient所在目录，tools->oracle->connection。我的Oracle Home配置信息为：C:\\Program Files (x86)\\PLSQL Developer\\instantclient\_12\_1，OCI library配置为：C:\\Program Files (x86)\\PLSQL Developer\\instantclient\_12\_1\\oci.dll,配置完后点击apply、ok，然后关闭plsql重新打开即可。

![20190311102126995.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1pIQU5HTElaRU5H_size_16_color_FFFFFF_t_70 5][]

[https_github.com_zhangliqingyun_jarlist_tree_master_plsql_E9_85_8D_E7_BD_AE_PLSQL_2BDeveloper10.0.1.1694_2B_E6_AD_A3_E5_BC_8F_E7_89_88_2B_E4_B8_AD_E6_96_87_E8_AF_AD_E8_A8_80_E5_8C_85_2B_E6_B3_A8_E5_86_8C_E6_9C_BA]: https://github.com/zhangliqingyun/jarlist/tree/master/plsql%E9%85%8D%E7%BD%AE/PLSQL%2BDeveloper10.0.1.1694%2B%E6%AD%A3%E5%BC%8F%E7%89%88%2B%E4%B8%AD%E6%96%87%E8%AF%AD%E8%A8%80%E5%8C%85%2B%E6%B3%A8%E5%86%8C%E6%9C%BA
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1pIQU5HTElaRU5H_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20190311095459988.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1pIQU5HTElaRU5H,size_16,color_FFFFFF,t_70
[https_github.com_zhangliqingyun_jarlist_tree_master_plsql_E9_85_8D_E7_BD_AE_instantclient_12_1]: https://github.com/zhangliqingyun/jarlist/tree/master/plsql%E9%85%8D%E7%BD%AE/instantclient_12_1
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1pIQU5HTElaRU5H_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/2019031109581842.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1pIQU5HTElaRU5H,size_16,color_FFFFFF,t_70
[https_github.com_zhangliqingyun_jarlist_tree_master_plsql_E9_85_8D_E7_BD_AE]: https://github.com/zhangliqingyun/jarlist/tree/master/plsql%E9%85%8D%E7%BD%AE
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1pIQU5HTElaRU5H_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20190311100207197.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1pIQU5HTElaRU5H,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1pIQU5HTElaRU5H_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20190311100241870.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1pIQU5HTElaRU5H,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1pIQU5HTElaRU5H_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20190311100400282.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1pIQU5HTElaRU5H,size_16,color_FFFFFF,t_70
[20190311102126995.png]: https://img-blog.csdnimg.cn/20190311102126995.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1pIQU5HTElaRU5H_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20190311102336592.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L1pIQU5HTElaRU5H,size_16,color_FFFFFF,t_70