Thursday, February 4, 2016

Oracle Database 11g Installation in Linux

DB Silent Install of Oracle 11.2.0.3 on RedHat 6.0
 Configure the Kernel:
                                              Before we can install Oracle 11.2.0.3 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 11.2.0.3
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 11.2.0.3
session    required     pam_limits.so

Edit the /etc/security/limits.conf file and add following lines:
# added for Oracle 11.2.0.3
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
Enforcing
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 11.2.0.3.

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:
LD_BIND_NOW=1; export LD_BIND_NOW
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=`hostname`; export ORACLE_HOSTNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

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

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:
/u01/app/oraInventory/logs/installActions2013-01-10_11-26-40AM.log

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/root.sh


Successfully Setup Software.

2 comments: