首页 > 代码库 > Oracle Instant Client 配置

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 =http://www.mamicode.com/

      (SERVICE_NAME = SID)

    )

  )