oracle客户端安装

 

下载oracle for windows客户端

instantclient-basic-win32-10.2.0.3-20061115.zip

解压instantclient-basic-win32-10.2.0.3-20061115.zip到D盘，全路径为：d:\instantclient_10_2

设置环境变量：

TNS_ADMIN=d:\instantclient_10_2

NLS_LANG=american_america.ZHS16GBK

PATH=d:\instantclient_10_2;……

 

在d:\instantclient_10_2目录下创建tnsnames.ora文件，内容范例如下

MZFX_10.194.129.35 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.194.129.35)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = mzfx)
      (SERVER = DEDICATED)
    )
  )