Oracle Instant Client 配置

nstantclient-basic-win32-10.2.0.4.zip

1.解压到D:/instantclient_10_2

2.将D:/instantclient_10_2增加到PATH环境变量中 

3.增加以下环境变量：

TNS_ADMIN=D:/instantclient_10_2

NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK (*)

ORACLE_HOME=D:/instantclient_10_2 (*)

(*)：可选

 

4.编辑tnsnames.ora设置本地NET服务名

databasename=

  (DESCRIPTION =

    (ADDRESS_LIST =

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

    )

    (CONNECT_DATA =

      (SERVICE_NAME = SID)

    )

  )