一、 系统环境基本设置
1.1、安装相关软件
yum install -y vim tree net-tools unzip
yum install -y compat-libstdc++-33 elfutils-libelf-devel gcc* glibc-* ksh libaio libaio-devel libstdc++-devel unixODBC unixODBC-devel sysstat
1.2、创建用户组和目录
/usr/sbin/groupadd -g 1000 oinstall
/usr/sbin/groupadd -g 1031 dba
/usr/sbin/useradd -u 1101 -g oinstall -G dba oracle
passwd oracle
mkdir -p /data/u01/oraInventory
mkdir -p /data/u01/app/oracle
mkdir -p /data/oradata/primary
mkdir -p /data/oradata/primarytbs
mkdir -p /data/oradata/active
chown -R oracle.oinstall /data/u01/app/oracle
chown -R oracle.oinstall /data/u01
chmod -R 775 /data/u01/app/oracle
chmod -R 775 /data/u01
chown -R oracle.oinstall /data
chmod -R 775 /data
1.3、系统资源限制
cat >> /etc/sysctl.conf << EOF
## add for oracle
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
kernel.panic_on_oops = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.conf.all.rp_filter = 2
net.ipv4.conf.default.rp_filter = 2
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
EOF
/sbin/sysctl -p
cat >> /etc/security/limits.d/20-nproc.conf << EOF
* soft nproc 4096
root soft nproc unlimited
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft nproc 16384
oracle hard nproc 16384
oracle soft stack 10240
oracle hard stack 32768
oracle hard memlock 134217728
oracle soft memlock 134217728
EOF
二、Oracle数据库的安装
2.1、修改oracle环境变量,安装Oracle
export ORACLE_BASE = /data/u01/app/oracle
export ORACLE_HOME = /data/u01/app/oracle/product/11.2.0/db_1
export ORACLE_SID = primary
export GDBNAME = primary
export LD_LIBRARY_PATH = $ORACLE_HOME /lib:$LD_LIBRARY_PATH :. export PATH = $ORACLE_HOME /bin:$PATH :.
su - oracle
unzip linux.x64_11gR2_database_1of2.zip
unzip linux.x64_11gR2_database_2of2.zip
cd /homa/oacle/datebase/
vim response/db_install.rsp
oracle.install.responseFileVersion = /oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
oracle.install.option = INSTALL_DB_SWONLY
ORACLE_HOSTNAME = primary
UNIX_GROUP_NAME = oinstall
INVENTORY_LOCATION = /data/u01/app/oracle/oraInventory
SELECTED_LANGUAGES = en,zh_CN
ORACLE_HOME = /data/u01/app/oracle/product/11.2.0/db_1
ORACLE_BASE = /data/u01/app/oracle
oracle.install.db.InstallEdition = EE
oracle.install.db.isCustomInstall = false
oracle.install.db.customComponents = oracle.server:11.2.0.1.0,oracle.sysman.ccr:10.2.7.0.0,oracle.xdk:11.2.0.1.0,oracle.rdbms.oci:11.2.0.1.0,oracle.network:11.2.0.1.0,oracle.network.listener:11.2.0.1.0,oracle.rdbms:11.2.0.1.0,oracle.options:11.2.0.1.0,oracle.rdbms.partitioning:11.2.0.1.0,oracle.oraolap:11.2.0.1.0,oracle.rdbms.dm:11.2.0.1.0,oracle.rdbms.dv:11.2.0.1.0,orcle.rdbms.lbac:11.2.0.1.0,oracle.rdbms.rat:11.2.0.1.0
oracle.install.db.DBA_GROUP = dba
oracle.install.db.OPER_GROUP = oinstall
oracle.install.db.CLUSTER_NODES =
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.dbcontrol.enableEmailNotification = false
oracle.install.db.config.starterdb.dbcontrol.emailAddress =
oracle.install.db.config.starterdb.dbcontrol.SMTPServer =
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 =