12c Database : Silent installation & creation of database

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

-Thanks

Geek DBA