CanleiSky Blog

第一步，下载Instant Client for Microsoft Windows (32-bit)
        下载地址：http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html
        下载和数据库版本一至的Instant Client，本机是10g r2所以选择Version 10.2.0.4

安装：
        1.直接解压到一个目录，本机是：D:\WareSoft\instantclient_10_2
        2.设置环境变量
            在PATH变量后追回D:\WareSoft\instantclient_10_2
            新建TNS_ADMIN变量，值为：D:\WareSoft\instantclient_10_2
            新建LD_LIBRARY_PATH变量，值为：D:\WareSoft\instantclient_10_2
           新建NLS_LANG变量(连接字符集，本机是UTF-8)，值为：SIMPLIFIED CHINESE_CHINA.AL32UTF8
3.创建链接配置文件
           新建文件，命名为：tnsnames.ora，放到D:\WareSoft\instantclient_10_2下，内容示例：
192.168.1.105 =
    (DESCRIPTION =
        (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.105)(PORT = 1521))
    )
    (CONNECT_DATA =
        (SERVICE_NAME = XE)
)
)
内容说明：
192.168.1.105(链接别名) =
    (DESCRIPTION =
        (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.105(服务器IP))(PORT = 1521(服务端口)))
    )
    (CONNECT_DATA =
        (SERVICE_NAME = XE(服务端口，rpm版的为XE，tar版的是ORCL)
    )
)