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_5LD_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的下载地址

 

toad安装oracle客户端过程

上一篇:mac下环境变量中配置jdk和mysql,解决每次都要source ~/.bash_profile


下一篇:jmeter-链接mysql数据库