配置 oracle客户端+PL/SQL 连接oracle数据库

桃扇骨 2021-09-15 22:22 410阅读 0赞

### 前言 ###

我在VMware中安装了oracle数据库服务端，模拟远程连接oracle服务端，  
    如何安装oracle服务端参考：[https://blog.csdn.net/idomyway/article/details/77418827][https_blog.csdn.net_idomyway_article_details_77418827]  
    主机和VMware虚拟机通讯参考：[https://blog.csdn.net/idomyway/article/details/81208994][https_blog.csdn.net_idomyway_article_details_81208994]

### 工具下载 ###

包含了文件中包含了instantclient-basic-win32-11.2.0.1.0.rar，PLSQL+Developer+10.0.2.1697+中文绿色注册版.rar  
    连接地址：[https://download.csdn.net/download/idomyway/10564285][https_download.csdn.net_download_idomyway_10564285]

### 环境配置 ###

**1、**在D盘D:\\Program Files新建目录oracle-plsql  
    **2、**将instantclient-basic-win32-11.2.0.1.0和PLSQL+Developer+10.0.2.1697+中文绿色注册版解压在同一个目录下

![这里写图片描述][70]

**3、**打开PLSQL+Developer+10.0.2.1697+中文绿色注册版下的plsqldev.exe，选项栏 工具-》首选项

![这里写图片描述][70 1]

4、在oracle主目录名：复制instantclient-basic-win32-11.2.0.1.0的目录

D:\Program Files\oracle-plsql\instantclient-basic-win32-11.2.0.1.0\instantclient_11_2

5、在OCI库：复制指向oci.dll的路径

D:\Program Files\oracle-plsql\instantclient-basic-win32-11.2.0.1.0\instantclient_11_2\oci.dll

![这里写图片描述][70 2]

6、重启

在`D:\Program Files\oracle-plsql\instantclient-basic-win32-11.2.0.1.0\instantclient_11_2\NETWORK\ADMIN`下的tnsnames.ora中添加访问配置

[https_blog.csdn.net_idomyway_article_details_77418827]: https://blog.csdn.net/idomyway/article/details/77418827
[https_blog.csdn.net_idomyway_article_details_81208994]: https://blog.csdn.net/idomyway/article/details/81208994
[https_download.csdn.net_download_idomyway_10564285]: https://download.csdn.net/download/idomyway/10564285
[70]: /images/20210726/16b0af9df40c42d8aeebe79d10f62a57.png
[70 1]: /images/20210726/8b3c410200e244c6bdb8ba993a259403.png
[70 2]: /images/20210726/eddb5795d855416d98f7a6bb8d180e90.png