• Oracle Instant Client 安装


    oracle instant client

    是一个轻量级的oracle 客户端。可以省去安装巨大的oracle客户端软件。

    安装步骤:

    1)下载适你平台的安装包;

    2)然后解压至同一个目录,比如“instantclient”

    3)将“instantclient”目录(动态库)加入环境变量中。windows中就是加入“PATH”环境变量中,linux中就是加入LD_LIBRARY_PATH

    4)设置 NLS_LANG 环境变量,可选。它决定了与oracle交互的字符集

    5)设置 TNS_ADMIN 环境变量(值是一个路径),可选。它决定了在什么地方找到文件 tnsnames.ora 。

    6)linux下如果安装了sqlplus,则最好也将其路径加入到“PATH”环境变量,可选

     包类型简要描述:

    Basic 包含运行OCI、OCCI、JDBC-OCI所需的基本动态库,也就是所有的包都依赖于此

    Basic Lite 只适合英文环境,中文环境下有问题

    SDK 包含开发C和C++程序所需的头文件和库

    JDBC Supplement* 包含JDBC-OCI所需的jar包

    SQL*Plus* 包含oracle客户端工具sqlplus

    oracle官方对包的详细描述如下:

    Instant Client Package Description Notes
    Basic All files required to run OCI, OCCI, and JDBC-OCI applications OCI
    OCCI
    JDBC
    Basic Lite Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support (10.2 only) OCI
    OCCI
    JDBC
    JDBC Supplement* Additional support for XA, Internationalization, and RowSet operations under JDBC JDBC
    SQL*Plus* Additional libraries and executable for running SQL*Plus with Instant Client SQL*Plus 10.2
    SQL*Plus 11.2
    ODBC Supplement* Additional libraries for enabling ODBC applications with Instant Client (Not all platforms) ODBC
    SDK* Additional header files and an example makefile for developing Oracle applications with Instant Client  
    ODAC* Includes ODP.NET, Oracle Services for MTS, Oracle Providers for ASP.NET, Oracle Provider for OLE DB, and OO4O with Oracle Instant Client  


     

     注意:

    1)linux下的sqlplus、basic 的 rpm 包默认安装到路径 /usr/lib/oracle/11.2/client/ ,且不可改变。

    2)oracle 10.2.0.5 支持win7, oracle 10.2.0.4 支持 windows vista 和 windows 2008。下载前,必须要先登录oracle网站,不过还好注册是免费的。

  • 相关阅读:
    Autofac 依赖注入
    C#高级语法
    @helper
    Spiral Matrix -- LeetCode
    Best Time to Buy and Sell Stock with Cooldown -- LeetCode
    Kth Smallest Element in a Sorted Matrix -- LeetCode
    Number of Connected Components in an Undirected Graph -- LeetCode
    Super Ugly Number -- LeetCode
    Ugly Number II -- LeetCode
    Missing Ranges -- LeetCode
  • 原文地址:https://www.cnblogs.com/JesseFang/p/2255407.html
Copyright © 2020-2023  润新知