instantclient_11_2远程连接Oracle安装（32位）

在安装的过程中也出现过一些错误，基本都是oci.dll和名字问题
接下来给大家一套简单清晰的教学供大家参考

1.首先先把压缩包下载

2.进行解压如下图所示

3.打开上图中的文件把途中标红的三个文件复制进去

（1）.listener.ora文件内容如下

# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SID_NAME = PLSExtProc)(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)(PROGRAM = extproc)))LISTENER =(DESCRIPTION_LIST =(DESCRIPTION =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))))

（2）sqlnet.ora文件如下所示

# sqlnet.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora# Generated by Oracle configuration tools.# This file is actually generated by netca. But if customers choose to # install "Software Only", this file wont exist and without the native # authentication, they will not be able to connect to the database on NT.SQLNET.AUTHENTICATION_SERVICES= (NTS)NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

（3.）tnsnames.ora

# tnsnames.ora Network Configuration File: D:\plsql\instantclient_11_2\network\admin\tnsnames.ora# Generated by Oracle configuration tools.LISTENER_ORCL =(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))DW =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.31.238)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = ORCL11G.US.ORACLE.COM)))ORCL-10.0.92.21 =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.92.21)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = orcl)))ORACLR_CONNECTION_DATA =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)))(CONNECT_DATA =(SID = CLRExtProc)(PRESENTATION = RO)))BDS_CLOUD =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 132.35.224.153)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = bsstest)))ORCL =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 133.224.219.113)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = bonc)))bpm_db = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.169)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) epm_db = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.93.169)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) hlj_db =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 133.224.220.65)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = boncorcl))) yeqing =(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.11.5)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = orcl))) dp = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.11.2)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ORCL1) ) ) yanshi = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.11.2)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) yanshi1 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.17.35)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = zncs_yf) ) ) yanshi2 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.64.92)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) yanshi3 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.3.57)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = testdb2) ) ) yanshi4 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.14.101)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = cloudtest) ) ) gyhlw = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.3.57)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = testdb1) ) )o11g46 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.26.46)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) OA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.3.42)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = bonchr) ) ) DB11G = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.31.237)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = DB11G) ) )

4.进行环境配置（我的电脑-------右键点击属性如下图所示）

（1）
（2.）

（3.）点击新建添加如图所示的配置


（4.）在path里面进行配置

（5.）点击编辑以后会出现如下配置

（6.）对plsql进行环境变量配置

配置完成以后依次点击确实进行保存

5.打开navicat进行配置（32位）

首先先进行最初始的配置

点击工具如下图

点击以后点击里面的选项按钮，出现以下画面，然后点击oci

OCI配置如下（根据自己的路径来选择）

（1）点击文件------点击新建连接------点击orcale

（2.）做完第一步会出现如下图
注意

上图中的填写的数据需要和下图的保持一致（下图内容在tnsnames.ora里面）

写到这里就可以连接成功了，如果有什么不对的地方还请各位多多指教

注解：如果plsql出现 ORA-12638 Credential retrieval failed，则对照下图进行操作即可

plsql的安装教程在如下网址中

转载网址：https://blog.csdn.net/qq_29175301/article/details/103578543?ops_request_misc=%257B%2522request%255Fid%2522%253A%2522160454811619725266943345%2522%252C%2522scm%2522%253A%252220140713.130102334.pc%255Fall.%2522%257D&request_id=160454811619725266943345&biz_id=0&utm_medium=distribute.pc_search_result.none-task-blog-2allfirst_rank_v2~rank_v28-5-103578543.pc_search_result_cache&utm_term=window10++instantclient11_2%E7%8E%AF%E5%A2%83%E9%85%8D&spm=1018.2118.3001.4449