ITPub博客

首页 > 数据库 > Oracle > cent os 6.6 x64 自动静默安装oracle 11gr2脚本

cent os 6.6 x64 自动静默安装oracle 11gr2脚本

Oracle 作者:彩伦 时间:2016-06-08 10:27:48 0 删除 编辑
<span style="font-size:16px;"></span><br /> <span style="font-size:16px;">前提:centos 6.6已经做了basic安装,ip和主机名已设置.oracle安装文件p13390677_112040_Linux-x86-64_1of7.zip,p13390677_112040_Linux-x86-64_2of7.zip</span><br /> <span style="font-size:16px;">放在/root下,pdksh-5.2.14-30.x86_64.rpm包放在/root下.</span><br /> <span style="font-size:16px;">os:centos 6.6</span><br /> <span style="font-size:16px;">oracle:11.2.0.4</span><br /> <span style="font-size:16px;">IP:192.108.56.119</span><br /> <span style="font-size:16px;">hostname:ct6602</span><br /> <br /> <span style="font-size:16px;"><strong>---以下内容放在一个文本下,sh执行即可:</strong></span><br /> <span style="font-size:16px;">#!/bin/bash</span><br /> <br /> <span style="font-size:16px;"><strong>##此处用于加载光驱安装缺少的包,也可改为网络方式.</strong></span><br /> <span style="font-size:16px;">mkdir /media/cdrom</span><br /> <span style="font-size:16px;">mount /dev/cdrom /media/cdrom</span><br /> <span style="font-size:16px;">mv /etc/yum.repos.d/*.repo /root/</span><br /> <br /> <span style="font-size:16px;">cat &gt; /etc/yum.repos.d/CentOS-Media.repo &lt;&lt; EOF</span><br /> <span style="font-size:16px;">[c6-media]</span><br /> <span style="font-size:16px;">name=CentOS-$releasever - Media</span><br /> <span style="font-size:16px;">baseurl=file:///media/cdrom/</span><br /> <span style="font-size:16px;">gpgcheck=1</span><br /> <span style="font-size:16px;">enabled=1</span><br /> <span style="font-size:16px;">gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-CentOS-6</span><br /> <span style="font-size:16px;">EOF</span><br /> <br /> <span style="font-size:16px;">yum clean all</span><br /> <span style="font-size:16px;">yum makecache</span><br /> <br /> <span style="font-size:16px;"><strong>##配置操作系统</strong></span><br /> <span style="font-size:16px;">chkconfig iptables off</span><br /> <span style="font-size:16px;">service iptables stop</span><br /> <span style="font-size:16px;">setenforce 0</span><br /> <span style="font-size:16px;">sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config</span><br /> <br /> <span style="font-size:16px;">cat &gt;&gt; /etc/hosts &lt;&lt; EOF</span><br /> <span style="font-size:16px;">192.108.56.119&nbsp;&nbsp; &nbsp;ct6602</span><br /> <span style="font-size:16px;">EOF</span><br /> <br /> <span style="font-size:16px;">cat &gt;&gt; /etc/sysctl.conf &lt;&lt; EOF</span><br /> <span style="font-size:16px;">kernel.shmmni = 4096</span><br /> <span style="font-size:16px;">kernel.sem = 250 32000 100 128</span><br /> <span style="font-size:16px;">fs.aio-max-nr = 1048576</span><br /> <span style="font-size:16px;">fs.file-max = 6815744</span><br /> <span style="font-size:16px;">net.ipv4.ip_local_port_range = 9000 65500</span><br /> <span style="font-size:16px;">net.core.rmem_default = 1048576</span><br /> <span style="font-size:16px;">net.core.rmem_max = 4194304</span><br /> <span style="font-size:16px;">net.core.wmem_default = 262144</span><br /> <span style="font-size:16px;">net.core.wmem_max = 1048576</span><br /> <span style="font-size:16px;">EOF</span><br /> <br /> <span style="font-size:16px;">sysctl -p</span><br /> <br /> <span style="font-size:16px;">cat &gt;&gt; /etc/security/limits.conf&nbsp; &lt;&lt; EOF</span><br /> <span style="font-size:16px;">oracle soft nproc 2047</span><br /> <span style="font-size:16px;">oracle hard nproc 16384</span><br /> <span style="font-size:16px;">oracle soft nofile 1024</span><br /> <span style="font-size:16px;">oracle hard nofile 65536</span><br /> <span style="font-size:16px;">EOF</span><br /> <br /> <span style="font-size:16px;"><strong>##配置oracle用户</strong></span><br /> <span style="font-size:16px;">groupadd oinstall</span><br /> <span style="font-size:16px;">groupadd dba</span><br /> <span style="font-size:16px;">useradd -d /home/oracle -g oinstall -G dba oracle</span><br /> <span style="font-size:16px;">echo "system"|passwd --stdin oracle</span><br /> <br /> <span style="font-size:16px;">cat &gt;&gt; /home/oracle/.bash_profile &lt;&lt; EOF</span><br /> <span style="font-size:16px;">export TMP=/tmp</span><br /> <span style="font-size:16px;">export TMPDIR=$TMP</span><br /> <span style="font-size:16px;">export ORACLE_BASE=/u01/app/oracle</span><br /> <span style="font-size:16px;">export ORACLE_HOME=\$ORACLE_BASE/product/11.2.0/db_1</span><br /> <span style="font-size:16px;">export ORACLE_SID=ct6602</span><br /> <span style="font-size:16px;">export ORACLE_TERM=xterm</span><br /> <span style="font-size:16px;">export PATH=/usr/sbin:\$PATH</span><br /> <span style="font-size:16px;">export PATH=\$ORACLE_HOME/bin:\$PATH</span><br /> <span style="font-size:16px;">export LD_LIBRARY_PATH=\$ORACLE_HOME/bin:/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin/</span><br /> <span style="font-size:16px;">export CLASSPATH=\$ORACLE_HOME/JRE:\$ORACLE_HOME/jlib:\$ORACLE_HOME/rdbms/jlib</span><br /> <span style="font-size:16px;">ulimit -u 16384 -n 65536</span><br /> <span style="font-size:16px;">umask 022</span><br /> <span style="font-size:16px;">EOF</span><br /> <span style="font-size:16px;">&nbsp;.&nbsp; /home/oracle/.bash_profile</span><br /> <span style="font-size:16px;">&nbsp;</span><br /> <span style="font-size:16px;">mkdir -p /u01/app/oracle /u02/oradata /u03/archivelog /u09/orabackup</span><br /> <span style="font-size:16px;">chown -R oracle.oinstall&nbsp; /u01/app /u02/oradata /u03/archivelog /u09/orabackup</span><br /> <span style="font-size:16px;">chmod -R 775 /u01/app</span><br /> <br /> <span style="font-size:16px;">yum -y install&nbsp; gcc gcc-c++ make binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel glibc glibc-common glibc-devel libaio libaio-devel libgcc libstdc++ libstdc++-devel unixODBC unixODBC-devel</span><br /> <br /> <span style="font-size:16px;">rpm -ivh /root/pdksh-5.2.14-30.x86_64.rpm</span><br /> <br /> <span style="font-size:16px;">yum -y install expect</span><br /> <br /> <span style="font-size:16px;">mv /root/p13390677_112040_Linux-x86-64_* /home/oracle/</span><br /> <br /> <span style="font-size:16px;">chown -R oracle.oinstall /home/oracle/p13390677_112040_Linux-x86-64_*</span><br /> <br /> <span style="font-size:16px;">su - oracle -c "unzip /home/oracle/p13390677_112040_Linux-x86-64_1of7.zip"</span><br /> <span style="font-size:16px;">su - oracle -c "unzip /home/oracle/p13390677_112040_Linux-x86-64_2of7.zip"</span><br /> <br /> <span style="font-size:16px;"><strong>##配置安装响应文件</strong></span><br /> <span style="font-size:16px;">##db_install.rsp</span><br /> <span style="font-size:16px;">su - oracle -c cat &gt;&gt; /home/oracle/db_install.rsp &lt;&lt;EOF</span><br /> <span style="font-size:16px;">oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0</span><br /> <span style="font-size:16px;">oracle.install.option=INSTALL_DB_AND_CONFIG</span><br /> <span style="font-size:16px;">ORACLE_HOSTNAME=ct6602</span><br /> <span style="font-size:16px;">UNIX_GROUP_NAME=oinstall</span><br /> <span style="font-size:16px;">INVENTORY_LOCATION=/u01/app/oraInventory</span><br /> <span style="font-size:16px;">SELECTED_LANGUAGES=en,zh_CN</span><br /> <span style="font-size:16px;">ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1</span><br /> <span style="font-size:16px;">ORACLE_BASE=/u01/app/oracle</span><br /> <span style="font-size:16px;">oracle.install.db.InstallEdition=EE</span><br /> <span style="font-size:16px;">oracle.install.db.EEOptionsSelection=false</span><br /> <span style="font-size:16px;">oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.4.0,oracle.oraolap:11.2.0.4.0,oracle.rdbms.dm:11.2.0.4.0,oracle.rdbms.dv:11.2.0.4.0,oracle.rdbms.lbac:11.2.0.4.0,oracle.rdbms.rat:11.2.0.4.0</span><br /> <span style="font-size:16px;">oracle.install.db.DBA_GROUP=dba</span><br /> <span style="font-size:16px;">oracle.install.db.OPER_GROUP=dba</span><br /> <span style="font-size:16px;">oracle.install.db.CLUSTER_NODES=</span><br /> <span style="font-size:16px;">oracle.install.db.isRACOneInstall=</span><br /> <span style="font-size:16px;">oracle.install.db.racOneServiceName=</span><br /> <span style="font-size:16px;">oracle.install.db.config.starterdb.type=GENERAL_PURPOSE</span><br /> <span style="font-size:16px;">oracle.install.db.config.starterdb.globalDBName=ct6602</span><br /> <span style="font-size:16px;">oracle.install.db.config.starterdb.SID=ct6602</span><br /> <span style="font-size:16px;">oracle.install.db.config.starterdb.characterSet=AL32UTF8</span><br /> <span style="font-size:16px;">oracle.install.db.config.starterdb.memoryOption=true</span><br /> <span style="font-size:16px;">oracle.install.db.config.starterdb.memoryLimit=700</span><br /> <span style="font-size:16px;">oracle.install.db.config.starterdb.installExampleSchemas=false</span><br /> <span style="font-size:16px;">oracle.install.db.config.starterdb.enableSecuritySettings=false</span><br /> <span style="font-size:16px;">oracle.install.db.config.starterdb.password.ALL=system</span><br /> <span style="font-size:16px;">oracle.install.db.config.starterdb.password.SYS=</span><br /> <span style="font-size:16px;">oracle.install.db.config.starterdb.password.SYSTEM=</span><br /> <span style="font-size:16px;">oracle.install.db.config.starterdb.password.SYSMAN=</span><br /> <span style="font-size:16px;">oracle.install.db.config.starterdb.password.DBSNMP=</span><br /> <span style="font-size:16px;">oracle.install.db.config.starterdb.control=DB_CONTROL</span><br /> <span style="font-size:16px;">oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=</span><br /> <span style="font-size:16px;">oracle.install.db.config.starterdb.automatedBackup.enable=false</span><br /> <span style="font-size:16px;">oracle.install.db.config.starterdb.automatedBackup.osuid=</span><br /> <span style="font-size:16px;">oracle.install.db.config.starterdb.automatedBackup.ospwd=</span><br /> <span style="font-size:16px;">oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE</span><br /> <span style="font-size:16px;">oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=/u02/oradata/</span><br /> <span style="font-size:16px;">oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=</span><br /> <span style="font-size:16px;">oracle.install.db.config.asm.diskGroup=</span><br /> <span style="font-size:16px;">oracle.install.db.config.asm.ASMSNMPPassword=</span><br /> <span style="font-size:16px;">MYORACLESUPPORT_USERNAME=</span><br /> <span style="font-size:16px;">MYORACLESUPPORT_PASSWORD=</span><br /> <span style="font-size:16px;">SECURITY_UPDATES_VIA_MYORACLESUPPORT=false</span><br /> <span style="font-size:16px;">DECLINE_SECURITY_UPDATES=true</span><br /> <span style="font-size:16px;">PROXY_HOST=</span><br /> <span style="font-size:16px;">PROXY_PORT=</span><br /> <span style="font-size:16px;">PROXY_USER=</span><br /> <span style="font-size:16px;">PROXY_PWD=</span><br /> <span style="font-size:16px;">PROXY_REALM=</span><br /> <span style="font-size:16px;">COLLECTOR_SUPPORTHUB_URL=</span><br /> <span style="font-size:16px;">oracle.installer.autoupdates.option=</span><br /> <span style="font-size:16px;">oracle.installer.autoupdates.downloadUpdatesLoc=</span><br /> <span style="font-size:16px;">AUTOUPDATES_MYORACLESUPPORT_USERNAME=</span><br /> <span style="font-size:16px;">AUTOUPDATES_MYORACLESUPPORT_PASSWORD=</span><br /> <span style="font-size:16px;">EOF</span><br /> <br /> <span style="font-size:16px;">##netca.rsp</span><br /> <span style="font-size:16px;">su - oracle -c cat &gt; /home/oracle/netca.rsp &lt;&lt; EOF</span><br /> <span style="font-size:16px;">[GENERAL]</span><br /> <span style="font-size:16px;">RESPONSEFILE_VERSION="11.2"</span><br /> <span style="font-size:16px;">CREATE_TYPE="CUSTOM"</span><br /> <span style="font-size:16px;">[oracle.net.ca]</span><br /> <span style="font-size:16px;">INSTALLED_COMPONENTS={"server","net8","javavm"}</span><br /> <span style="font-size:16px;">INSTALL_TYPE=""typical""</span><br /> <span style="font-size:16px;">LISTENER_NUMBER=1</span><br /> <span style="font-size:16px;">LISTENER_NAMES={"LISTENER"}</span><br /> <span style="font-size:16px;">LISTENER_PROTOCOLS={"TCP;1521"}</span><br /> <span style="font-size:16px;">LISTENER_START=""LISTENER""</span><br /> <span style="font-size:16px;">NAMING_METHODS={"TNSNAMES","ONAMES","HOSTNAME"}</span><br /> <span style="font-size:16px;">NSN_NUMBER=1</span><br /> <span style="font-size:16px;">NSN_NAMES={"EXTPROC_CONNECTION_DATA"}</span><br /> <span style="font-size:16px;">NSN_SERVICE={"PLSExtProc"}</span><br /> <span style="font-size:16px;">NSN_PROTOCOLS={"TCP;HOSTNAME;1521"}</span><br /> <span style="font-size:16px;">EOF</span><br /> <br /> <span style="font-size:16px;">##dbca.rsp</span><br /> <span style="font-size:16px;">su - oracle -c cat &gt; /home/oracle/dbca.rsp &lt;&lt; EOF</span><br /> <span style="font-size:16px;">[GENERAL]</span><br /> <span style="font-size:16px;">RESPONSEFILE_VERSION = "11.2.0"</span><br /> <span style="font-size:16px;">OPERATION_TYPE = "createDatabase"</span><br /> <span style="font-size:16px;">[CREATEDATABASE]</span><br /> <span style="font-size:16px;">GDBNAME = "ct6602"</span><br /> <span style="font-size:16px;">SID = "ct6602"</span><br /> <span style="font-size:16px;">TEMPLATENAME = "General_Purpose.dbc"<br /> CHARACTERSET = "AL32UTF8"<br /> NATIONALCHARACTERSET= "AL16UTF16"</span><br /> <span style="font-size:16px;">SYSPASSWORD = "system"</span><br /> <span style="font-size:16px;">SYSTEMPASSWORD = "system"</span><br /> <span style="font-size:16px;">DATAFILEDESTINATION =/u02/oradata</span><br /> <span style="font-size:16px;">RECOVERYAREADESTINATION=/u09/orabackup</span><br /> <span style="font-size:16px;">TOTALMEMORY = "700"</span><br /> <span style="font-size:16px;">[createTemplateFromDB]</span><br /> <span style="font-size:16px;">SOURCEDB = "myhost:1521:orcl"</span><br /> <span style="font-size:16px;">SYSDBAUSERNAME = "system"</span><br /> <span style="font-size:16px;">TEMPLATENAME = "My Copy TEMPLATE"</span><br /> <span style="font-size:16px;">[createCloneTemplate]</span><br /> <span style="font-size:16px;">SOURCEDB = "orcl"</span><br /> <span style="font-size:16px;">TEMPLATENAME = "My Clone TEMPLATE"</span><br /> <span style="font-size:16px;">[DELETEDATABASE]</span><br /> <span style="font-size:16px;">SOURCEDB = "orcl"</span><br /> <span style="font-size:16px;">[generateScripts]</span><br /> <span style="font-size:16px;">TEMPLATENAME = "New Database"</span><br /> <span style="font-size:16px;">GDBNAME = "orcl11.us.oracle.com"</span><br /> <span style="font-size:16px;">[CONFIGUREDATABASE]</span><br /> <span style="font-size:16px;">[ADDINSTANCE]</span><br /> <span style="font-size:16px;">DB_UNIQUE_NAME = "orcl11g.us.oracle.com"</span><br /> <span style="font-size:16px;">NODELIST=</span><br /> <span style="font-size:16px;">SYSDBAUSERNAME = "sys"</span><br /> <span style="font-size:16px;">[DELETEINSTANCE]</span><br /> <span style="font-size:16px;">DB_UNIQUE_NAME = "orcl11g.us.oracle.com"</span><br /> <span style="font-size:16px;">INSTANCENAME = "orcl11g"</span><br /> <span style="font-size:16px;">SYSDBAUSERNAME = "sys"</span><br /> <span style="font-size:16px;">EOF</span><br /> <br /> <span style="font-size:16px;"><strong>##安装oracle</strong></span><br /> <span style="font-size:16px;">su - oracle -c "/home/oracle/database/runInstaller -silent -noconfig -ignorePrereq -responseFile /home/oracle/db_install.rsp" </span><br /> <br /> <span style="font-size:16px;">cat &lt;&lt; EOF</span><br /> <span style="font-size:16px;">###########################################################################</span><br /> <span style="font-size:16px;"><strong>安装完oracle,在root用户执行下面4条命令.</strong></span><br /> <br /> <span style="font-size:16px;">sh /u01/app/oraInventory/orainstRoot.sh</span><br /> <span style="font-size:16px;">sh /u01/app/oracle/product/11.2.0/db_1/root.sh</span><br /> <span style="font-size:16px;">su - oracle -c "netca /silent /responsefile /home/oracle/netca.rsp"</span><br /> <span style="font-size:16px;">su - oracle -c "dbca -silent -responseFile /home/oracle/dbca.rsp"</span><br /> <span style="font-size:16px;">############################################################################</span><br /> <span style="font-size:16px;">EOF</span><br /> <br />

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/30130773/viewspace-2117262/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2015-02-06

  • 博文量
    138
  • 访问量
    892105