【转】oracle客户端instantclient basic配置

转载网址：http://my.oschina.net/willclick/blog/31628

 

下载地址：

http://www.oracle.com/technetwork/topics/winsoft-085727.html

 

环境变量配置：

ORACLE_HOME=C:\instantclient_11_2   

TNS_ADMIN=C:\instantclient_11_2 

NLS_LANG=SIMPLIFIED CHINESE_CHINA.AL32UTF8

 

客户端配置：

instantclient_11_2下新建如下目录：NETWORK \ ADMIN 。在admin目录下新建文件tnsnames.ora

tnsnames.ora内容如下：

ORCL =

  (DESCRIPTION =

    (ADDRESS_LIST =

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

    )

    (CONNECT_DATA =

      (SID = ORCL)

      (SERVER = DEDICATED)

    )

  )