Linux下安装绿色版oracle客户端

第一步:上传以下所需安装包到相对应目录
oracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64.rpm
oracle-instantclient11.2-devel-11.2.0.1.0-1.x86_64.rpm
oracle-instantclient11.2-sqlplus-11.2.0.1.0-1.x86_64.rpm

第二步:进行rpm包安装
图片描述

第三步:进入到相对应目录(该rpm包安装完后会把东西放到下面红框目录下)

cd /usr/lib/oracle/11.2/client64
然后新建目录mkdir –P network/admin
再从原有数据库服务端拷贝listener.ora,sqlnet.ora,tnsnames.ora三个文件到这个目录(/usr/lib/oracle/11.2/client64/network/admin)下。
图片描述

第四步:配置环境变量
注意:想让哪个用户能连,就配置哪个用户家目录下的.bashrc文件
比如咱们配置boco用户的。那就
cd /home/boco
vi .bashrc
然后增加以下语句:
export LD_LIBRARY_PATH=/usr/local/lib:/usr/lib/oracle/11.2/client64/lib
export ORACLE_HOME=/usr/lib/oracle/11.2/client64
export TNS_ADMIN=/usr/lib/oracle/11.2/client64/network/admin
export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
最后使用以下命令使配置的环境变量生效
source /home/boco/.bashrc

第五步:配置tnsnames.ora文件
vi tnsnames.ora文件
增加如下红框配置:
图片描述

第六步:测试连接
图片描述

  • 1
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
包涵以下版本的87个安装包: bind-libs-9.9.4-61.el7.x86_64.rpm bind-libs-lite-9.9.4-61.el7.x86_64.rpm bind-license-9.9.4-61.el7.noarch.rpm bind-utils-9.9.4-61.el7.x86_64.rpm compat-libcap1-1.10-7.el7.x86_64.rpm compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm cpp-4.8.5-28.0.1.el7_5.1.x86_64.rpm elfutils-libelf-devel-0.160-1.el7.i686.rpm elfutils-libelf-devel-0.160-1.el7.x86_64.rpm elfutils-libelf-devel-static-0.160-1.el7.i686.rpm elfutils-libelf-devel-static-0.160-1.el7.x86_64.rpm gcc-4.8.5-28.0.1.el7_5.1.x86_64.rpm gcc-c++-4.8.5-28.0.1.el7_5.1.x86_64.rpm glibc-2.17-222.el7.x86_64.rpm glibc-2.17-78.el7.i686.rpm glibc-2.17-78.el7.x86_64.rpm glibc-common-2.17-222.el7.x86_64.rpm glibc-devel-2.17-222.el7.x86_64.rpm glibc-devel-2.17-78.el7.i686.rpm glibc-devel-2.17-78.el7.x86_64.rpm glibc-headers-2.17-222.el7.x86_64.rpm gssproxy-0.7.0-17.el7.x86_64.rpm kernel-container-3.10.0-0.0.0.2.el7.x86_64.rpm kernel-headers-3.10.0-862.9.1.el7.x86_64.rpm keyutils-1.5.8-3.el7.x86_64.rpm ksh-20120801-137.0.1.el7.x86_64.rpm libaio-devel-0.3.109-13.el7.x86_64.rpm libbasicobjects-0.1.1-29.el7.x86_64.rpm libcollection-0.7.0-29.el7.x86_64.rpm libdmx-1.1.3-3.el7.x86_64.rpm libevent-2.0.21-4.el7.x86_64.rpm libgcc-4.8.5-28.0.1.el7_5.1.x86_64.rpm libgomp-4.8.5-28.0.1.el7_5.1.x86_64.rpm libICE-1.0.9-9.el7.x86_64.rpm libini_config-1.3.1-29.el7.x86_64.rpm libmpc-1.0.1-3.el7.x86_64.rpm libnfsidmap-0.25-19.el7.x86_64.rpm libpath_utils-0.2.1-29.el7.x86_64.rpm libref_array-0.1.5-29.el7.x86_64.rpm libselinux-2.5-12.0.1.el7.x86_64.rpm libselinux-python-2.5-12.0.1.el7.x86_64.rpm libselinux-utils-2.5-12.0.1.el7.x86_64.rpm libsepol-2.5-8.1.el7.x86_64.rpm libSM-1.2.2-2.el7.x86_64.rpm libstdc++-4.8.5-28.0.1.el7_5.1.x86_64.rpm libstdc++-devel-4.8.5-28.0.1.el7_5.1.x86_64.rpm libtirpc-0.2.4-0.10.el7.x86_64.rpm libverto-libevent-0.2.5-4.el7.x86_64.rpm libX11-1.6.5-1.el7.x86_64.rpm libX11-common-1.6.5-1.el7.noarch.rpm libXau-1.0.8-2.1.el7.x86_64.rpm libxcb-1.12-1.el7.x86_64.rpm libXext-1.3.3-3.el7.x86_64.rpm libXi-1.7.9-1.el7.x86_64.rpm libXinerama-1.1.3-2.1.el7.x86_64.rpm libXmu-1.1.2-2.el7.x86_64.rpm libXrandr-1.5.1-2.el7.x86_64.rpm libXrender-0.9.10-1.el7.x86_64.rpm libXt-1.1.5-3.el7.x86_64.rpm libXtst-1.2.3-1.el7.x86_64.rpm libXv-1.0.11-1.el7.x86_64.rpm libXxf86dga-1.1.4-2.1.el7.x86_64.rpm libXxf86misc-1.0.3-7.1.el7.x86_64.rpm libXxf86vm-1.1.4-1.el7.x86_64.rpm lm_sensors-libs-3.4.0-4.20160601gitf9185e5.el7.x86_64.rpm mailx-12.5-19.el7.x86_64.rpm mpfr-3.1.1-4.el7.x86_64.rpm net-tools-2.0-0.22.20131004git.el7.x86_64.rpm nfs-utils-1.3.0-0.54.0.1.el7.x86_64.rpm oracle-rdbms-server-11gR2-preinstall-1.0-5.el7.x86_64.rpm policycoreutils-2.5-22.0.1.el7.x86_64.rpm psmisc-22.20-15.el7.x86_64.rpm quota-4.01-17.el7.x86_64.rpm quota-nls-4.01-17.el7.noarch.rpm rpcbind-0.2.0-44.el7.x86_64.rpm selinux-policy-3.13.1-192.0.3.el7_5.4.noarch.rpm selinux-policy-targeted-3.13.1-192.0.3.el7_5.4.noarch.rpm smartmontools-6.5-1.el7.x86_64.rpm sysstat-10.1.5-13.el7.x86_64.rpm tcp_wrappers-7.6-77.el7.x86_64.rpm unixODBC-2.3.1-10.el7.i686.rpm unixODBC-2.3.1-10.el7.x86_64.rpm unixODBC-devel-2.3.1-10.el7.i686.rpm unixODBC-devel-2.3.1-10.el7.x86_64.rpm unzip-6.0-19.el7.x86_64.rpm xorg-x11-utils-7.5-22.el7.x86_64.rpm xorg-x11-xauth-1.0.9-1.el7.x86_64.rpm 安装方法直接输入: rpm -ivh *.rpm --nodeps --force
1)rpm格式包安装配置 1.1 下载以rpm后缀名的包,以11.2.0.4.0 版本为例,其中基础包basic、sql*plus、devel包建议默认下载,其他包视情况而定: oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm --基础包,为了运行OCI、OCCI、JDBC-OCI 这几个应用程序; oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm --补充包/文件,是为了运行sql*plus的即时客户端oracle-instantclient11.2-odbc-11.2.0.4.0-1.x86_64.rpm --补充包/文件,为运行ODBC环境附加库; oracle-instantclient11.2-jdbc-11.2.0.4.0-1.x86_64.rpm --补充JDBC下的XA、国际标准、行集操作; oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm --包含头文件和示例文件,为开发Oracle应用程序的即时客户端; 1.2 使用rpm -ivh [包名] 进行安装, 如:rpm -ivh oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm 安装的文件默认放在两个位置: 头文件:/usr/include/oracle/11.2/client64/ 下,如果在使用时报错找不到头文件,记得看路径是否是这个。 包文件:/usr/lib/oracle/11.2/client64/ 下,包含{bin、lib}两个文件夹; 1.3 创建文件夹: #mkdir -p /usr/lib/oracle/11.2/client64/network/admin/ 1.4 创建监听文件,并添加内容 #vim /usr/lib/oracle/11.2/client64/network/admin/tnsnames.ora ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = *IP*)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = *SID*) ) ) 1.5 配置环境变量 #vim ~/.bashrc --根目录下为全局使用,为限制用户权限,可只修改某一用户的环境变量 export ORACLE_HOME=/usr/lib/oracle/11.2/client64 export TNS_ADMIN=$ORACLE_HOME/network/admin export NLS_LANG='simplified chinese_china'.ZHS16GBK export LD_LIBRARY_PATH=$ORACLE_HOME/lib export PATH=$ORACLE_HOME/bin:$PATH 1.6 使配置完的环境变量生效 #source ~/.bashrc 1.7 连接数据库测试 #sqlplus /nolog SQL>conn scott/tiger@orcl 2)zip格式包安装配置(只以basic包做为示例) 2.1 下载包:oracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64.zip 2.2 将包文件解压到指定目录下: #unzip oracle-instantclient11.2-basic-11.2.0.1.0-1.x86_64.zip 解压后的文件存放路径可以自行设定,但是与后面环境变量设定有关,本文设定/home/orcl/ 下。 头文件目录:/home/orcl/sdk/include/ 库文件目录:/home/orcl/instantclient_11_2/ 2.3 创建 network/admin/ 目录:mkdir -p /home/orcl/instantclient_11_2/network/admin/ 2.4 创建监听文件 tnsnames.ora #vim /home/orcl/instantclient_11_2/network/admin/tnsnames.ora ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.232.131)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) 2.5 配置环境变量 #vim ~/.bashrc export ORACLE_HOME=/home/orcl/instantclient_11_2 export TNS_ADMIN=$ORACLE_HOME/network/adminexport export NLS_LANG='simplified chinese_china'.ZHS16GBKexport export LD_LIBRARY_PATH=$ORACLE_HOME export PATH=$ORACLE_HOME:$PATH 2.6 配置完成后,将环境变量生效 #source ~/.bashrc 2.7 测试连接
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值