toad安装oracle客户端过程

一、描述

使用toad连接oracle时提示找不到客户端，下面分享一下处理过程

二、过程

1、到ORACLE 网站下载instantclient客户端

https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html

2、Oracle Instatnt Client解压至指定目录（自定义）如本例中放到如下目录 

D:\program\instantclient_18_5

3、配置系统变量

NLS_LANG = AMERICAN_AMERICA.ZHS16GBK
TNS_ADMIN = D:\program\instantclient_18_5\
LD_LIBRARY_PATH = D:\program\instantclient_18_5
SQLPATH = D:\program\instantclient_18_5
ORACLE_HOME = D:\program\instantclient_18_5
Path（在变量中加入） D:\program\instantclient_18_5

5、添加配置文件sqlnet.ora和tnsnames.ora

sqlnet.ora代码如下：

# sqlnet.ora Network Configuration File: /u01/app/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora
# Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

ADR_BASE = D:\program\instantclient_18_5

tnsnames.ora代码如下：

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.233)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

6、通过toad连接OK

 三、其他

3.1 toad的下载地址

 

posted @ 2020-04-30 15:37  雪竹子  阅读(2462)  评论(0)  编辑  收藏  举报