How to Install Oracle Database 11.2.0.4 on Oracle Linux 6.7 – 64bit
Environment:
Oracle Linux 6.7 64bit, 6 GB RAM
120 GB Disk Space
Download:
·
Patch
– 13390677, download from Oracle Support Site
p13390677_112040_Linux-x86-64_1of7.zip
p13390677_112040_Linux-x86-64_2of7.zip
above
two files are required to install database 11.2.0.4
·
Download
from OTN
Unix Required:
·
Directories
Login
to unix server with "obiee – user account name" account
$su
# enter the password for root access
[root@obiee
/]# mkdir oracle
[root@obiee
/]# chown obiee:dba /oracle
[root@obiee
/]# chmod -r 775 oracle
[root@obiee
/]# exit
[obiee@obiee
~]$ cd /oracle
[obiee@obiee
oracle]$ mkdir database
[obiee@obiee
oracle]$ mkdir orainventory
·
Inventory Setup
[obiee@obiee
oracle]$ su
Password:
[root@obiee
oracle]# cd /etc
[root@obiee
etc]# vi oraInst.loc
Add
following lines
inventory_loc=/oracle/orainventory
inst_group=dba
Save
and exit
·
Host Name Setup
Check
the host name
[root@obiee
etc]# vi hostname
#add
bellow line at host file, if host name not exist
192.168.64.13 obiee.oracle oracle
"IP
Address might be differ"
Oracle Pre Install RPM:
· To Install Oracle Database 11g on a Linux
system, need to preconfigure the operating environment since the database
requires certain software packages, package versions, and tweaks to kernel
parameters.
Using
the Oracle RDBMS Server 11gR2 Pre-install RPM, you can complete most of the
pre-installation configuration tasks
·
Install RPM
[obiee@obiee
oracle]$ su
Password:
[root@obiee
oracle]# yum install oracle-rdbms-server-11gR2-preinstall
Restart
the server
Manual Install and Configurations:
·
Limits:
Add following values to /etc/security/limits.conf
obiee soft
nofile 1024
obiee hard
nofile 65536
obiee soft
nproc 16384
obiee hard
nproc 16384
obiee soft
stack 10240
obiee hard
stack 32768
obiee hard
memlock 134217728
obiee soft memlock
134217728
·
System
Controls:
Add following Values
/etc/sysctl.confto
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 4294967295
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 = 1048576
/etc/security/limits.d/90-nproc.conf:
* - nproc 16384
·
Users
and groups:
groupadd -g 501 oinstall
groupadd -g 502 dba
groupadd -g 503 oper
groupadd -g 504 asmadmin
groupadd -g 506 asmdba
groupadd -g 505 asmoper
Creating Users and Groups:
useradd -u 502 -g oinstall -G
dba,asmdba,oper oracle
passwd oracle
·
Required
RPMS:
Following RPM’s are required for
Oracle linux 6 64 bit
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)
gcc-4.4.4-13.el6 (x86_64)
gcc-c++-4.4.4-13.el6 (x86_64)
glibc-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6 (x86_64)
ksh
libgcc-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6 (x86_64)
libstdc++-devel-4.4.4-13.el6
(x86_64)
libaio-0.3.107-10.el6 (x86_64)
libaio-devel-0.3.107-10.el6 (x86_64)
make-3.81-19.el6
sysstat-9.0.4-11.el6 (x86_64)
unixODBC-2.2.14-11.el6 (x86_64) or
later
unixODBC-devel-2.2.14-11.el6
(x86_64) or later
·
Restart
Server:
After Installation and
configuration, needs to be restart to effect the new changes
Environment Variables:
·
Execute following variables before
installing
# Oracle Settings
TMP=/oracle/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_HOSTNAME=obiee.oracle; export
ORACLE_HOSTNAME
ORACLE_UNQNAME=OBIEE; export
ORACLE_UNQNAME
ORACLE_BASE=/oracle/database/obase;
export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db;
export ORACLE_HOME
ORACLE_SID=OBIEE; export ORACLE_SID
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export
PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;
export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;
export CLASSPATH
Database Install:
Configure
Security Updates - Optional
Screen:
Download
Software Updates – Optional
Screen:
Apply
Software Updates – Skip Software Updates
Screen:
- NA- Not has been chose
Select
Installation Option – Create and configure a database
Screen:
System
Class – Server Class: Choose this option if you are installing on a server
class system, such as what you would use when deploying Oracle in a production
data center.
Screen:
Grid
Installation Options – Single instance database installation: This option
installs the database and the listener.
Screen:
Select
Install Type – Typical Install: This installation method is selected by
default. It lets you quickly install Oracle Database using minimal input.
Typical
Install Configuration -
Screen:
Create
Inventory -
Screen:
1 Perform Prerequisite Checks - Verify
that all the prerequisite checks succeed, and then click next
Screen:
Summary - Review the information
displayed on this screen, and then click Install.
Screen:
1 Install Product - This screen states the
progress of a database installation. After the database is installed, you are
prompted to execute some root configuration script for new inventory as the
root user. Click Next.
Screen:
Finish – This screen is shown
automatically when all the configuration tools are successful. Click Close.
Screen:
Verify Install:
·
Start
and Stop
[obiee@obiee oracle]$ sqlplus / as
sysdba
SQL> Shutdown immediate
SQL> exit
[obiee@obiee oracle]$ sqlplus / as
sysdba
SQL> startup
SQL> exit
·
Listeners
Start and Stop
[obiee@obiee oracle]$ lsnrctl stop
[obiee@obiee oracle]$ lsnrctl start
·
DB
Console
[obiee@obiee oracle]$ ./emctl start
dbconsole
[obiee@obiee oracle]$ ./emctl stop
dbconsole
[obiee@obiee oracle]$ ./emctl start
dbconsole
Open following link in browser
http://obiee.oracle:1158/em/
