oracle database 12.1.0.1 on centos_6.4_x64 silent installation

oracle database 12.1.0.1 on centos_6.4_x64 installation
1. /etc/hosts
192.168.16.203  hadoop3

2. 检查系统需求
物理内存大小:  grep MemTotal /proc/meminfo
交换分区大小:  grep SwapTotal /proc/meminfo
/tmp目录大小： df -h /tmp
系统剩余空间:  df -h
系统平台架构:  uname -m

磁盘需求：
至少系统运行level 3, OUI安装至少1024x768分辨率
软件安装,企业版磁盘空间要6.4GB, 已经 fast recovery area区大小默认4GB
/tmp空间至少1GB

内存需求：
最小1GB, 推荐2GB+

3. 检查依赖软件, 以下软件必须安装
binutils-2.20.51.0.2-5.11.el6 (x86_64)
compat-libcap1-1.10-1 (x86_64)
compat-libstdc++-33-3.2.3-69.el6 (x86_64)
compat-libstdc++-33-3.2.3-69.el6 (i686)
gcc-4.4.4-13.el6 (x86_64)
gcc-c++-4.4.4-13.el6 (x86_64)
glibc-2.12-1.7.el6 (i686)
glibc-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6 (i686)
ksh
libgcc-4.4.4-13.el6 (i686)
libgcc-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6 (i686)
libstdc++-devel-4.4.4-13.el6 (x86_64)
libstdc++-devel-4.4.4-13.el6 (i686)
libaio-0.3.107-10.el6 (x86_64)
libaio-0.3.107-10.el6 (i686)
libaio-devel-0.3.107-10.el6 (x86_64)
libaio-devel-0.3.107-10.el6 (i686)
libXext-1.1 (x86_64)
libXext-1.1 (i686)
libXtst-1.0.99.2 (x86_64)
libXtst-1.0.99.2 (i686)
libX11-1.3 (x86_64)
libX11-1.3 (i686)
libXau-1.0.5 (x86_64)
libXau-1.0.5 (i686)
libxcb-1.5 (x86_64)
libxcb-1.5 (i686)
libXi-1.3 (x86_64)
libXi-1.3 (i686)
make-3.81-19.el6
sysstat-9.0.4-11.el6 (x86_64)


rpm -q binutils-*.x86_64  compat-libcap1-*.x86_64  compat-libstdc++-33-*.x86_64  compat-libstdc++-33-*.i686  gcc-*.x86_64  gcc-c++-*.x86_64  glibc-2.12-*.i686  glibc-2.12-*.x86_64  glibc-devel-*.x86_64  glibc-devel-*.i686 libgcc-*.i686  libgcc-*.x86_64  libstdc++-*.x86_64  libstdc++-*.i686  libstdc++-devel-*.x86_64  libstdc++-devel-*.i686  libaio-*.x86_64  libaio-*.i686  libaio-devel-*.x86_64  libaio-devel-*.i686  libXext-*.x86_64  libXext-*.i686  libXtst-*.x86_64  libXtst-*.i686  libX11-*.x86_64  libX11-*.i686  libXau-*.x86_64  libXau-*.i686  libxcb-*.x86_64  libxcb-*.i686  libXi-*.x86_64  libXi-*.i686  make  sysstat-*.x86_64
 

yum install -y binutils-*.x86_64  compat-libcap1-*.x86_64  compat-libstdc++-33-*.x86_64  compat-libstdc++-33-*.i686  gcc-*.x86_64  gcc-c++-*.x86_64  glibc-2.12-*.i686  glibc-2.12-*.x86_64  glibc-devel-*.x86_64  glibc-devel-*.i686 libgcc-*.i686  libgcc-*.x86_64  libstdc++-*.x86_64  libstdc++-*.i686  libstdc++-devel-*.x86_64  libstdc++-devel-*.i686  libaio-*.x86_64  libaio-*.i686  libaio-devel-*.x86_64  libaio-devel-*.i686  libXext-*.x86_64  libXext-*.i686  libXtst-*.x86_64  libXtst-*.i686  libX11-*.x86_64  libX11-*.i686  libXau-*.x86_64  libXau-*.i686  libxcb-*.x86_64  libxcb-*.i686  libXi-*.x86_64  libXi-*.i686  make  sysstat-*.x86_64

4. 创建相关用户、组
groupadd -g 501 oinstall
groupadd -g 502 dba
groupadd -g 503 oper
useradd -u 501 -g oinstall -G dba,oper oracle
passwd oracle


5. /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 1536870912
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

sysctl -p


6. vim /etc/profile
if [ "$USER" = "oracle" ]
then
    if [ "$SHELL" = "/bin/ksh" ]
    then
        ulimit -p 16384 -n 65536
    else
        ulimit -u 16384
        ulimit -n 65536
    fi
fi


7. vim /etc/pam.d/login
session   required  /lib64/security/pam_limits.so

8. vim /etc/security/limits.conf
oracle    soft   nofile   1024
oracle    hard   nofile   65536
oracle    soft   nproc    2047
oracle    hard   nproc    16384
oracle    soft   stack    10240
oracle    hard   stack    32768


9. 创建安装目录、配置权限
mkdir /opt/app/oracle/product/12.1.0/db1 -p
mkdir /mysqldata/oradata
chown -R　oracle:oinstall /opt/app
chown -R  oracle:oinstall /mysqldata/oradata

10. 以oracle用户登录, 配置oracle用户环境变量~/.bash_profile
ORACLE_HOSTNAME=hadoop3
ORACLE_UNQNAME=ora12c
ORACLE_BASE=/opt/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/12.1.0/db1
ORACLE_SID=ora12c
PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export ORACLE_HOSTNAME ORACLE_UNQNAME ORACLE_BASE ORACLE_HOME ORACLE_SID PATH LD_LIBRARY_PATH CLASSPATH NLS_LANG

11. 修改安装介质属性、准备rsp文件开始安装
1). 仅安装软件
chown -R oracle:oinstall /mysqldata/database
su - oracle
cd /mysqldata/database/response
cp db_install.rsp ~/install_db_swonly.rsp
vim ~/install_db_swonly.rsp

[oracle@hadoop3 database12c]$ grep -v "^#" ~/install_db_swonly.rsp  | grep -v "^$"
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.1.0
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=hadoop3
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/opt/app/oraInventory
SELECTED_LANGUAGES=en
ORACLE_HOME=/opt/app/oracle/product/12.1.0/db1
ORACLE_BASE=/opt/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=oper
oracle.install.db.BACKUPDBA_GROUP=dba
oracle.install.db.DGDBA_GROUP=dba
oracle.install.db.KMDBA_GROUP=dba
oracle.install.db.rac.configurationType=
oracle.install.db.CLUSTER_NODES=
oracle.install.db.isRACOneInstall=
oracle.install.db.racOneServiceName=
oracle.install.db.rac.serverpoolName=
oracle.install.db.rac.serverpoolCardinality=
oracle.install.db.config.starterdb.type=
oracle.install.db.config.starterdb.globalDBName=
oracle.install.db.config.starterdb.SID=
oracle.install.db.ConfigureAsContainerDB=
oracle.install.db.config.PDBName=
oracle.install.db.config.starterdb.characterSet=
oracle.install.db.config.starterdb.memoryOption=
oracle.install.db.config.starterdb.memoryLimit=
oracle.install.db.config.starterdb.installExampleSchemas=
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.DBSNMP=
oracle.install.db.config.starterdb.password.PDBADMIN=
oracle.install.db.config.starterdb.managementOption=
oracle.install.db.config.starterdb.omsHost=
oracle.install.db.config.starterdb.omsPort=
oracle.install.db.config.starterdb.emAdminUser=
oracle.install.db.config.starterdb.emAdminPassword=
oracle.install.db.config.starterdb.enableRecovery=
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=SKIP_UPDATES
oracle.installer.autoupdates.downloadUpdatesLoc=
AUTOUPDATES_MYORACLESUPPORT_USERNAME=
AUTOUPDATES_MYORACLESUPPORT_PASSWORD=

2). 创建监听
cp netca.rsp ~/netca.rsp
vim ~/netca.rsp
netca  -silent -responseFile /home/oracle/netca.rsp
lsnrctl status

[oracle@hadoop3 database12c]$ grep -v "^#" ~/netca.rsp  | grep -v "^$"
[GENERAL]
RESPONSEFILE_VERSION="12.1"
CREATE_TYPE="CUSTOM"
SHOW_GUI=false
[oracle.net.ca]
INSTALLED_COMPONENTS={"server","net8","javavm"}
INSTALL_TYPE=""typical""
LISTENER_NUMBER=1
LISTENER_NAMES={"LISTENER"}
LISTENER_PROTOCOLS={"TCP;1521"}
LISTENER_START=""LISTENER""
NAMING_METHODS={"TNSNAMES","ONAMES","HOSTNAME"}
NSN_NUMBER=1
NSN_NAMES={"EXTPROC_CONNECTION_DATA"}
NSN_SERVICE={"PLSExtProc"}
NSN_PROTOCOLS={"TCP;HOSTNAME;1521"}


3). 建库
cp dbca.rsp ~/dbca.rsp
vim ~/dbca.rsp
dbca -silent -responseFile /home/oracle/dbca.rsp

[oracle@hadoop3 database12c]$ dbca -silent -responseFile /home/oracle/dbca.rsp
Copying database files
1% complete
3% complete
11% complete
18% complete
26% complete
33% complete
37% complete
Creating and starting Oracle instance
40% complete
45% complete
50% complete
55% complete
60% complete
61% complete
62% complete
65% complete
Completing Database Creation
69% complete
73% complete
76% complete
88% complete
99% complete
100% complete
Look at the log file "/opt/app/oracle/cfgtoollogs/dbca/ora12c/ora12c.log" for further details.

[oracle@hadoop3 database12c]$ grep -v "^#" ~/dbca.rsp  | grep -v "^$"
[GENERAL]
RESPONSEFILE_VERSION = "12.1.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE]
GDBNAME = "ora12c"
SID = "ora12c"
TEMPLATENAME = "General_Purpose.dbc"
SYSPASSWORD = "password"
SYSTEMPASSWORD = "password"
DATAFILEDESTINATION = /mysqldata/oradata
CHARACTERSET = "AL32UTF8"
NATIONALCHARACTERSET= "AL16UTF16"
SAMPLESCHEMA=TRUE
TOTALMEMORY = "800"
[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 = "orcl12.us.oracle.com"
[CONFIGUREDATABASE]
[ADDINSTANCE]
DB_UNIQUE_NAME = "orcl12c.us.oracle.com"
NODELIST=
SYSDBAUSERNAME = "sys"
[DELETEINSTANCE]
DB_UNIQUE_NAME = "orcl12c.us.oracle.com"
INSTANCENAME = "orcl12c"
SYSDBAUSERNAME = "sys"
[CREATEPLUGGABLEDATABASE]
SOURCEDB = "orcl"
PDBNAME = "PDB1"
[UNPLUGDATABASE]
SOURCEDB = "orcl"
PDBNAME = "PDB1"
ARCHIVETYPE = "TAR"