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


1 comment:

waheed said...

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