打赏

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>

 

posted on 2017-08-22 15:14  wadeson  阅读(403)  评论(0编辑  收藏  举报