oracle11.2R2数据库静默安装
此文是静默安装单机版oracle数据库，如需安装集群模式，或datagruad模式，修改db_install.rsp相对应的参数值
oracle 11.2R2 数据库静默安装
1.准备环境
linux操作系统（linux x86 环境：Asianux server 3,4 sp2,3;oracle linux 4,5,6;redhat 4,5,6;suse 10,11;
On Linux x86-64:Asianux server 3,4;oracle linux 4,5,6,7;redhat 4,5,6,7;suse 10,11,12;注：centos和redhat是一家，所以centos也是可以安装的版本和redhat一样就好）
oracle 环境要求：
最小内存1G
磁盘最小 5G
2.测试环境
linux x86-64环境
oracle 11.2R2
3.创建oracle用户
#groupadd oinstall
#groupadd dba
#useradd -g oinstall -G dba oracle
#id oracle
#yum install -y binutils-2.20.51.0.2-5.11.el6.i686 \
compat-libcap1-1.10-1.i686 \
compat-libstdc++-33-3.2.3-69.el6.i686 \
gcc-4.4.4-13.el6.i686 \
gcc-c++-4.4.4-13.el6.i686 \
glibc-2.12-1.7.el6.i686 \
glibc-devel-2.12-1.7.el6.i686 \
ksh \
libgcc-4.4.4-13.el6.i686 \
libstdc++-4.4.4-13.el6.i686 \
libstdc++-devel-4.4.4-13.el6.i686 \
libaio-0.3.107-10.el6.i686 \
libaio-devel-0.3.107-10.el6.i686 \
make-3.81-19.el6.i686 \
sysstat-9.0.4-11.el6.i686
#vim /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 4294967295
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
#sysctl -p
oracle hard nofile 65536
oracle hard nproc 16384
oracle soft nofile 1024
oracle soft nproc 2047
inst_group=oinstall
inventory_loc=/u01/app/oraInventory
#mkdir /u01/app/
#mkdir /u01/app/oraInventory
#mkdir -p /u01/app/product/11.2.0/dbhome_1
#chown -R oracle.oinstall /u01/
#chmod -R 775 /u01/
#vim /home/oracle/.baserc
export ORACLE_BASE=/u01/app
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export ORACLE_SID=ora1
export INVENTORY_LOCATION=$ORACLE_BASE/oraInventory
export PATH=$ORACLE_HOME/bin:$PATH
#rz
#cd /u01/
#ls
linux.x64_11gR2_database_1of2.zip
linux.x64_11gR2_database_2of2.zip
$ cd /u01/
$ unzip linux.x64_11gR2_database_1of2.zip linux.x64_11gR2_database_2of2.zip
$ cd database/response
$ cp * /opt/
$ cat db_install.rsp |grep -v '#'|grep -v ^$
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=odc
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/app/oraInventory
SELECTED_LANGUAGES=en,zh_CN
ORACLE_HOME=/u01/app/product/11.2.0/dbhome_1
ORACLE_BASE=/u01/app/
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.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.globalDBName=ora1
oracle.install.db.config.starterdb.SID=ora1
oracle.install.db.config.starterdb.characterSet=AL32UTF8
oracle.install.db.config.starterdb.memoryOption=true
oracle.install.db.config.starterdb.memoryLimit=512
oracle.install.db.config.starterdb.installExampleSchemas=false
oracle.install.db.config.starterdb.enableSecuritySettings=true
oracle.install.db.config.starterdb.password.ALL=oralce123!
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.automatedBackup.enable=false
oracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGE
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=FILE_SYSTEM
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=FILE_SYSTEM
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true #这里的更新一定要是true，这是oracle 11.2r2的bug
$ ./runInstaller -silent -ignorePrereq -force -noconfig -responseFil /opt/db_install.rsp
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 415 MB. Actual 4211 MB Passed
Checking swap space: must be greater than 150 MB. Actual 32768 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-03-02_04-58-19PM. Please wait ...$ You can find the log of this install session at:
/u01/app/oraInventory/logs/installActions2017-12-15_03-21-13PM.log
#The following configuration scripts need to be executed as the "root" user.
#!/bin/sh
#Root scripts to run
/u01/app/oracle/product/11.2/dbhome_1/root.sh
To execute the configuration scripts:
1. Open a terminal window
2. Log in as "root"
3. Run the scripts
4. Return to this window and hit "Enter" key to continue
Successfully Setup Software.
#/u01/app/oracle/product/11.2/dbhome_1/root.sh
#cat /u01/app/product/11.2.0/dbhome_1/install/root_odc_2017-12-15_15-24-32.log
Running Oracle 11g root.sh script...
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/product/11.2.0/dbhome_1
Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
#su - oracle
$ netca /silent /responsefile /opt/netca.rsp
Listener Control complete
Listener started successfully.
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0
$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 15-DEC-2017 17:17:50
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 15-DEC-2017 15:44:41
Uptime 0 days 1 hr. 33 min. 9 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/diag/tnslsnr/odc/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=odc)(PORT=1521)))
Services Summary...
Service "ora1" has 1 instance(s).
Instance "ora1", status READY, has 1 handler(s) for this service...
Service "ora1XDB" has 1 instance(s).
Instance "ora1", status READY, has 1 handler(s) for this service...
The command completed successfully
$ cat dbca.rsp |grep -v ^# |grep -v ^$
[GENERAL]
RESPONSEFILE_VERSION = "11.2.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE]
GDBNAME = "ora1"
SID = "ora1"
TEMPLATENAME = "General_Purpose.dbc"
TOTALMEMORY = "512"
$ dbca -silent -responseFile /opt/dbca.rsp
Completing Database Creation
66% complete
70% complete
73% complete
85% complete
96% complete
100% complete
Look at the log file "/u01/app/cfgtoollogs/dbca/orcl11g/orcl11g.log" for further details.
$ ps -ef | grep ora_ | grep -v grep | wc -l
23
$ ps -ef | grep ora_ | grep -v grep
oracle 67680 1 0 15:56 ? 00:00:00 ora_pmon_ora1
oracle 67682 1 0 15:56 ? 00:00:02 ora_vktm_ora1
oracle 67686 1 0 15:56 ? 00:00:00 ora_gen0_ora1
oracle 67688 1 0 15:56 ? 00:00:00 ora_diag_ora1
oracle 67690 1 0 15:56 ? 00:00:00 ora_dbrm_ora1
oracle 67692 1 0 15:56 ? 00:00:00 ora_psp0_ora1
oracle 67694 1 0 15:56 ? 00:00:02 ora_dia0_ora1
oracle 67696 1 0 15:56 ? 00:00:00 ora_mman_ora1
oracle 67698 1 0 15:56 ? 00:00:00 ora_dbw0_ora1
oracle 67700 1 0 15:56 ? 00:00:00 ora_lgwr_ora1
oracle 67702 1 0 15:56 ? 00:00:04 ora_ckpt_ora1
oracle 67704 1 0 15:56 ? 00:00:00 ora_smon_ora1
oracle 67706 1 0 15:56 ? 00:00:00 ora_reco_ora1
oracle 67708 1 0 15:56 ? 00:00:01 ora_mmon_ora1
oracle 67710 1 0 15:56 ? 00:00:01 ora_mmnl_ora1
oracle 67712 1 0 15:56 ? 00:00:00 ora_d000_ora1
oracle 67714 1 0 15:56 ? 00:00:00 ora_s000_ora1
oracle 67722 1 0 15:56 ? 00:00:00 ora_qmnc_ora1
oracle 67736 1 0 15:56 ? 00:00:01 ora_cjq0_ora1
oracle 67739 1 0 15:56 ? 00:00:00 ora_q000_ora1
oracle 67741 1 0 15:56 ? 00:00:00 ora_q001_ora1
oracle 67823 1 0 16:01 ? 00:00:00 ora_smco_ora1
oracle 69342 1 0 17:21 ? 00:00:00 ora_w000_ora1
$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri Dec 15 17:22:35 2017
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show user
USER is "SYS"
SQL> select name ,dbid,open_mode from v$database;
NAME DBID OPEN_MODE
--------- ---------- --------------------
ORA1 1439683635 READ WRITE
SQL> col COMP_ID format a8
SQL> col COMP_NAME format a35
SQL> col VERSION format a12
SQL> col schema format a12
SQL> col OTHER_SCHEMAS format a45
SQL> select comp_id,comp_name,version,schema,other_schemas from dba_registry order by 1;
COMP_ID COMP_NAME VERSION SCHEMA
-------- ----------------------------------- ------------ ------------
OTHER_SCHEMAS
---------------------------------------------
AMD OLAP Catalog 11.2.0.1.0 OLAPSYS
APEX Oracle Application Express 3.2.1.00.10 APEX_030200
FLOWS_FILES
APS OLAP Analytic Workspace 11.2.0.1.0 SYS
COMP_ID COMP_NAME VERSION SCHEMA
-------- ----------------------------------- ------------ ------------
OTHER_SCHEMAS ---------------------------------------------
CATALOG Oracle Database Catalog Views 11.2.0.1.0 SYS
CATJAVA Oracle Database Java Packages 11.2.0.1.0 SYS
CATPROC Oracle Database Packages and Types 11.2.0.1.0 SYS
APPQOSSYS,DBSNMP,DIP,ORACLE_OCM,OUTLN,SYSTEM
COMP_ID COMP_NAME VERSION SCHEMA
-------- ----------------------------------- ------------ ------------
OTHER_SCHEMAS---------------------------------------------
CONTEXT Oracle Text 11.2.0.1.0 CTXSYS
EM Oracle Enterprise Manager 11.2.0.1.0 SYSMAN
EXF Oracle Expression Filter 11.2.0.1.0 EXFSYS
COMP_ID COMP_NAME VERSION SCHEMA
-------- ----------------------------------- ------------ ------------
OTHER_SCHEMAS---------------------------------------------
JAVAVM JServer JAVA Virtual Machine 11.2.0.1.0 SYS
ORDIM Oracle Multimedia 11.2.0.1.0 ORDSYS
MDSYS,ORDDATA,ORDPLUGINS,SI_INFORMTN_SCHEMA
OWB OWB 11.2.0.1.0 OWBSYS
COMP_ID COMP_NAME VERSION SCHEMA
-------- ----------------------------------- ------------ ------------
OTHER_SCHEMAS---------------------------------------------
OWM Oracle Workspace Manager 11.2.0.1.0 WMSYS
RUL Oracle Rules Manager 11.2.0.1.0 EXFSYS
SDO Spatial 11.2.0.1.0 MDSYS
COMP_ID COMP_NAME VERSION SCHEMA
-------- ----------------------------------- ------------ ------------
OTHER_SCHEMAS---------------------------------------------
XDB Oracle XML Database 11.2.0.1.0 XDB
ANONYMOUS,XS$NULL
XML Oracle XDK 11.2.0.1.0 SYS
XOQ Oracle OLAP API 11.2.0.1.0 SYS
18 rows selected.
SQL>shutdown immediate;
SQL> startup mount;
SQL> alter database archivelog; --开启归档日志
SQL> alter database flashback on; --设置闪回区
SQL> alter database open;
SQL> execute utl_recomp.recomp_serial();
SQL> alter system archive log current;网站题目：oracle11.2R2数据库静默安装
网页URL：http://myzitong.com/article/gddopj.html