Oracle静默安装 11GR2 silently setup

Oracle setup silently and automatic for single instance

配置好CentOS安装包yum源；

解压缩拷贝到$SOFT下的oracle11gR2软件包；

关闭SELinux;

将rsp响应文件拷贝到$SOFT下，按自身要求修改标红参数。

注意执行提示的脚本。

1、CentOS 6.4下基础环境配置

!#/bin/bash

echo "=======================1.user created================================="
groupadd -g 501 oinstall
groupadd -g 502 osoper
groupadd -g 503 dba
useradd -u 502 -g oinstall -G dba,osoper oracle
echo "oracle:oracle"|chpasswd
echo `ifconfig eth0 | grep 'inet addr'|awk '{print $2}'|awk -F: '{print $2}'` `hostname` >> /etc/hosts

echo "=======================2.all-rpms installed=============================="
export SOFT=/opt             ##将db_install.rsp 以及dbca.rsp拷贝到$SOFT
rpm -ivh $SOFT/database/rpm/cvuqdisk-1.0.9-1.rpm
#rpm -ivh http://10.8.39.xx/1_software/Oracle/pdksh-5.2.14-36.el5.x86_64.rpm
rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers libaio libaio-devel libgcc libstdc++ libstdc++-devel make sysstat unixODBC compat-libcap1 pdksh-5.2.14 cvuqdisk smartmontools unixODBC-devel | grep package | awk '{print $2}'|xargs yum install -y
echo "=======================3.inner-core paras config========================="
(
cat <<EOF
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 4294967295
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 = 1048586
EOF
)>>/etc/sysctl.conf
sysctl -p
echo "=======================4.resorces limits config==========================="
(
cat <<EOF
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft nofile 65536
oracle hard nofile 65536
EOF
)>>/etc/security/limits.conf
echo "=======================5.login limits config=============================="
echo "session  required pam_limits.so" >>/etc/pam.d/login
echo "=======================6.user login resource config======================="
(
cat <<EOF
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
umask 022
fi
EOF
)>>/etc/profile
echo "=======================7.mkdir dirs and grant privileges===================="
export ORACLE_BASE=/u01/base
export ORACLE_HOME=$ORACLE_BASE/prod/11gR2
mkdir -p $ORACLE_BASE/prod/11gR2
mkdir -p $ORACLE_BASE/oraInventory
chmod -R 775 $ORACLE_BASE
chown -R oracle:oinstall $ORACLE_BASE
echo "======================8.oracle usrenv config============================"
(
cat <<EOF
export ORACLE_BASE=/u01/base
export ORACLE_HOME=$ORACLE_BASE/prod/11gR2
export ORACLE_SID=xcky
export PATH=$ORACLE_HOME/bin:$PATH
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss"
EOF
)>>/home/oracle/.bash_profile
source /home/oracle/.bash_profile
echo "=======================9.software setup silently=========================="
su - oracle
$SOFT/database/runInstaller -silent -force -noconfig -responseFile $SOFT/db_install.rsp >>$SOFT/install_silent.log 2>&1

2、db_install.rsp数据库静默安装响应文件配置

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=master.cloudera
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/base/oraInventory
SELECTED_LANGUAGES=en
ORACLE_HOME=/u01/base/prod/11gR2
ORACLE_BASE=/u01/base
oracle.install.db.InstallEdition=EE
oracle.install.db.EEOptionsSelection=false
oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.3.0,oracle.oraolap:11.2.0.3.0,oracle.rdbms.dm:11.2.0.3.0,oracle.rdbms.dv:11.2.0.3.0,oracle.rdbms.lbac:11.2.0.3.0,oracle.rdbms.rat:11.2.0.3.0
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=osoper
oracle.install.db.CLUSTER_NODES=
oracle.install.db.isRACOneInstall=
oracle.install.db.racOneServiceName=
oracle.install.db.config.starterdb.type=
oracle.install.db.config.starterdb.globalDBName=
oracle.install.db.config.starterdb.SID=
oracle.install.db.config.starterdb.characterSet=AL32UTF8
oracle.install.db.config.starterdb.memoryOption=true
oracle.install.db.config.starterdb.memoryLimit=
oracle.install.db.config.starterdb.installExampleSchemas=false
oracle.install.db.config.starterdb.enableSecuritySettings=true
oracle.install.db.config.starterdb.password.ALL=
oracle.install.db.config.starterdb.password.SYS=
oracle.install.db.config.starterdb.password.SYSTEM=
oracle.install.db.config.starterdb.password.SYSMAN=
oracle.install.db.config.starterdb.password.DBSNMP=
oracle.install.db.config.starterdb.control=DB_CONTROL
oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=
oracle.install.db.config.starterdb.automatedBackup.enable=false
oracle.install.db.config.starterdb.automatedBackup.osuid=
oracle.install.db.config.starterdb.automatedBackup.ospwd=
oracle.install.db.config.starterdb.storageType=
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=
oracle.install.db.config.asm.diskGroup=
oracle.install.db.config.asm.ASMSNMPPassword=
MYORACLESUPPORT_USERNAME=
MYORACLESUPPORT_PASSWORD=
SECURITY_UPDATES_VIA_MYORACLESUPPORT=
DECLINE_SECURITY_UPDATES=true
PROXY_HOST=
PROXY_PORT=
PROXY_USER=
PROXY_PWD=
PROXY_REALM=
COLLECTOR_SUPPORTHUB_URL=
oracle.installer.autoupdates.option=
oracle.installer.autoupdates.downloadUpdatesLoc=
AUTOUPDATES_MYORACLESUPPORT_USERNAME=
AUTOUPDATES_MYORACLESUPPORT_PASSWORD=

3、dbca建库响应文件

[GENERAL]
RESPONSEFILE_VERSION = "11.2.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE]
GDBNAME = "tiger"
SID = "tiger"
TEMPLATENAME = "General_Purpose.dbc"
characterSet = "ZHS16GBK"
memoryPercentage = "60"
emConfiguration = "LOCAL"
sysPassword = "hisign"
systemPassword = "hisign"
dbsnmpPassword = "hisign"
sysmanPassword = "hisign"
[createTemplateFromDB]
SOURCEDB = "myhost:1521:orcl"
SYSDBAUSERNAME = "system"
TEMPLATENAME = "My Copy TEMPLATE"
[createCloneTemplate]
SOURCEDB = "orcl"
TEMPLATENAME = "My Clone TEMPLATE"
[DELETEDATABASE]
SOURCEDB = "orcl"
[generateScripts]
TEMPLATENAME = "New Database"
GDBNAME = "orcl11.us.oracle.com"
[CONFIGUREDATABASE]
[ADDINSTANCE]
DB_UNIQUE_NAME = "orcl11g.us.oracle.com"
NODELIST=
SYSDBAUSERNAME = "sys"
[DELETEINSTANCE]
DB_UNIQUE_NAME = "XCKY"
INSTANCENAME = "xcky"
SYSDBAUSERNAME = "sys"

修改引用的通用模板General_Purpose.dbc

    1）本次规划数据库存储目录：/dbca/oradata
         # mkdir -p /dbca/oradata && chown oracle:oinstall /dbca/oradata
    2）修改模板
        $ cd $ORACLE_HOME/assistants/dbca/templates/
        $ cp General_Purpose.dbc General_Purpose.dbc.bak 
    3）vi替换{ORACLE_BASE}/oradata为新的存储路径/u02/oradata
        $ vi General_Purpose.dbc
        :%s#{ORACLE_BASE}/oradata#/dbca/oradata#g
         或者sed直接快速替换
        #sed -i 's#{ORACLE_BASE}/oradata#/dbca/oradata#g' General_Purpose.dbc

安装

#su - oracle

$$ORACLE_HOME/bin/dbca -silent-responseFile $SOFT/dbca.rsp

Copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
50% complete
55% complete
56% complete
60% complete
62% complete
Completing Database Creation
66% complete
70% complete
73% complete
85% complete
96% complete
100% complete

至此安装完成。