Liunx 安装oracle客户端

安装Oracle数据库客户端需要root用户

  1. 将oracle-instantclient-basic-10.2.0.3-1.x86_64.rpm,
    oracle-instantclient-basiclite-10.2.0.3-1.x86_64.rpm,
    oracle-instantclient-devel-10.2.0.3-1.x86_64.rpm,
    oracle-instantclient-jdbc-10.2.0.3-1.x86_64.rpm,
    oracle-instantclient-sqlplus-10.2.0.3-1.x86_64.rpm这5个文件
    拷贝到主机某目录,如

    /home/goldemv/oracleclientsetup,
    

    并cd 到该目录

  2. 执行rpm安装命令:

    rpm -ivh oracle-instantclient-basic-10.2.0.3-1.x86_64.rpm
    rpm -ivh oracle-instantclient-basiclite-10.2.0.3-1.x86_64.rpm --nodeps
    rpm -ivh oracle-instantclient-devel-10.2.0.3-1.x86_64.rpm
    rpm -ivh oracle-instantclient-jdbc-10.2.0.3-1.x86_64.rpm
    rpm -ivh oracle-instantclient-sqlplus-10.2.0.3-1.x86_64.rpm
    
  3. 设置环境变量
    vim /etc/profile添加如下数据

    export ORACLE_HOME=/usr/lib/oracle/10.2.0.3/client64
    export ORACLE_BASE=/usr/lib/oracle/10.2.0.3
    export LD_LIBRARY_PATH=/usr/local/SQLAPI/lib:/usr/local/mysql/lib:$ORACLE_HOME/lib:$LD_LIBRARY_PATH
    export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
    export LD_LIBRARY_PATH=$ORACLE_HOME/bin:$LD_LIBRARY_PATH
    export TNS_ADMIN=$ORACLE_HOME/network/admin
    export PATH=$ORACLE_HOME:$ORACLE_HOME/bin:$PATH
    
  4. 设置生效

    source /etc/profile
    
  5. 建立oracle相关目录执行以下命令:

    cd $ORACLE_HOME
    mkdir  network
    cd network
    mkdir  admin
    cd $TNS_ADMIN
    
文章目录
,