• centos安装oracle客户端


    使用centos远程登陆oracle服务器:

    下载需要的rpm包:

    [root@node1 oracle]# ll
    total 59872
    -rw-r--r-- 1 root root 59865008 Aug 22 14:35 oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
    -rw-r--r-- 1 root root 610222 Aug 22 11:31 oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm
    -rw-r--r-- 1 root root 828333 Aug 22 11:31 oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm

    然后安装:

    [root@node1 oracle]# rpm -ivh oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
    Preparing... ########################################### [100%]
    1:oracle-instantclient11.########################################### [100%]
    [root@node1 oracle]# rpm -ivh oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm
    Preparing... ########################################### [100%]
    1:oracle-instantclient11.########################################### [100%]
    [root@node1 oracle]# rpm -ivh oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm
    Preparing... ########################################### [100%]
    1:oracle-instantclient11.########################################### [100%]

    然后配置环境变量:

    [root@node1 ~]# cat .bash_profile
    # .bash_profile

    # Get the aliases and functions
    if [ -f ~/.bashrc ]; then
    . ~/.bashrc
    fi

    # User specific environment and startup programs

    export ORACLE_BASE=/usr/lib/oracle/11.2
    export ORACLE_HOME=/usr/lib/oracle/11.2/client64/
    export LD_LIBRARY_PATH=$ORACLE_HOME/lib

    PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

    测试是否能够登录oracle:

    [root@node1 ~]# sqlplus system/redhat@192.168.223.138:1521/oracle.test

    SQL*Plus: Release 11.2.0.4.0 Production on Tue Aug 22 15:13:42 2017

    Copyright (c) 1982, 2013, Oracle. All rights reserved.


    Connected to:
    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options

    SQL>

  • 相关阅读:
    MySQL数据库操作(4)表约束
    通过C学Python(3)列表的常用方法
    MySQL数据库操作(2)基本操作
    通过C学Python(1)关于语言、数值类型和变量
    通过C学Python(2)序列类型
    MySQL数据库操作(1)用户与权限
    一个文章单词分析作业
    pyCharm的几个配置
    MySQL数据库操作(3)表结构操作
    shell脚本中的for循环和while循环
  • 原文地址:https://www.cnblogs.com/jsonhc/p/7411732.html
Copyright © 2020-2023  润新知