12c Database - Silent installation & creation of database

http://db.geeksinsight.com/ http://db.geeksinsight.com/dataguard/

Silent Installation using RunInstaller to install 12c Software, this will be useful when you do not have the X base system running on the machines (of course in real world they do not), either you need VNC or humming bird tools to install the oracle software if you want to use Oracle Universal Installer in GUI mode. Oracle provides you the ability to run the installer with silent option which is a command line parameters and installs silent and you do not need the GUI. Have a look at steps 1) Create a oracle_home directory
mkdir -p /u01/app/oracle/product/12.1.0/db_1 #Create inventory directory [root@Geek DBA11g ~]# mkdir -p /u02/app/oraInventory
[root@Geek DBA11g ~]# chown -R oracle:oinstall /u02/app/oraInventory 2) Extract the 12c Software
unzip V38500-01_2of2.zip
unzip V38500-01_1of2.zip 3) Complete Oracle Pre-requisites' – Written here 4) Modify the response file especially below parameters. Navigate to the database/response/ directory and edit the db_install.rsp for the following parameters only
oracle.install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=Geek DBA11g
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u02/app/oraInventory
ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1
ORACLE_BASE=/u01/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=asmadmin
oracle.install.db.KMDBA_GROUP=dba
SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
DECLINE_SECURITY_UPDATES=true 5) Run the runInstaller with options
[oracle@Geek DBA11g database]$ ./runInstaller -silent -ignoresysprereqs -responsefile /home/oracle/database/response/db_install.rsp
Starting Oracle Universal Installer... Checking Temp space: must be greater than 500 MB.   Actual 57706 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 1983 MB    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-11-20_10-16-24AM. Please wait ...[oracle@Geek DBA11g database]$ [WARNING] [INS-13014] Target environment does not meet some optional requirements.
   CAUSE: Some of the optional prerequisites are not met. See logs for details. /u02/app/oraInventory/logs/installActions2013-11-20_10-16-24AM.log
   ACTION: Identify the list of failed prerequisite checks from the log: /u02/app/oraInventory/logs/installActions2013- 11-20_10-16-24AM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
You can find the log of this install session at:
/u02/app/oraInventory/logs/installActions2013-11-20_10-16-24AM.log
The installation of Oracle Database 12c was successful.
Please check '/u02/app/oraInventory/logs/silentInstall2013-11-20_10-16-24AM.log' for more details. As a root user, execute the following script(s):
        1. /u01/app/oracle/product/12.1.0/db_1/root.sh Successfully Setup Software.
6) Create Database using DBCA with silent options
Create Directory structure mkdir –p /u01/app/oracle/flash_recover_area/db12c mkdir –p /u01/app/oracle/fast_recovery_area/db12c mkdir –p /u01/oradata/db12c  
 ./dbca -silent \
  -createDatabase \
  -templateName General_Purpose.dbc \
  -gdbName db12c \
  -sid db12c     \
  -SysPassword oracle123 \
  -createAsContainerDatabase true \
     -numberofPDBs 1 \
     -pdbName PDB1 \
  -SystemPassword oracle123 \
  -emConfiguration DBEXPRESS  \
  -redoLogFileSize 100   \
  -recoveryAreaDestination FRA \
  -storageType FS       \
  -listeners LISTENER12c   \
  -registerWithDirService false \
  -characterSet AL32UTF8 \
  -nationalCharacterSet AL16UTF16 \
  -databaseType MULTIPURPOSE \
   -initparams audit_file_dest='/u01/app/oracle/admin/db12c/adump' \
      -initparams compatible='12.1.0.0' \
      -initparams db_create_file_dest='/u01/oradata/db12c' \
      -initparams db_create_online_log_dest_1='/u01/oradata/db12c' \
      -initparams db_recovery_file_dest='/u01/app/oracle/flash_recovery_area' \
      -initparams pga_aggregate_target=100M \
      -initparams diagnostic_dest='/u01/app/oracle' \
      -initparams parallel_max_servers=8 \
      -initparams processes=400 \
      -initparams sga_target=524288000 \
      -initparams db_recovery_file_dest_size=4322230272
Log:- 4% complete Copying database files 5% complete 6% complete 12% complete 17% complete 22% complete 30% complete Creating and starting Oracle instance 32% complete 35% complete 36% complete 37% complete 41% complete 44% complete 45% complete 48% complete Completing Database Creation 50% complete 53% complete 55% complete 63% complete 66% complete 74% complete Creating Pluggable Databases 79% complete 100% complete Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/db12c/db12c2.log" for further details.

[oracle@Geek DBA11g bin]$ For RAC Silent Options:-
 ./dbca -silent \
  -createDatabase \
  -templateName General_Purpose.dbc \
  -gdbName db12c \
  -sid db12c     \
  -SysPassword oracle123 \
  -createAsContainerDatabase true \
     -numberofPDBs 1 \
     -pdbName PDB1 \
  -SystemPassword oracle123 \
  -emConfiguration DBEXPRESS  \
  -redoLogFileSize 100   \
  -recoveryAreaDestination FRA \
  -storageType ASM             \
    -asmsnmpPassword oracle123 \
    -asmSysPassword oracle123  \
    -diskGroupName DATA \
  -listeners LISTENER   \
  -registerWithDirService false \
  -characterSet AL32UTF8 \
  -nationalCharacterSet AL16UTF16 \
  -databaseType MULTIPURPOSE \
  -nodelist Geek DBA-rac1,Geek DBA-rac2 \
  -initparams audit_file_dest='/u01/app/oracle/admin/db12c/adump' \
      -initparams compatible='12.1.0.0' \
      -initparams db_create_file_dest='+DATA' \
      -initparams db_create_online_log_dest_1='+DATA' \
      -initparams db_create_online_log_dest_2='+FRA' \
      -initparams db_recovery_file_dest='+FRA' \
      -initparams pga_aggregate_target=100M \
      -initparams diagnostic_dest='/u01/app/oracle' \
      -initparams parallel_max_servers=8 \
      -initparams processes=400 \
      -initparams sga_target=524288000 \
      -initparams db_recovery_file_dest_size=4322230272 Next : Upgrade 11.2.0.1 to 12.1.0.1