Oracle Database 11g R2 Silent Installation (OUI)

Oracle Database 11g R2 Silent Installation (OUI)::


In this article we will learn Oracle Database 11g R2 Silent Installation (OUI) on Oracle Enterprise Linux (OEL5).


Overview:

This article is a comprehensive guide for Silent OUI installation of Oracle Database 11g Release 2 (11.2.0.3.0) x64 on the Oracle Enterprise Linux 5 (OEL5) x64 Operating System Environment.

Please do keep in mind that this article should not be considered a substitution of the official installation guide and release note from Oracle (http://www.oracle.com). The below mentioned link can be used to download the official installation guide for Oracle Database 11g Release 2 (11.2.0.3.0) x64 on Linux x64 Operating Environment.

http://docs.oracle.com/cd/E11882_01/install.112/e24321/app_nonint.htm#BABFEECI

http://download.oracle.com/docs/cd/E11882_01/install.112/e24321/toc.htm 

Hardware Requirements Check:

Note:Login to the system as a root user for performing the below activities.

Memory Requirements:

Minimum:1 GB of RAM

Recommended:2 GB of RAM

To determine the RAM size, enter the following command:

[root@oelinux ~]# grep MemTotal /proc/meminfo

Note:If the size of the RAM is less than the required size, then you must install more memory before continuing.

Available RAM	SWAP Space Requirement
Between 1 GB and 2 GB	1.5 times the size of the RAM
Between 2 GB and 16 GB	Equal to the size of the RAM
More than 16 GB	16 GB

To determine the size of the configured swap space, enter the following command:

[root@oelinux ~]# grep SwapTotal /proc/meminfo

Note:If there is a need of increasing swap space, see O/S documentation for increasing the swap space.

Disk Space Requirements:

At least 1 GB of free disk space should be available in the /tmp directory.

To determine the amount of disk space available in the /tmp directory, enter the following command:

[root@oelinux ~]# df -kh /tmp

If there is less than 1 GB of free disk space available in the /tmp directory, then do one of the below mentioned steps:

Ξ Delete unnecessary files from the tmp directory.

Ξ Increase the size of tmp directory as follows (Extend the file system that contains the /tmp directory):

Disk space requirements for software files, and data files for each installation type on Linux x86-64:

Installation Type	Minimum Requirement for Software Files (GB)
Enterprise Edition	4.35
Standard Edition	4.22
Installation Type	Minimum Requirement for Data Files (GB)
Enterprise Edition	1.7
Standard Edition	1.5

To determine the amount of free disk space on the system, enter the following command:

[root@oelinux ~]# df -kh

If your diskspace is not enough, please contact administrator for increasing the disk space.

Package Requirements Check:

After the installation of OEL5_x64, the next task is to install all packages required by Oracle Database 11g R2 x64. During the installation process the Oracle Universal Installer performs prerequisites checks before the actual installation of database. For ensuring that these prerequisite checks complete successfully, ensure that all the packages listed below are installed properly.The following are the list of packages required for Oracle Database 11g Release 2 (11.2) x64 on OEL5 x64:

• 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

The packages listed above can be found on the installer disc/image of Oracle Enterprise Linux 5 x64 or can be downloaded from the vendor's website.

To determine whether the required packages are installed, enter commands similar to the following:

[root@oelinux ~]# rpm -q package_name

e.g:  [root@oelinux ~]# rpm –q binutils-2.17.50.0.6

if the package is not installed then install the package as mentioned below:

[root@oelinux ~]# rpm -ivh package_name

N.B: To use ODBC, you must also install the following additional ODBC RPMs which are listed below:

• unixODBC-2.2.11 (32-bit)
• unixODBC-devel-2.2.11 (64-bit)
• unixODBC-2.2.11 (64-bit)

The odbc packages can be downloaded from http://www.unixodbc.org and can be installed.

 For the screenshots of the activities please visit the mentioned link::: http://www.sensehaze.com/mydata/resources_section/installation/11g_oel_sil/index.php



Network Configuration:

Edit /etc/hosts file:

Ensure that the hostname(oelinux) is not mentioned in the loopback address information in the /etc/hosts file.

Disable SELinux and Firewall:

[root@oelinux ~]# system-config-selinux
[root@oelinux ~]# service iptables stop

Creation of Required O/S Users and Groups:

The following local operating system user and groups are required for oracle database installation:

• Oracle Inventory Group -- oinstall
• OSBDA Group -- dba
• OSOPER Group -- oper
• Oracle Software Owner User -- Oracle

Check whether the groups/user exists , if doesn't exist please create them.
Follow the below mentioned steps...

1. To determine whether "oinstall" group exists, type the following command:
   [root@oelinux ~]# more /etc/oraInst.loc
   If the output shows oinstall group then the group exists and need not to be created.
   .
2. To determine whether "dba" group exists, type the following command:
   [root@oelinux ~]# grep dba /etc/group
   If the output shows dba group then the group exists and need not to be created.
   .
3. To determine whether "oracle" user exists, type the following command:
   [root@oelinux ~]# id oracle
   If the output shows oracle user then the user exists and need not to be created.
   The output should be similar to following, indicating "oinstall" as primary and "dba" as secondary group.
   uid=1001(oracle) gid=1001(oinstall) groups=1002(dba),1003(oper).
   If the primary group is not "oinstall" and the user "oracle" is not the member of "dba" group then we have to modify the user "oracle" as mentioned below::
   [root@oelinux ~]#usermod -g oinstall -G dba oracle   
4. If the user or the required groups doesn't exist then create them as mentioned below:
   [root@oelinux ~]# groupadd -g 1001 oinstall
   [root@oelinux ~]# groupadd -g 1002 dba
   [root@oelinux ~]# groupadd -g 1003 oper
   [root@oelinux ~]# useradd -m -u 1001 -g oinstall -G dba,oper oracle
   Now check the status of "oracle" user.
   [root@oelinux ~]# id oracle
   The output should be similar to following, indicating "oinstall" as primary and "dba" as secondary group.
   uid=1001(oracle) gid=1001(oinstall) groups=1002(dba),1003(oper).
   Now set the password of "oracle" user.
   [root@oelinux ~]# passwd oracle
   and input a password for "oracle" user.
5. Verify That the User nobody Exists:
   Before installation of oracle software, complete the following steps to verify that the user "nobody" exists on the system:
   To determine if the user exists, enter the following command:
   [root@oelinux ~]# id nobody
   If this command displays information about the "nobody" user, then you do not have to create that user.
   If the user "nobody" does not exist, then enter the following command to create it:
   [root@oelinux ~]# useradd nobody 

 

Configuration of Kernel Parameters:

Verify that the kernel parameters shown in the following table are set to values greater than or equal to the minimum value shown.

Using any text editor, edit the /etc/sysctl.conf file, and add or edit lines similar to the following:

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

[root@oelinux ~]# vim /etc/sysctl.conf

After adding the above lines to the /etc/sysctl.conf file, they persist each time the system reboots. If you would like to make these kernel parameter value changes to the current system without having to reboot, enter the following command:

[root@oelinux ~]# sysctl -p

If the output of the above command shows any error, please rectify the error before proceeding to next step.

To improve the performance on Linux systems, Oracle recommends us to increase the shell limits for the oracle software owner user "oracle".

Update the resource limits in the /etc/security/limits.conf configuration file for the installation owner (Here "oracle" user is the owner).

----------------------------

oracle  soft  nproc  2047

oracle  hard  nproc  16384

oracle  soft  nofile  1024

oracle  hard  nofile  65536

oracle  soft  stack  10240

----------------------------

[root@oelinux ~]# vim /etc/security/limits.conf

Creation of Required Directories:

The next step is to create a directory that will be used to store the "Oracle Database software", "Oracle Database Datafiles" and "Flash Recovery Data".

After the directory is created, we must then specify the correct owner, group, and permissions for it.

[root@oelinux ~]# mkdir -p /u01/app/
[root@oelinux ~]# chown -R oracle:oinstall /u01/app/
[root@oelinux ~]# chmod -R 775 /u01/app/

Configuring the oracle User’s Environment:

Set the default file mode creation mask (umask) to 022 for "oracle" user. For setting so, do the following:

[root@oelinux ~]# su - oracle
[oracle@oelinux ~]$ vim ~/.bash_profile

Add a line as written below and save the file.

umask 022

N.B:You do not have to set the DISPLAY environment variable if you are completing a silent mode installation.

 For the screenshots of the activities please visit the mentioned link::: http://www.sensehaze.com/mydata/resources_section/installation/11g_oel_sil/index.php

Installation of Oracle Database:

After configuring the oracle user’s environment, create a response file for silent installation and configuration of the database.
A response file is available in the response directory of the installation disc.
I will copy and edit the response file for our purpose.

I will install and configure database through the response file.

Specify the Installation Option in the response file:

Parameter	Response
oracle.install.option	INSTALL_DB_AND_CONFIG
ORACLE_HOSTNAME	oelinux
UNIX_GROUP_NAME	oinstall
INVENTORY_LOCATION	/u01/app/oraInventory
SELECTED_LANGUAGES	en
ORACLE_HOME	/u01/app/oracle/product/11.2.0/dbhome_1
ORACLE_BASE	/u01/app/oracle
oracle.install.db.InstallEdition	EE
oracle.install.db.EEOptionsSelection	false
oracle.install.db.DBA_GROUP	dba
oracle.install.db.OPER_GROUP	oper
oracle.install.db.config.starterdb.type	GENERAL_PURPOSE
oracle.install.db.config.starterdb.globalDBName	mydb
oracle.install.db.config.starterdb.SID	mydb
oracle.install.db.config.starterdb.characterSet	AL32UTF8
oracle.install.db.config.starterdb.memoryOption	true
oracle.install.db.config.starterdb.memoryLimit	700
oracle.install.db.config.starterdb.installExampleSchemas	false
oracle.install.db.config.starterdb.enableSecuritySettings	true
oracle.install.db.config.starterdb.password.ALL	Sensehaze123
oracle.install.db.config.starterdb.control	DB_CONTROL
oracle.install.db.config.starterdb.automatedBackup.enable	false
oracle.install.db.config.starterdb.storageType	FILE_SYSTEM_STORAGE
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation	/u01/app/oracle/oradata
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation	/u01/app/oracle/flash_recovery_area
SECURITY_UPDATES_VIA_MYORACLESUPPORT	false
DECLINE_SECURITY_UPDATES	true
oracle.installer.autoupdates.option	SKIP_UPDATES

Open terminal and run installer with the response file option as "oracle" user.

[oracle@oelinux ~]$ ./runInstaller -silent -responsefile /oracle_soft/db_install.rsp 

Wait for the installation step to prompt for executing the scripts.

Open terminal and execute the scripts mentioned in the above screenshot as "root" user.

[root@oelinux ~]# /u01/app/oraInventory/orainstRoot.sh

After this run the second script, also as a "root" user .

[root@oelinux ~]# /u01/app/oracle/product/11.2.0/dbhome_1/root.sh

This finishes the Oracle database installation and configuration.

View the setup logfiles :

[root@oelinux ~]# cat /u01/app/oraInventory/logs/silentinstallxxxxx.log

[root@oelinux ~]# cat /u01/app/oraInventory/logs/installactionsxxxxx.log

 

Set Oracle User Profile :
Open the profile file and add the below mentioned lines:

export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export ORACLE_SID=mydb
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

[oracle@oelinux ~]$ vim ~/.bash_profile
Or use any editor of your choice, to edit the profile of "Oracle" user.

After editing the profile run it for checking errors and loading.

[oracle@oelinux ~]$ . ~/.bash_profile
If there is any syntax error in the profile it will be reported.If there is no error then we will get the prompt silently.

Connect to the Database:

[oracle@oelinux ~]$ ps -eaf | grep pmon

[oracle@oelinux ~]$ export ORACLE_SID=mydb

[oracle@oelinux ~]$ sqlplus sys@mydb as sysdba

And you will be connected to the database.

 For the screenshots of the activities please visit the mentioned link::: http://www.sensehaze.com/mydata/resources_section/installation/11g_oel_sil/index.php