Thursday, February 4, 2016

Oracle Database 11g Installation in Linux

DB Silent Install of Oracle on RedHat 6.0
 Configure the Kernel:
                                              Before we can install Oracle on our new VM, we need configure the Linux kernel. The following steps modify key settings to allow Oracle to execute:
Edit the /etc/sysctl.conf and add following lines:
# added for Oracle
kernel.shmall = 2097152
kernel.shmmax = 1050470400
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
fs.aio-max-nr = 1048576
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 = 1048576

 C:\Users\Rajkumar\Desktop\Obiee Instalation\Capture1.PNG
Now execute sysctl -p command to apply the new settings:
Edit the /etc/pam.d/login file and add following line:
# added for Oracle
session    required

Edit the /etc/security/limits.conf file and add following lines:
# added for Oracle
oracle    soft  nproc   2047
oracle    hard  nproc   16384
oracle    soft  nofile  1024
oracle    hard  nofile  65536

Check current status of SELinux:
[root@localhost ~]# /usr/sbin/getenforce
If output is Enforcing then change mode to Permissive as follows:
[root@localhost ~]# /usr/sbin/setenforce 0

To make the change permanent, modify the /etc/sysconfig/selinux change value of SELINUX variable todisabled:

Disable the NTP configuration file

[root@ssslinux ~]# cd /etc
[root@ssslinux etc]# mv ntp.conf ntp.conf.bak

Now we have the RedHat 6.0 Linux kernel ready for Oracle

Add the Oracle User.
Next we need to create the Oracle user account, OS groups and mount point.
ogin as root and create the user oracle account and the OS groups:
[root@ssslinux ~]# groupadd dba
[root@ssslinux ~]# groupadd oinstall
[root@ssslinux ~]# groupadd asmdba
[root@ssslinux ~]# groupadd asmadmin
[root@ssslinux ~]# useradd -g oinstall -G dba,asmdba,asmadmin oracle
Now set the password for the oracle user. Since this is development, I suggest we stick with “oracle”

[root@ssslinux ~]# passwd oracle
Changing password for user oracle.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.

Now we create a directory into which the oracle software will be installed. We need to set this new directory to be owned by oracle:

[root@ssslinux ~]# mkdir /u01
[root@ssslinux ~]# mkdir /u01/app
[root@ssslinux ~]# chown oracle:dba /u01/app
[root@ssslinux ~]# chmod 777 /u01/app
Now we can log into our new oracle account and configure the bash profile:
[root@ssslinux ~]#  su - oracle
[oracle@ssslinux ~]$  vi ~/.bash_profile
Add the following lines to the profile script:
TMP=/tmp; export TMP
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
PATH=/usr/sbin:$PATH; export PATH

if [ $USER = "oracle" ]; then
 if [ $SHELL = "/bin/ksh" ]; then
   ulimit -p 16384
   ulimit -n 65536
   ulimit -u 16384 -n 65536

Install Database.

Response file =
[oracle@ssslinux database]$ ./runInstaller -silent -force -responseFile=/mnt/hgfs/OBIEE/database/response/db.rsp
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB.   Actual 47617 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 4023 MB    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-01-10_11-26-40AM. Please wait ...
You can find the log of this install session at:

The installation of Oracle Database 11g was successful.
Please check '/u01/app/oraInventory/logs/silentInstall2013-01-10_11-26-40AM.log' for more details.

As a root user, execute the following script(s):
    1. /u01/app/oracle/product/11.2.0/dbhome_1/

Successfully Setup Software.

1 comment: