舵手

1 首先下载文件  http://www.oracle.com/technology/software/tech/oci/instantclient/index.html 选在合适的版本
2 把这些文件解压中同一个目录中，然后配置tnsnames.ora和sqlnet.ora文件，如果没有的话，创建
其内容分别类似如下：
tnsnames.ora

# tnsnames.ora Network Configuration File: C:\Program Files\OracleClient\tnsnames.ora
# Generated by Oracle configuration tools.

ORCLIB =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.101)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orclib)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

3 然后在系统环境变量中加入两个变量
TNS_ADMIN        C:\Program Files\OracleClient（文件解压的目录）
NLS_LANG          SIMPLIFIED CHINESE_CHINA.ZHS16GBK（数据库字符编码，跟服务器端匹配）
还有在path环境变量中加入C:\Program Files\OracleClient（文件解压的目录）