oracle11G静默安装@centos6.8.doc

配置系统代理：root 用户加http和ftp代理：sed -i $a export http_proxy=83:8080/n export http_ftp=83:8080/ /root/.bash_profileyum.conf增加代理sed -i $a proxy=83:8080/ /etc/yum.confwgetrc增加代理：sed -i $a https_proxy=83:8080/n http_proxy=83:8080/n ftp_proxy=83:8080/ /etc/wgetrcps: 运行yum.sh增加本地源和安装vnc.配置系统和安装所需软件包2.1 关闭selinuxsed -i s/SELINUX=enforcing/SELINUX=disabled/g /etc/selinux/config2.6安装oracle所需的软件包yum install -y gcc gcc-c+ glibc glibc-devel glibc-headers pdksh libaio libaio-devel libgcc libstdc+ libstdc+-devel make sysstat unixODBC unixODBC-devel zlib-devel unzip compat-libcap1 compat-libstdc+-33 重启以后再安装pdksh：wget /centos/5/os/x86_64/CentOS/pdksh-5.2.14-37.el5_8.1.x86_64.rpmrpm -ivh pdksh-5.2.14-37.el5_8.1.x86_64.rpm如果：pdksh 与 (已安裝) ksh-20120801-22.el7_1.3.x86_64 冲突需要先卸载ksh：rpm -e ksh-20120801-22.el7_1.3.x86_642.7 添加oracle用户和组groupadd oinstallgroupadd dbagroupadd opermkdir /oracleuseradd -d /oracle -g oinstall -G dba,oper -u 500 -r -p ztesoft oracle2.8 修改系统参数2.8.1 /etc/sysctl.conffs.file-max = 6815744kernel.sem = 250 32000 100 128kernel.shmmni = 4096kernel.shmall = 1073741824kernel.shmmax = 4398046511104net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576fs.aio-max-nr = 1048576net.ipv4.ip_local_port_range = 9000 65500命令行：sed -i $a fs.file-max = 6815744nkernel.sem = 250 32000 100 128nkernel.shmmni = 4096nkernel.shmall = 1073741824nkernel.shmmax = 4398046511104nnet.core.rmem_default = 262144nnet.core.rmem_max = 4194304nnet.core.wmem_default = 262144nnet.core.wmem_max = 1048576nfs.aio-max-nr = 1048576nnet.ipv4.ip_local_port_range = 9000 65500n /etc/sysctl.conf2.8.2 应用核心参数sysctl -p 2.8.3 /etc/security/limits.conforacle soft nofile 1024oracle hard nofile 65536oracle soft nproc 2047oracle hard nproc 16384oracle soft stack 10240oracle hard stack 32768 命令行：sed -i $a oracle soft nofile 1024noracle hard nofile 65536noracle soft nproc 2047noracle hard nproc 16384noracle soft stack 10240noracle hard stack 32768n /etc/security/limits.conf2.9 创建安装文件夹mkdir /oracle/zscmkdir /oracle/oradatamkdir /oracle/oraInventorychown -R oracle:oinstall /oracle3.切换到oracle用户，配置oracle用户环境变量3.1 设置oracle用户密码并切换到oracle用户passwd oraclesu - oracle3.2 编辑oracle用户环境变量配置文件/.bash_profileexport PS1=uhw$export ORACLE_BASE=/oracle/zscexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1export ORACLE_SID=zscPATH=/usr/sbin:$PATH:$ORACLE_HOME/bin:$HOME/bin:/$HOME/.local/binexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;export NLS_LANG=SIMPLIFIED CHINESE_CHINA.AL32UTF8alias cdob=cd $ORACLE_BASEalias cdoh=cd $ORACLE_HOMEalias tns=cd $ORACLE_HOME/network/adminalias envo=env | grep ORACLE3.3 应用环境变量source .bash_profile 4.获取安装包进行安装4.1 从/technetwork/database/enterprise-edition/downloads/index.html 下载oracle12c安装包4.2 解压安装包unzip linux.x64_11gR2_database_1of2.zipunzip linux.x64_11gR2_database_2of2.zip 4.3 进入database文件夹复制一个应答文件cd databasecp response/db_install.rsp inst.rsp 4.4 修改应答文件ps:需要手动修改：INVENTORY_LOCATION=/oracle/oraInventoryORACLE_HOME=/oracle/zsc/product/11.2.0/dbhome_1ORACLE_BASE=/oracle/zsc4.5 执行安装程序./runInstaller -ignoreSysPrereqs -force -silent -responseFile /database/inst.rsp 4.6 查看是否有出错日志tail f /oracle/oraInventory/logs/silentInstall2016-05-07_01-34-53PM.log 如果没有安装pdksh会报如下错：INFO: Actual Value:缺失INFO: Error Message:PRVF-7532 : 节点 localhost 上缺少程序包 pdkshINFO: Cause: 指定的节点上未安装必需的程序包; 或者如果该程序包是内核模块, 则未加载该程序包。INFO: Action: 确保必需的程序包已安装且可用。WARNING: WARNING INS-13014 目标环境不满足一些可选要求。 原因: 不满足一些可选的先决条件。有关详细信息, 请查看日志。/tmp/OraInstall2016-05-08_03-37-49PM/installActions2016-05-08_03-37-49PM.log4.7 安装完成之后，用root执行root.sh以 root 用户的身份执行以下脚本: 1. /oracle/oraInventory/orainstRoot.sh 2. /oracle/zsc/product/11.2.0/dbhome_1/root.sh 以安装用户的身份执行以下脚本来完成配置。 1. /oracle/zsc/product/12.1.0/db_1/cfgtoollogs/configToolAllCommands RESPONSE_FILE= 注: 1. 此脚本必须在已运行安装程序的同一主机上运行。 2. 对于需要口令的 Configuration Assistant, 此脚本需要一个较小的口令属性文件 (请参阅安装指南文档)。例：/oracle/zsc/product/12.1.0/db_1/cfgtoollogs/configToolAllCommands /oracle/database/inst.rsp安装完成以后，先重启一遍？配置监听：netca /silent /responsefile /home/oracle/database/response/netca.rsp注意需要修改下：$ORACLE_HOME/network/admin/listener.ora增加：SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = zsc) (SID_NAME = zsc) ) )然后把端口号改成：1521创建实例：dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname zsc -sid zsc -datafiledestination /oracle/oradata -responseFile NO_VALUE -characterSet AL32UTF8 -emConfiguration LOCAL 配置开机自动起：/zhaomin_allen/blog/static/6224484820121121105356861/命令行：sed -i s/ORACLE_HOME_LISTNER=$1/ORACLE_HOME_LISTNER=$ORACLE_HOME/g $ORACLE_HOME/bin/dbstartsed -i s/ORACLE_HOME_LISTNER=$1/ORACLE_HOME_LISTNER=$ORACLE_HOME/g $ORACLE_HOME/bin/dbshutsu - rootsed -i s/:N/:Y/g /etc/oratabzsc:/oracle/zsc/product/11.2.0/dbhome_1:Ysed -i $a zsc:/oracle/zsc/product/11.2.0/dbhome_1:Yn /etc/oratabvi /etc/rc.d/init.d/oracle#! /bin/bash# chkconfig: 234 61 61# description: Oracle 11g AutoRun Service# /etc/rc.d/init.d/oraclecase $1 in start) # starts oracle listener and instance echo Starting Oracle Database: su - oracle -lc lsnrctl start su - oracle -lc dbstart ; stop) # shutdown oracle listner and instance echo Shuting down Oracle Database: su - oracle -lc lsnrctl stop su - oracle -lc dbshut ; reload|restart) $0 stop $0 start ; *) echo Usage: start|stop|reload|restart exit 1esacexit 0chmod 750 /etc/rc.d/init.d/oracleln -s /etc/rc.d/init.d/oracle /etc/rc2.d/S61oracleln -s /e