InstantClient安装使用

1、

2、设置环境变量

1）NLS_lANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK（注意中间有空格，这个如果不设，toad查询中文会是乱码）

需要英文环境把上面的改为：AMERICAN_AMERICA.AL32UTF8

2）TNS_ADMIN=D:\instantclient_11_1

3）Path=D:\instantclient_11_1  追加，不要覆盖，否则jdk用不了

3、tnsnames.ora文件

oracle_XE =

  (DESCRIPTION =

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

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = XE)

    )

  )

oracle_XE_60 =

  (DESCRIPTION =

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

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = XE)

    )

  )

4、测试