Centos7-Oracle静默安装

1、安装依赖

yum install vim unzip git wget net-tools

yum install -y gcc make binutils gcc-c++ compat-libstdc++-33elfutils-libelf-devel elfutils-libelf-devel-static ksh libaio libaio-develnumactl-devel sysstat unixODBC unixODBC-devel pcre-devel libXtst.so.6

yum install libXp*.x86_64 libXt*.x86_64 libxtst*.x86_64 -y

yum -y install binutils compat-libcap1  compat-libstdc++-33 compat-libstdc++-33*.i686 elfutils-libelf-devel gcc gcc-c++ glibc*.i686 glibc glibc-devel glibc-devel*.i686 libgcc*.i686 libgcc libstdc++ libstdc++*.i686 libstdc++-devel libstdc++-devel*.i686 libaio libaio*.i686 libaio-devel libaio-devel*.i686 make sysstat unixODBC unixODBC*.i686 unixODBC-devel unixODBC-devel*.i686 libXp

2、上传oracle安装程序并解压

mkdir -p /data/oracle/oraclesetup
unzip linux.x64_11gR2_database_1of2.zip && unzip linux.x64_11gR2_database_2of2.zip

3、添加主机名到hosts

vi /etc/hosts

4、添加用户和用户组

groupadd oinstall
groupadd dba
useradd -g oinstall -G dba oracle

5、修改内核参数文件，文件末尾添加以下内容

vi /etc/sysctl.conf

fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 8589934592
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

6、修改文件，文件末尾添加以下内容

vi /etc/security/limits.conf

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240

7、修改文件，文件末尾添加以下内容

vi /etc/pam.d/login

session required /lib64/security/pam_limits.so
session required pam_limits.so

8、修改文件，文件末尾添加以下内容

vi /etc/profile

if [ $USER = "oracle" ]; then
    if [ $SHELL = "/bin/ksh" ]; then
        ulimit -p 16384
        ulimit -n 65536
    else
        ulimit -u 16384 -n 65536
    fi
fi

9、创建安装目录和设置目录权限

mkdir /oradata
mkdir -p /data/oracle/product/11.2.0
mkdir /data/oracle/oradata         //数据库文件，生产一般是放在存储上的
mkdir /data/oracle/inventory
mkdir /data/oracle/fast_recovery_area
chown -R oracle:oinstall /data/oracle
chmod -R 775 /data/oracle
chown -R oracle:oinstall /oradata    //数据库文件，这里存储是挂在这个目录

10、设置oracle用户变量，编辑文件.bash_profile，添加

su - oracle
vi .bash_profile

ORACLE_BASE=/data/oracle
ORACLE_HOME=$ORACLE_BASE/product/11.2.0
ORACLE_SID=orcl
PATH=$PATH:$ORACLE_HOME/bin
export ORACLE_BASE ORACLE_HOME ORACLE_SID PATH
export PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin

11、编辑配置文件静默安装响应文件

vi /data/oracle/oraclesetup/database/response/db_install.rsp

oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=oracle
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/data/oracle/inventory
SELECTED_LANGUAGES=en,zh_CN
ORACLE_HOME=/data/oracle/product/11.2.0
ORACLE_BASE=/data/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.isCustomInstall=false
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=dba
DECLINE_SECURITY_UPDATES=true

12、切换到oracle用户静默安装

./runInstaller -silent -responseFile /data/oracle/oraclesetup/database/response/db_install.rsp -ignorePrereq

13、安装成功后，切换root用户执行

/data/oracle/inventory/orainstRoot.sh
/data/oracle/product/11.2.0/root.sh

14、以静默方式配置监听

su - oracle
export DISPLAY=IP地址:0.0
netca -silent -responseFile /data/oracle/oraclesetup/database/response/netca.rsp

15、命令查看服务状态

lsnrctl status
netstat -natp

 16、以静默方式建立新库，同时也建立一个对应的实例。

vi /data/oracle/oraclesetup/database/response/dbca.rsp

GDBNAME = "orcl"
SID = "orcl"
TEMPLATENAME = "General_Purpose.dbc"
SYSPASSWORD = "chenzm123"
SYSTEMPASSWORD = "chenzm123"
SYSMANPASSWORD = "chenzm123"
DBSNMPPASSWORD = "chenzm123"
DATAFILEDESTINATION = /oradata
RECOVERYAREADESTINATION=/data/oracle/fast_recovery_area
RECOVERYAREADESTINATION=/oradata/fast_recovery_area //正式配置在/oradata
CHARACTERSET = "ZHS16GBK"
TOTALMEMORY = "12000" //物理内存的80%

17、开始安装数据库实例

dbca -silent -responseFile /data/oracle/oraclesetup/database/response/dbca.rsp

18、查看实例状态

lsnrctl status

19、设置oracle 开机启动

vi /data/oracle/product/11.2.0/bin/dbshut

将ORACLE_HOME_LISTNER=$1修改为ORACLE_HOME_LISTNER=$ORACLE_HOME

vi /data/oracle/product/11.2.0/bin/dbstart

将ORACLE_HOME_LISTNER=$1修改为ORACLE_HOME_LISTNER=$ORACLE_HOME

vi /etc/oratab
将orcl:/data/oracle/product/11.2.0:N中最后的N改为Y，成为orcl:/data/oracle/product/11.2.0:Y

20、添加启动脚本

vi /etc/init.d/oracle

#!/bin/bash
#oracle: Start/Stop Oracle Database 11g R2
#chkconfig: 345 90 10
#description: The Oracle Database is an Object-Relational Database ManagementSystem.
#
. /etc/rc.d/init.d/functions
LOCKFILE=/var/lock/subsys/oracle
ORACLE_HOME=/data/oracle/product/11.2.0
ORACLE_USER=oracle
case "$1" in
'start')
if [ -f $LOCKFILE ]; then
echo $0 already running.
else
echo -n $"StartingOracle Database:"
su - $ORACLE_USER -c"$ORACLE_HOME/bin/lsnrctl start"
su - $ORACLE_USER -c"$ORACLE_HOME/bin/dbstart $ORACLE_HOME"
su - $ORACLE_USER -c"$ORACLE_HOME/bin/emctl start dbconsole"
touch $LOCKFILE
fi
;;
'stop')
if [ ! -f $LOCKFILE ]; then
echo $0 already stopping.
else
echo -n $"StoppingOracle Database:"
su - $ORACLE_USER -c"$ORACLE_HOME/bin/lsnrctl stop"
su - $ORACLE_USER -c"$ORACLE_HOME/bin/dbshut"
su - $ORACLE_USER -c"$ORACLE_HOME/bin/emctl stop dbconsole"
rm -f $LOCKFILE
fi
;;
'restart')
$0 stop
sleep 5
$0 start
;;
'status')
if [ -f $LOCKFILE ]; then
echo $0 started.
else
echo $0 stopped.
fi
;;
*)
echo "Usage: $0[start|stop|status]"
exit 1
esac
exit 0

21、设置脚本开机启动

chmod +x /etc/init.d/oracle
chkconfig oracle on

资源下载

linux.x64_11gR2_database_1of2.zip

来源：阿里云盘

立即下载

linux.x64_11gR2_database_2of2.zip

来源：阿里云盘

立即下载