Oracle Apps DBA

My photo
More than 5+ Years of IT Experience in administering Enterprise wide Multi Vendor UNIX Servers, Oracle Databases (8i to 11gR2), Middle-tiers, Applications and Clusters. I am a Sun Certified System Administrator (SCSA) for Solaris 10, oracle 10g database certified associate(OCA), Oracle 10g Database certified professional (OCP) and Oracle E-Business suite R12 certified professionl(OCP)

Oracle Database and Applications

Wednesday, 26 June 2013

ORACLE DATBASE 12C INSTALLATION ON LINUX 64-bit

This is my first article  on Oracle database 12c. I have installed oracle database 12cR1 on Oracle Enterprise Linux 5.7 - 64 bit virtual mahcine with 4GB RAM, 6GB SWAP and 15 GB of HDD space.

I do not find much difference in Installation steps in oracle 12c when compare it with 11g. There are indeed certain new options and some more per-requisite OS packages.

You can download the software from OTN or EDELIVERY  website.

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html


Hardware Requirements:

> Single Core CPU
> 3 GB RAM
> 8 GB of Disk Space (SW + database)

OS per-requisites:

> Create OS group and users
> Create required directories with appropriate privileges
> Configure Kernel parameters
> Install required OS packages
> Configure proper Display

[root@linux1 ~]#groupadd dba
[root@linux1 ~]#useradd -g ora12c
[root@linux1 ~]# passwd ora12c
Changing password for user ora12c.
New UNIX password: 
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password: 
passwd: all authentication tokens updated successfully.
[root@linux1 ~]#
[root@linux1 ~]# mkdir -p /u01/12cDb_Home
[root@linux1 ~]#chmod -R 775 /u01/12cDb_Home
[root@linux1 ~]#chown -R ora12c:dba /u01/12cDb_Home
[root@linux1 ~]#chmod  -R 775 /u01/oracle
[root@linux1 ~]#chown -R ora12c:dba  /u01/oracle
  Add all below parameters in /etc/sysctl.conf

#All below parameters are related to oracle12c database Installation
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
kernel.shmall = 4294967296
kernel.shmmax = 68719476736
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500

Add following entries in /etc/security/limits.conf file

[root@linux1 ~]#tail -10 /etc/security/limits.conf 
#ftp             hard    nproc           0
#@student        -       maxlogins       4
# End of file
*   soft   nofile    1024
*   hard   nofile    65536
*   soft   nproc    2047
*   hard   nproc    16384
*   soft   stack    10240
*   hard   stack    32768
[root@linux1 ~]#


Install all required OS Packges:

- Make sure that all listed below rpm exists

[root@linux1 ~]# rpm -qa | grep binutils*

binutils-2.17.50.0.6-14.el5

[root@linux1 ~]#
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


Configure Oracle Environment files:


[ora12c@linux1 ~]$ more ora12cdb.env 
export ORACLE_BASE=/u01/12cDb_Home
export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/dbhome_1
export ORACLE_SID=prod
export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib


Now run xhost + and start Installation:






> uncheck support updates and click next


> Skip software updates and click "next"


> select create and configure database option


> Select server class


> Select single Instance database Installation.



> Select typical installation



> Provide location ORACLE_BASE, ORACLE_HOME, DATAFILES, SID
> uncheck box for container database



> Provide the location of Oracle Inventory


> Click "next" for Installation









> Execute scripts root.sh as root user




> Database creation in progress




> Successfully completed Installation of database


Installation of Oracle database 12.1 completed successfully on Linux-64bit. In next articles will post: - Installation of 12.1 database on Solaris 11 - X86/Sparc.
- Installation of 12.1 RAC
- Upgrade database 11gR2 to 12cR1
- New features of 12cR1 database

Thanks for reading this article.

regards,
X A H E E R


2 comments:

waheed said...

Good Job Zaheer! Wait for more interesting topic from you on other features in Oracle Database 12c.

Blogger said...

BlueHost is ultimately one of the best hosting provider with plans for any hosting needs.