Oracle 11G Release 2 installation on Linux x86-64 (silent installation using response file method)

Disk Space Requirements on Linux x86-64 , Disk Space requirement for Software Files -
 
Enterprise Edition :- 4.7 GB
Standard Edition :- 4.6 GB

RAM requirement -

Minimum: 1 GB of RAM
Recommended: 2 GB of RAM or more
To determine the RAM size, enter the following command:
# grep MemTotal /proc/meminfo

Swap Space Requirement for Linux RAM Swap Space -
 
Between 1 GB and 2 GB 1.5 times the size of RAM
Between 2 GB and 16 GB Equal to the size of RAM
More than 16 GB 16 GB
To determine the size of the configured swap space, enter the following command:
# grep SwapTotal /proc/meminfo

Operating System Requirements for x86-64 Linux -
 
¦ Oracle Linux 4 Update 7
¦ Oracle Linux 5 Update 2 (with Red Hat Compatible Kernel)
¦ Oracle Linux 5 Update 5
¦ Oracle Linux 6
¦ Oracle Linux 6 (with Red Hat Compatible Kernel)
¦ Red Hat Enterprise Linux 4 Update 7
¦ Red Hat Enterprise Linux 5 Update 2
¦ Red Hat Enterprise Linux 5 Update 5 (with the Oracle Unbreakable Enterprise Kernel for Linux)
¦ Red Hat Enterprise Linux 6
¦ Red Hat Enterprise Linux 6 (with the Oracle Unbreakable Enterprise Kernel for Linux)

Kernel Requirements -

The following are the kernel requirements for Oracle Database 11g Release 2 (11.2):
– On Oracle Linux 4 and Red Hat Enterprise Linux 4
2.6.9 or later
– On Oracle Linux 5 Update 2 with Red Hat Compatible Kernel
2.6.18 or later
– On Oracle Linux 5 Update 5 with Red Hat Compatible Kernel
2.6.18 or later
– On Oracle Linux 5 Update 5 with Unbreakable Enterprise Kernel
2.6.32-100.0.19 or later
– On Oracle Linux 6
2.6.32-100.28.5.el6.x86_64 or later
– On Oracle Linux 6 with Red Hat Compatible Kernel
2.6.32-71.el6.x86_64 or later
– On Red Hat Enterprise Linux 5 Update 2
2.6.18 or later
– On Red Hat Enterprise Linux 5 Update 5
2.6.18 or later
– On Red Hat Enterprise Linux 5 Update 5 with Unbreakable Enterprise Kernel
2.6.32 or later
– On Red Hat Enterprise Linux 6
2.6.32-71.el6.x86_64 or later
– On Red Hat Enterprise Linux 6 with Unbreakable Enterprise Kernel
2.6.32-100.28.5.el6.x86_64 or later

RPM Requirment -

Note: Starting with Oracle Database 11g Release 2 (11.2.0.2), all the 32-bit packages, except for gcc-32bit-4.3, listed in the following table are no longer required for installing a database on Linux x86-64. Only the 64-bit packages are required. However, for any Oracle Database 11g release before 11.2.0.2, both the 32-bit and 64-bit packages listed in the following table are required.
Command to check rpm on server (Below is example to check binutils-2.15.92.0.2 package)
#rpm –q package_name
#rpm –q binutils-2.15.92.0.2
Or
# rpm –q binutils

Packages for Oracle Linux 4 and Red Hat Enterprise Linux 4 must be installed:
Requires below packages (or later versions)
binutils-2.15.92.0.2
compat-libstdc++-33-3.2.3
compat-libstdc++-33-3.2.3 (32 bit)
elfutils-libelf-0.97
elfutils-libelf-devel-0.97
expat-1.95.7
gcc-3.4.6
gcc-c++-3.4.6
glibc-2.3.4-2.41
glibc-2.3.4-2.41 (32 bit)
glibc-common-2.3.4
glibc-devel-2.3.4
glibc-headers-2.3.4
libaio-0.3.105
libaio-0.3.105 (32 bit)
libaio-devel-0.3.105
libaio-devel-0.3.105 (32 bit)
libgcc-3.4.6
libgcc-3.4.6 (32-bit)
libstdc++-3.4.6
libstdc++-3.4.6 (32 bit)
libstdc++-devel 3.4.6
make-3.80
numactl-0.6.4.x86_64
pdksh-5.2.14
sysstat-5.0.5

Packages for Asianux 3, Oracle Linux 5, and Red Hat Enterprise Linux 5 must be installed:
Requires below packages (or later versions)
binutils-2.17.50.0.6
compat-libstdc++-33-3.2.3
compat-libstdc++-33-3.2.3 (32 bit)
elfutils-libelf-0.125
elfutils-libelf-devel-0.125
gcc-4.1.2
gcc-c++-4.1.2
glibc-2.5-24
glibc-2.5-24 (32 bit)
glibc-common-2.5
glibc-devel-2.5
glibc-devel-2.5 (32 bit)
glibc-headers-2.5
ksh-20060214
libaio-0.3.106
libaio-0.3.106 (32 bit)
libaio-devel-0.3.106
libaio-devel-0.3.106 (32 bit)
libgcc-4.1.2
libgcc-4.1.2 (32 bit)
libstdc++-4.1.2
libstdc++-4.1.2 (32 bit)
libstdc++-devel 4.1.2
make-3.81
sysstat-7.0.2

Packages for Oracle Linux 6, and Red Hat Enterprise Linux 6 must be installed:
Requires below packages (or later versions)
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
make-3.81-19.el6
sysstat-9.0.4-11.el6 (x86_64)

Installation steps - 

Creating Required Operating System Groups and Users -
$/usr/sbin/groupadd oinstall
$/usr/sbin/groupadd dba
$/usr/sbin/useradd -g oinstall -G dba oracle

Configuring Kernel Parameters and Resource Limits -
 
 1) Add Below lines in /etc/sysctl.conf -

fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
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

Enter the following command to change the current values of the kernel parameters:
$/sbin/sysctl –p

2) Add below lines in /etc/security/limits.conf  -

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

Creating Required Directories -
Create directory for oracle binary and owner should be oracle:oinstall
Like /oracle/app/11.2.0 so this will be your ORACLE_HOME.

Copy the oracle software and unzip -
Below two files are for version 11.2.0.4  (For ex. Below two files are present at location /software/oracle)
p13390677_112040_Linux-x86-64_1of7.zip
p13390677_112040_Linux-x86-64_2of7.zip

unzip above two files on same location
#cd /software/oracle
#unzip p13390677_112040_Linux-x86-64_1of7.zip
#unzip p13390677_112040_Linux-x86-64_2of7.zip
Once both the zip files unzipped , you will find directory with name “database” on same location.

Do installation prechecks using below two Options -

Option 1)software installation prechecks execute below command -
#cd /software/oracle/database
#./runInstaller -silent –executePrereqs

Above command creates a logfile where you can get result of prechecks on the server.
Do the needful for any precheck failure.

Option 2) Prechecks using oracle RDA tool -

Download the required RDA from metalink and copy it in the directory for ex /tmp/p13738619_427_LINUX.ZIP   — this is the RDA file downloaded from oracle metalink.Unzip the RDA in the /tmp directory.
#unzip p13738619_427_LINUX.ZIP
After unzip you see the RDA directory.Go inside the RDA directory.
#cd /tmp/RDA
Run the below command to execute the RDA.
./rda.pl -T hcve

Below is the sample output for the same.
It will ask for multiple input, first select the number from the list and press enter. Here we selected 4 (for 11.2.0 version).For other input just press enter.

# ./rda.sh -T hcve
Processing HCVE tests …
Available Pre-Installation Rule Sets:
1. Oracle Database 10g R1 (10.1.0) Preinstall (Linux)
2. Oracle Database 10g R2 (10.2.0) Preinstall (Linux)
3. Oracle Database 11g R1 (11.1) Preinstall (Linux)
4. Oracle Database 11g R2 (11.2.0) Preinstall (Linux)
5. Oracle Application Server 10g (9.0.4) Preinstall (Linux)
6. Oracle Application Server 10g R2 (10.1.2) Preinstall (Linux)
7. Oracle Application Server 10g R3 (10.1.3) Preinstall (Linux)
8. Oracle Fusion Middleware 11g R1 (11.1.1) Preinstall (Linux)
9. Oracle Portal Preinstall (Generic)
10. Oracle Identity Management 10g (10.1.4) Preinstall (Linux)
11. Oracle E-Business Suite Release 11i (11.5.10) Preinstall (Linux x86 andx86_64)
12. Oracle E-Business Suite Release 12 (12.1.1) Preinstall (Linux x86 andx86_64)
Available Post-Installation Rule Sets:
13. Oracle WebLogic Server 10 Post Installation (generic)
14. Oracle Portal Postinstall (generic)
15. RAC 10G DB and OS Best Practices (Linux)
16. Data Guard Postinstall (Generic)
Enter the HCVE rule set number
Hit ‘Return’ to accept the default (1)
> 4
Enter value for < Planned ORACLE_HOME location >
> /oracle/app/11.2.0
Enter value for < JDK Home >
>
Test “Oracle Database 11g R2 (11.2.0) Preinstall (Linux)” executed at 01-Aug-2014
Test Results
~~~~~~~~~~~~
ID     NAME                 RESULT  VALUE
====== ==================== ======= ==========================================
A00010 OS Certified?        FAILED
A00020 User in /etc/passwd? PASSED  userOK
A00040 Group in /etc/group? PASSED  GroupOK
A00050 Enter ORACLE_HOME    RECORD  /oracle/app/11.2.0
A00060 ORACLE_HOME Valid?   PASSED  OHexists
A00070 O_H Permissions OK?  PASSED  CorrectPerms
A00080 oraInventory Permiss PASSED  oraInventoryOK
A00090 Got Software Tools?  PASSED  ld_nm_ar_make_found
A00100 Umask Set to 022?    PASSED  UmaskOK
A00120 Limits Processes     PASSED  Adequate
A00125 Limits Stacksize     FAILED  HardHigh
A00130 Limits Descriptors   PASSED  Adequate
A00140 LDLIBRARYPATH Unset? PASSED  UnSet
A00180 JAVA_HOME Unset?     PASSED  UnSet
A00190 Enter JDK Home       RECORD
A00200 JDK Version          FAILED  JDK home is missing
A00210 Other O_Hs in PATH?  PASSED  NoneFound
A00220 Other OUI Up?        PASSED  NoOtherOUI
A00230 /tmp Adequate?       PASSED  TempSpaceOK
A00240 Disk Space OK?       PASSED  DiskSpaceOK
A00250 Swap (in MB)         RECORD  36863
A00260 RAM (in MB)          PASSED  48245
A00270 Swap OK?             PASSED  SwapToRAMOK
A00280 Network              PASSED  Not connected. Check log.
A00290 IP Address           RECORD  10.215.25.132
A00300 Domain Name          RECORD  Not configured
A00310 DNS Lookup           FAILED  Cannot access /usr/bin/nslookup
A00320 /etc/hosts Format    FAILED  no entry found
A00330 Kernel Parameters OK FAILED  SHMMAXTooSmall
A00380 Tainted Kernel?      PASSED  NotVerifiable
A00400 ip_local_port_range  PASSED  RangeOK
A00480 EL4 RPMs OK?         SKIPPED NotEnterprise
A00490 EL5 RPMs OK?         SKIPPED NotEnterprise
A00530 RHEL4 RPMs OK?       SKIPPED NotRedHat
A00540 RHEL5 RPMs OK?       SKIPPED NotRedHat
A00570 SLES10 RPMs OK?      SKIPPED NotSuSE
A00580 SLES11 RPMs OK?      SKIPPED NotSuSE
Result file: /tmp/rda/output/RDA_HCVE_A200DB11R2_lnx_res.htm
Do the necessary changes as suggested by RDA.
After pre-checks proceed with software installation.

There are 2 options for installation as per below - 

Option 1) If you are using graphical interface(Oracle Universal Installer)then execute below command and follow the options.
#cd /software/oracle/database
#./runInstaller

Option 2) Steps for silent installation (using response file)
Go to response directory
#cd /software/oracle/database/response
On this path you can see the below response files.

netca.rsp
db_install.rsp
dbca.rsp

Make a copy of the db_install.rsp as below.

#cp db_install.rsp db_install.rsp_org

Edit the response file with the required changes for below particular parameters only and leave other parameters with default values.
(Below response file is the example of only software installation (not with db creation), and its NON ASM and NON RAC.)

I have mentioned only required parameters from response file.

install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=Hostname_of_your_server
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/oracle/app/oraInventory       —- (mention as per your setting)
SELECTED_LANGUAGES=en
ORACLE_HOME=/oracle/app/11.2.0                    —- (mention as per your setting)
ORACLE_BASE=/oracle/app/oracle                    —- (mention as per your setting)
install.db.InstallEdition=EE
install.db.DBA_GROUP=oinstall
DECLINE_SECURITY_UPDATES=true

NOTE:- For other parameters if value is blank or some particular value  then leave it with same.

After above changes save the response file.

Set environment variable as below on the server.(In our case it will be as per below)

export ORACLE_HOME=/oracle/app/11.2.0
export ORACLE_BASE=/oracle/app/oracle
export PATH=$ORACLE_HOME/bin:/usr/bin:/usr/dt/bin:/usr/openwin/bin:/bin:/usr/ucb:/etc:/usr/sbin:/usr/lbin:/usr/ccs/bin:/usr/bin/
export TNS_ADMIN=$ORACLE_HOME/network/admin
export LD_LIBRARY_PATH=/usr/dt/lib:$ORACLE_HOME/lib

Now go the path  /software/oracle/database

#cd /software/oracle/database

Execute below command from same location to start the installation using response file.

#./runInstaller -silent -ignorePrereq -responseFile /software/oracle/database/response/db_install.rsp
========================================================================================================
In above command we used below arguments
-silent –> For silent mode operations.
-ignorePrereq –> To ignore running the prerequisite checks which was done above.
-responseFile –> Specifies the response file and path to use
If your ORACLE_HOME directory is a non-empty directory then use -force option in above commnad.
-force –> Allowing silent mode installation into a non-empty directory.

You can check all the arguments of “runInstaller” by using below command:-

#cd /software/oracle/database
#./runInstaller -help
=========================================================================================================
Once the above command execute , you will get message as per below -

The installation of Oracle Database 11g was successful. Run the below scripts as a root user.
/oracle/app/11.2.0/root.sh
Execute /oracle/app/11.2.0/root.sh  script as root user. 
Oracle software installation is done now.
Now you can configure listener and also you can create the database with DBCA or Manually.

Export/Import DataPump Parameter ACCESS_METHOD

Hello Friends,

I was facing issues with the export – import task .
The source schema tables was having datatype as Long Raw and it was making issues during import.

Then i came to know new parameter ACCESS_METHOD.
 
Use below command during export -
expdp dumpfile=xxxxxxx logfile=xxxxxxxxx tables=owner.tablename access_method=direct_path

Use below command during import -
impdp dumpfile=xxxxxxxxx logfile=xxxxxxxx access_method=direct_path remap_schema=(optional) remap_tablespace=(optional) table_exists_action=replace ( optional )

It worked without any errors/warnings.

Reference Metalink Id –
Export/Import DataPump Parameter ACCESS_METHOD – How to Enforce a Method of Loading and Unloading Data ? [ID 552424.1].

Silent Installation Guide for 12c Release 1 (12.1) for Linux x86-64(Using response file)

Disk Space Requirements on Linux x86-64 Installation Type Disk Space for Software Files

Enterprise Edition :- 6.4 GB
Standard Edition :- 6.1 GB
Standard Edition One :- 6.1 GB

RAM requirement

Minimum: 1 GB of RAM
Recommended: 2 GB of RAM or more
Swap Space Requirement for Linux RAM Swap Space :-
Between 1 GB and 2 GB 1.5 times the size of RAM
Between 2 GB and 16 GB Equal to the size of RAM
More than 16 GB 16 GB

Operating System Requirements for x86-64 Linux

-Supported Oracle Linux 6 and Red Hat Enterprise Linux 6 Distributions for x86-64
-Supported Oracle Linux 5 and Red Hat Enterprise Linux 5 Distributions for x86-64

1) Oracle Linux 6 and Red Hat Enterprise Linux 6 (x86-64)

Supported distributions for oracle linux 6 :- (OS Kernel requirement)
Oracle Linux 6 with the Unbreakable Enterprise kernel: 2.6.39-200.24.1.el6uek.x86_64 or later
Oracle Linux 6 with the Red Hat Compatible kernel: 2.6.32-71.el6.x86_64 or later

Supported distributions for Red Hat Enterprise linux 6 :- (OS Kernel requirement)
Red Hat Enterprise Linux 6: 2.6.32-71.el6.x86_64 or later
Red Hat Enterprise Linux 6 with the Unbreakable Enterprise Kernel: 2.6.32-100.28.5.el6.x86_64 or later

Packages for Oracle Linux 6 and Red Hat Enterprise Linux 6 :- (RPM)

Requires below packages (or later versions)
Note :- The 32-bit packages listed in the following sections are required only for 32-bit client installs.
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)

2) Oracle Linux 5 and Red Hat Enterprise Linux 5 (x86-64)

Supported distributions for oracle linux 5 :- (OS Kernel requirement)
Oracle Linux 5 Update 6 with the Unbreakable Enterprise kernel: 2.6.32-100.0.19 or later
Oracle Linux 5 Update 6 with the Red Hat compatible kernel:2.6.18-238.0.0.0.1.el5 or later

Supported distributions for Red Hat Enterprise linux 5 :- (OS Kernel requirement)
Red Hat Enterprise Linux 5 Update 6: 2.6.18-238.0.0.0.1.el5 or later
Red Hat Enterprise Linux 5 Update 6 with the UnbreakableEnterprise Kernel: 2.6.32-100.0.19 or later

Packages for Oracle Linux 5 and Red Hat Enterprise Linux 5 :- (RPM)
Requires below packages (or later versions)

Note :- The 32-bit packages listed in the following sections are required only for 32-bit client installs.
binutils-2.17.50.0.6
compat-libstdc++-33-3.2.3
compat-libstdc++-33-3.2.3 (32 bit)
gcc-4.1.2
gcc-c++-4.1.2
glibc-2.5-58
glibc-2.5-58 (32 bit)
glibc-devel-2.5-58
glibc-devel-2.5-58 (32 bit)
ksh
libaio-0.3.106
libaio-0.3.106 (32 bit)
libaio-devel-0.3.106
libaio-devel-0.3.106 (32 bit)
libgcc-4.1.2
libgcc-4.1.2 (32 bit)
libstdc++-4.1.2
libstdc++-4.1.2 (32 bit)
libstdc++-devel 4.1.2
libXext-1.0.1
libXext-1.0.1 (32 bit)
libXtst-1.0.1
libXtst-1.0.1 (32 bit)
libX11-1.0.3
libX11-1.0.3 (32 bit)
libXau-1.0.1
libXau-1.0.1 (32 bit)
libXi-1.0.1
libXi-1.0.1 (32 bit)
make-3.81
sysstat-7.0.2

**** Installation steps****

a) Creating Required Operating System Groups and Users

$/usr/sbin/groupadd oinstall
$/usr/sbin/groupadd dba
$/usr/sbin/useradd -g oinstall -G dba oracle

b) Configuring Kernel Parameters and Resource Limits

– Add Below lines in /etc/sysctl.conf
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
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

Enter the following command to change the current values of the kernel parameters:
$/sbin/sysctl –p

– Add below lines in /etc/security/limits.con
 
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

c) Creating Required Directories

Create directories for oracle binaries and owner should be oracle:oinstall
Like /oracle/app/12.1.0 so this will be your ORACLE_HOME.

d) Copy the oracle software and unzip

Download the software from oracle web site as per your OS.
Below is the software for Red Hat Enterprise Linux x86_64
Oracle version :- 12.1.0.1.0

#cd /software/oracle/

#ls
linuxamd64_12c_database_2of2.zip
linuxamd64_12c_database_1of2.zip

unzip above two files on same location

#cd /software/oracle

#unzip linuxamd64_12c_database_2of2.zip

#unzip linuxamd64_12c_database_1of2.zip

Once both the zip files unzipped , you will find directory with name “database” on same location.

Do installation prechecks using below two Options :-

Option 1)software installation prechecks execute below command :-

#cd /software/oracle/database

#./runInstaller -silent –executePrereqs

Above command creates a logfile where you can get result of prechecks on the server.
Do the needful for any precheck failure.

Option 2) Prechecks using oracle RDA tool :-

Download the required RDA tool from metalink and follow the prechecks steps as per given in read me.
After pre-checks proceed with software installation.
Steps for silent installation (using response file)
– Go to response directory
#cd /software/oracle/database/response

– On this path you can see the below response files.
netca.rsp
db_install.rsp
dbca.rsp

Make a copy of the db_install.rsp as below.

#cp db_install.rsp db_install.rsp_org
– Edit the response file with the required changes for below particular parameters only and leave other parameters with default values.

install.option=INSTALL_DB_SWONLY
ORACLE_HOSTNAME=Hostname_of_your_server
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/oracle/app/oraInventory —- (mention as per your system setting)
SELECTED_LANGUAGES=en
ORACLE_HOME=/oracle/app/12.1.0 —- (mention as per your system setting)
ORACLE_BASE=/oracle/app/oracle —- (mention as per your system setting)
install.db.InstallEdition=EE
install.db.DBA_GROUP=oinstall
DECLINE_SECURITY_UPDATES=true

<NOTE:- From 12c , If you are using silent installation for the oracle database software you need to provide additional parameters: oracle.install.db.BACKUPDBA_GROUP, oracle.install.db.DGDBA_GROUP and oracle.install.db.KMDBA_GROUP>

oracle.install.db.BACKUPDBA_GROUP=oinstall
oracle.install.db.DGDBA_GROUP=oinstall
oracle.install.db.KMDBA_GROUP=oinstall

Otherwise your installation will fail with below error :-
[FATAL] [INS-35341] The installation user is not a member of the following groups: [null, null, null]
CAUSE: The installation user account must be a member of all groups required for installation.
ACTION: Ensure that the installation user is a member of the system privileges operating system groups you selected.

NOTE:- For other parameters if value is blank or some particular value then leave it with same.

– After above changes save the response file.

– Set environment variable as below on the server.(In our case it will be as per below)

export ORACLE_HOME=/oracle/app/12.1.0
export ORACLE_BASE=/oracle/app/oracle
export PATH=$ORACLE_HOME/bin:/usr/bin:/usr/dt/bin:/usr/openwin/bin:/bin:/usr/ucb:/etc:/usr/sbin:/usr/lbin:/usr/ccs/bin:/usr/bin/
export TNS_ADMIN=$ORACLE_HOME/network/admin
export LD_LIBRARY_PATH=/usr/dt/lib:$ORACLE_HOME/lib

– Now go the path /software/oracle/database
#cd /software/oracle/database

– Execute below command from same location to start the installation using response file.
#./runInstaller -silent -ignorePrereq -responseFile /software/oracle/database/response/db_install.rsp
==================================================================
In above command we used below arguments
-silent –> For silent mode operations.
-ignorePrereq –> To ignore running the prerequisite checks which was done above.
-responseFile –> Specifies the response file and path to use
If your ORACLE_HOME directory is a non-empty directory then use -force option in above commnad.
-force –> Allowing silent mode installation into a non-empty directory.
You can check all the arguments of “runInstaller” by using below command:-
#cd /software/oracle/database
#./runInstaller -help
==================================================================
Once the above command execute , you will get message as per below :-

The installation of Oracle Database 11g was successful. Run the below scripts as a root user.
/oracle/app/12.1.0/root.sh

Execute /oracle/app/12.1.0/root.sh script as root user.

Done ....🙌