centos7 Oracle客户端安装及cx_Oracle安装全过程

最新推荐文章于 2025-06-27 09:52:31 发布

原创

最新推荐文章于 2025-06-27 09:52:31 发布 · 1.8k 阅读

0 ·

CC 4.0 BY-SA版权

本文详细介绍了在CentOS 7环境下安装Oracle 11g客户端和配置cx_Oracle的步骤，包括环境配置、依赖安装、安装包解压、配置响应文件、执行安装、设置环境变量、配置TNS文件、测试连接以及安装Python的cx_Oracle模块。

-----------------------------------------------------------------------------------------------------------------------
********************
                                *
Oracle客户端安装   *
                                *
********************
系统环境：CentOS Linux release 7.3.1611 (Core)
网站：https://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-linx8664soft-100572.html

wget http://download.oracle.com/otn/linux/oracle11g/R2/linux.x64_11gR2_client.zip

Oracle Client Version: linux.x64_11gR2_client.zip

一、运行安装依赖及用户配置脚本

#!/bin/bash

VERSION=11.2.0.4
ROOT_DIR=/u01

##############################################################################
function BAK_REV()
{
   if [ -e $1.org ]
   then
   /bin/cp $1.org $1
   else
   /bin/cp $1 $1.org
   fi
}
##############################################################################

yum install -y binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc-devel glibc-headers ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat unixODBC

unixODBC-devel compat-libcap1.x86_64
groupadd -g 1100 oinstall &>/dev/null
groupadd -g 1200 dba &>/dev/null
groupadd -g 1300 oper &>/dev/null

useradd -u 777 -g oinstall -G dba,oper oracle &>/dev/null
echo "oracle"|passwd --stdin oracle &>/dev/null

cat >> /home/oracle/.bash_profile <<EOF
export TMP=/tmp
export TMPDIR=\$TMP
export ORACLE_SID=$INSTANCE
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/$VERSION/dbhome_1
export PATH=\$ORACLE_HOME/bin:/usr/bin:\$PATH
export LD_LIBRARY_PATH=\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
#export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
export NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"
umask 022

EOF
echo "profile done"

mkdir $ROOT_DIR/app/oracle -p
chown -R oracle:oinstall $ROOT_DIR/app
chmod -R 755 $ROOT_DIR/app
mkdir -p /opt/app/oraInventory
chown -R oracle:oinstall /opt/app/oraInventory
chmod -R 755 /opt/app/oraInventory

echo "directory done"
echo "system will reboot";
sleep 10

二、安装包解压
    1. 更改安装包属主
        [root@823ee0f64c26 ~]#chown oracle:oinstall linux.x64_11gR2_client.zip
    2. 安装包拷贝
        [root@823ee0f64c26 ~]#mv linux.x64_11gR2_client.zip /u01/app
    3. 解压
        [root@823ee0f64c26 ~]# su - oracle
        Last login: Fri Mar 30 08:32:58 UTC 2018 on pts/1
        [oracle@823ee0f64c26 ~]$ cd /u01/app/
        [oracle@823ee0f64c26 app]$ unzip linux.x64_11gR2_client.zip

三、修改安装配置
1. 编辑配置文件client_install.rsp
[oracle@823ee0f64c26 app]$ cd client/re