oracle 11.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磁盘最小 5G2.测试环境linux x86-64环境oracle 11.2R23.创建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.conffs.aio-max-nr = 1048576fs.file-max = 6815744kernel.shmall = 2097152kernel.shmmax = 4294967295kernel.shmmni = 4096kernel.sem = 250 32000 100 128net.ipv4.ip_local_port_range = 9000 65500net.core.rmem_default = 262144net.core.rmem_max = 4194304net.core.wmem_default = 262144net.core.wmem_max = 1048576#sysctl -poracle          hard    nofile          65536oracle          hard    nproc           16384oracle          soft    nofile          1024oracle          soft    nproc           2047inst_group=oinstallinventory_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/.basercexport ORACLE_BASE=/u01/appexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1export ORACLE_SID=ora1export INVENTORY_LOCATION=$ORACLE_BASE/oraInventoryexport PATH=$ORACLE_HOME/bin:$PATH#rz#cd /u01/#ls linux.x64_11gR2_database_1of2.ziplinux.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_0oracle.install.option=INSTALL_DB_SWONLYORACLE_HOSTNAME=odcUNIX_GROUP_NAME=oinstallINVENTORY_LOCATION=/u01/app/oraInventorySELECTED_LANGUAGES=en,zh_CNORACLE_HOME=/u01/app/product/11.2.0/dbhome_1ORACLE_BASE=/u01/app/oracle.install.db.InstallEdition=EEoracle.install.db.isCustomInstall=falseoracle.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.0oracle.install.db.DBA_GROUP=dbaoracle.install.db.OPER_GROUP=oinstalloracle.install.db.config.starterdb.type=GENERAL_PURPOSEoracle.install.db.config.starterdb.globalDBName=ora1oracle.install.db.config.starterdb.SID=ora1oracle.install.db.config.starterdb.characterSet=AL32UTF8oracle.install.db.config.starterdb.memoryOption=trueoracle.install.db.config.starterdb.memoryLimit=512oracle.install.db.config.starterdb.installExampleSchemas=falseoracle.install.db.config.starterdb.enableSecuritySettings=trueoracle.install.db.config.starterdb.password.ALL=oralce123!oracle.install.db.config.starterdb.control=DB_CONTROLoracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=oracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=falseoracle.install.db.config.starterdb.automatedBackup.enable=falseoracle.install.db.config.starterdb.storageType=FILE_SYSTEM_STORAGEoracle.install.db.config.starterdb.fileSystemStorage.dataLocation=FILE_SYSTEMoracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=FILE_SYSTEMSECURITY_UPDATES_VIA_MYORACLESUPPORT=falseDECLINE_SECURITY_UPDATES=true #这里的更新一定要是true，这是oracle 11.2r2的bug$ ./runInstaller -silent  -ignorePrereq  -force -noconfig -responseFil /opt/db_install.rspStarting Oracle Universal Installer...Checking Temp space: must be greater than 415 MB.   Actual 4211 MB    PassedChecking swap space: must be greater than 150 MB.   Actual 32768 MB    PassedPreparing 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.shTo 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 continueSuccessfully 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.logRunning Oracle 11g root.sh script...The following environment variables are set as:        ORACLE_OWNER= oracle        ORACLE_HOME=  /u01/app/product/11.2.0/dbhome_1Creating /etc/oratab file...Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished 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 statusLSNRCTL for Linux: Version 11.2.0.1.0 - Production on 15-DEC-2017 17:17:50Copyright (c) 1991, 2009, Oracle.  All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))STATUS of the LISTENER------------------------Alias                     LISTENERVersion                   TNSLSNR for Linux: Version 11.2.0.1.0 - ProductionStart Date                15-DEC-2017 15:44:41Uptime                    0 days 1 hr. 33 min. 9 secTrace Level               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFListener Parameter File   /u01/app/product/11.2.0/dbhome_1/network/admin/listener.oraListener Log File         /u01/app/diag/tnslsnr/odc/listener/alert/log.xmlListening 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.rspCompleting Database Creation66% complete70% complete73% complete85% complete96% complete100% completeLook at the log file "/u01/app/cfgtoollogs/dbca/orcl11g/orcl11g.log" for further details.$ ps -ef | grep ora_ | grep -v grep | wc -l23$ ps -ef | grep ora_ | grep -v greporacle    67680      1  0 15:56 ?        00:00:00 ora_pmon_ora1oracle    67682      1  0 15:56 ?        00:00:02 ora_vktm_ora1oracle    67686      1  0 15:56 ?        00:00:00 ora_gen0_ora1oracle    67688      1  0 15:56 ?        00:00:00 ora_diag_ora1oracle    67690      1  0 15:56 ?        00:00:00 ora_dbrm_ora1oracle    67692      1  0 15:56 ?        00:00:00 ora_psp0_ora1oracle    67694      1  0 15:56 ?        00:00:02 ora_dia0_ora1oracle    67696      1  0 15:56 ?        00:00:00 ora_mman_ora1oracle    67698      1  0 15:56 ?        00:00:00 ora_dbw0_ora1oracle    67700      1  0 15:56 ?        00:00:00 ora_lgwr_ora1oracle    67702      1  0 15:56 ?        00:00:04 ora_ckpt_ora1oracle    67704      1  0 15:56 ?        00:00:00 ora_smon_ora1oracle    67706      1  0 15:56 ?        00:00:00 ora_reco_ora1oracle    67708      1  0 15:56 ?        00:00:01 ora_mmon_ora1oracle    67710      1  0 15:56 ?        00:00:01 ora_mmnl_ora1oracle    67712      1  0 15:56 ?        00:00:00 ora_d000_ora1oracle    67714      1  0 15:56 ?        00:00:00 ora_s000_ora1oracle    67722      1  0 15:56 ?        00:00:00 ora_qmnc_ora1oracle    67736      1  0 15:56 ?        00:00:01 ora_cjq0_ora1oracle    67739      1  0 15:56 ?        00:00:00 ora_q000_ora1oracle    67741      1  0 15:56 ?        00:00:00 ora_q001_ora1oracle    67823      1  0 16:01 ?        00:00:00 ora_smco_ora1oracle    69342      1  0 17:21 ?        00:00:00 ora_w000_ora1$ sqlplus  / as sysdbaSQL*Plus: Release 11.2.0.1.0 Production on Fri Dec 15 17:22:35 2017Copyright (c) 1982, 2009, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> show userUSER is "SYS"SQL> select name ,dbid,open_mode from v$database;NAME            DBID OPEN_MODE--------- ---------- --------------------ORA1      1439683635 READ WRITESQL> col COMP_ID format a8SQL> col COMP_NAME format a35SQL> col VERSION format a12SQL> col schema format a12SQL> col OTHER_SCHEMAS format a45SQL> 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   OLAPSYSAPEX     Oracle Application Express          3.2.1.00.10  APEX_030200FLOWS_FILESAPS      OLAP Analytic Workspace             11.2.0.1.0   SYSCOMP_ID  COMP_NAME                           VERSION      SCHEMA-------- ----------------------------------- ------------ ------------OTHER_SCHEMAS ---------------------------------------------CATALOG  Oracle Database Catalog Views       11.2.0.1.0   SYSCATJAVA  Oracle Database Java Packages       11.2.0.1.0   SYSCATPROC  Oracle Database Packages and Types  11.2.0.1.0   SYSAPPQOSSYS,DBSNMP,DIP,ORACLE_OCM,OUTLN,SYSTEMCOMP_ID  COMP_NAME                           VERSION      SCHEMA-------- ----------------------------------- ------------ ------------OTHER_SCHEMAS---------------------------------------------CONTEXT  Oracle Text                         11.2.0.1.0   CTXSYSEM       Oracle Enterprise Manager           11.2.0.1.0   SYSMANEXF      Oracle Expression Filter            11.2.0.1.0   EXFSYSCOMP_ID  COMP_NAME                           VERSION      SCHEMA-------- ----------------------------------- ------------ ------------OTHER_SCHEMAS---------------------------------------------JAVAVM   JServer JAVA Virtual Machine        11.2.0.1.0   SYSORDIM    Oracle Multimedia                   11.2.0.1.0   ORDSYSMDSYS,ORDDATA,ORDPLUGINS,SI_INFORMTN_SCHEMAOWB      OWB                                 11.2.0.1.0   OWBSYSCOMP_ID  COMP_NAME                           VERSION      SCHEMA-------- ----------------------------------- ------------ ------------OTHER_SCHEMAS---------------------------------------------OWM      Oracle Workspace Manager            11.2.0.1.0   WMSYSRUL      Oracle Rules Manager                11.2.0.1.0   EXFSYSSDO      Spatial                             11.2.0.1.0   MDSYSCOMP_ID  COMP_NAME                           VERSION      SCHEMA-------- ----------------------------------- ------------ ------------OTHER_SCHEMAS---------------------------------------------XDB      Oracle XML Database                 11.2.0.1.0   XDBANONYMOUS,XS$NULLXML      Oracle XDK                          11.2.0.1.0   SYSXOQ      Oracle OLAP API                     11.2.0.1.0   SYS18 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;