oracle11g静默安装

1.依赖包
yum -y install binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-33*i686 compat-libstdc++-33*.devel compat-libstdc++-33 compat-libstdc++-33*.devel gcc gcc-c++ glibc glibc*.i686 glibc-devel glibc-devel*.i686 ksh libaio libaio*.i686 libaio-devel libaio-devel*.devel libgcc libgcc*.i686 libstdc++ libstdc++*.i686 libstdc++-devel libstdc++-devel*.devel libXi libXi*.i686 libXtst libXtst*.i686 make sysstat unixODBC unixODBC*.i686 unixODBC-devel unixODBC-devel*.i686

2.创建用户组

3.配置内核参数
vim /etc/sysctl.conf

fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 7516192768 #7G
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

生效 /sbin/sysctl -p
4.修改用户权限
vim /etc/security/limits.conf

#在末尾添加
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
oracle hard stack 10240

5.在/etc/pam.d/login 文件中，使用文本编辑器或vi命令增加或修改以下内容
session required /lib64/security/pam_limits.so
session required pam_limits.so

6.创建安装目录
mkdir -p /data/oracle/app/
mkdir -p /data/oracle/oraInventory
chown -R oracle:oinstall /data/oracle/app/
chown -R oracle:oinstall /data/oracle/oraInventory
chmod -R 775 /data/oracle/app/

7.配置环境变量
export ORACLE_SID=cmisbak
export ORACLE_BASE=/ora11g/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4/dbhome_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin
umask 022

8.
cp /home/oracle/database/response/db_install.rsp /home/oracle/database/response/db_install.rsp.bak
>/home/oracle/database/response/db_install.rsp
cat >> /home/oracle/11gdatabase/response/db_install.rsp <<-'EOF'
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=66.1.1.60
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/ora11g/app/oraInventory
SELECTED_LANGUAGES=en
ORACLE_HOME=/ora11g/app/oracle/product/11.2.0
ORACLE_BASE=/ora11g/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.EEOptionsSelection=false
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=oinstall
oracle.install.db.isRACOneInstall=false
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.memoryOption=false
oracle.install.db.config.starterdb.installExampleSchemas=false
oracle.install.db.config.starterdb.enableSecuritySettings=true
oracle.install.db.config.starterdb.control=DB_CONTROL
oracle.install.db.config.starterdb.automatedBackup.enable=false
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true
oracle.installer.autoupdates.option=SKIP_UPDATES
EOF

./runInstaller -silent -ignorePrereq -ignoreSysPrereqs -responseFile /home/oracle/11gdatabase/response/db_install.rsp

创建数据库
dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname orcl -sid orcl -sysPassword oracle -systemPassword oracle -responseFile NO_VALUE -AUTOMATICMEMORYMANAGEMENT FALSE -datafileDestination /ora11g/app/oradata -redoLogFileSize 1024 -storageType FS -characterSet ZHS16GBK -nationalCharacterSet AL16UTF16 -databaseType OLTP -emconfiguration NONE