toad 未安装oracle客户端 配置

1. 下载toad软件和oracle的instantclient包

2. 安装完后toad后，需要将Oracle Instatnt Client解压。如，至D:/instantclient_10_2

3. 环境变量配置： "控制面板"-"系统"-"高级"-"环境变量"-"系统变量"添加

 NLS_LANG = AMERICAN_AMERICA.ZHS16GBK

TNS_ADMIN = D:\instantclient_10_2

LD_LIBRARY_PATH = D:\instantclient_10_2

SQLPATH = D:\instantclient_10_2

Path变量结尾添加D:\instantclient_10_2(注:不同的路径用半角分号;间隔)

4. 在D:\instantclient_10_2中用添加如下内容的文件,文件名为tnsnames.ora

5. 附ORA文件内容与格式

tnsnames.ora

#D:/instantclient_10_2/tnsname.ora

mydb1 =

(DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.0.47)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVER = dedicated)

      (SERVICE_NAME =ORCL)

    )

)