facebook twitter youtube facebook facebook facebook

E-Mail : info@askmlabs.com

Phone : +1.215.353.8306

Home » , , » Database 12c Installation on CentOS 6.5

Database 12c Installation on CentOS 6.5

Written By askMLabs on Monday, February 24, 2014 | 9:48 AM

In this article, i am going to show you the steps to install oracle database 12c on CentOS 6.5. Though CentOS 6.5 is officially not supported by oracle by its certification matrix, we do follow the same instructions that we use for OL6.x or RHEL6.x. 
You might be finding so many other places about the instructions with screen shots to install oracle database 12c, and this is just another place to find the same content. The actual purpose to create this database is to use for oem 12c installation. So just collected the installation screen shots to present if it helps some newbies.

Download the software for database 12c. Download

Complete all the following pre-requisites before starting the oracle database 12c installation.

1. Hardware requirement:
    RAM - 1.5 GB min
    Swap - 1.5*RAM ( this is optional, we can configure temporary swap )
    /tmp space - 1GB min
    ORACLE_HOME -- 6.5GB

2. Software Requirements : 
2.1 Check OS version and Kernel : 
[root@db12c ~]# cat /etc/redhat-release
CentOS release 6.5 (Final)
[root@db12c ~]# uname -r
2.6.32-431.3.1.el6.x86_64
[root@db12c ~]#
2.2 Install all the required rpms. The following table lists all the required rpms for database 12c. This table is copied from the MOS ID 1587357.1
If you have configured YUM repository for your server, you can use the following commands to install rpms. Refer my other article to know how to configure YUM to your distribution.
yum install <rpm name>. 
If you don't have YUM configured, you need to copy all the below specified rpms from your CentOS 6.5 distribution CD and need to install manually.
rpm -ivh <rpm name>
OS Version
Patches/Packages
Kernel settings
Oracle Linux 6 with the Unbreakable Enterprise kernel: 2.6.39-200.24.1.el6uek.x86_64 or later
Oracle Linux 6 with the Red Hat Compatible kernel: 2.6.32-71.el6.x86_64 or later
Red Hat Enterprise Linux 6: 2.6.32-71.el6.x86_64 or later
Red Hat Enterprise Linux 6 with the Unbreakable Enterprise Kernel: 2.6.32-100.28.5.el6.x86_64 or later
Reference :

binutils-2.20.51.0.2-5.11.el6 (x86_64)
glibc-2.12-1.7.el6 (x86_64)
libgcc-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6 (x86_64)
libaio-0.3.107-10.el6 (x86_64)
libXext-1.1 (x86_64)
libXtst-1.0.99.2 (x86_64)
libX11-1.3 (x86_64)
libXau-1.0.5 (x86_64)
libxcb-1.5 (x86_64)
libXi-1.3 (x86_64)
make-3.81-19.el6
sysstat-9.0.4-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-devel-2.12-1.7.el6 (x86_64)
ksh  <== any version of ksh is acceptable
libstdc++-devel-4.4.4-13.el6 (x86_64)
libaio-devel-0.3.107-10.el6 (x86_64)


Some depended RPMS for above listed packages

cloog-ppl.x86_64 0:0.15.7-1.2.el6
cpp.x86_64 0:4.4.6-4.el6
glibc-headers.x86_64 0:2.12-1.80.el6
kernel-headers.x86_64 0:2.6.32-279.el6
mpfr.x86_64 0:2.4.1-6.el6
ppl.x86_64 0:0.10.2-11.el6
/etc/sysctl.conf
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
fs.aio-max-nr = 1048576
Note: This value limits concurrent outstanding requests and should be set to avoid I/O subsystem failures.
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.conf
oracle   soft    nproc    2047
oracle   hard   nproc   16384
oracle   soft    nofile    1024
oracle   hard   nofile    65536
oracle   soft    stack    10240
oracle   hard   stack    10240


/etc/pam.d/login
session required pam_limits.so

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

Session Log For Reference:
[root@db12c ~]# egrep --color 'Mem|Cache|Swap' /proc/meminfoMemTotal:       49423668 kB
MemFree:         7364136 kB
Cached:         34088520 kB
SwapCached:         8060 kB
SwapTotal:      24780792 kB
SwapFree:       23905912 kB
[root@db12c ~]# df -h /tmpFilesystem                       Size  Used Avail Use% Mounted on
/dev/mapper/vg_db12c-lv_root   11G  5.1G  5.3G  50% /
[root@db12c ~]# df -h /homeFilesystem                       Size  Used Avail Use% Mounted on
/dev/mapper/vg_db12c-lv_home  2.7T  641G  1.9T  25% /home
[root@db12c ~]# cat /etc/redhat-releaseCentOS release 6.5 (Final)
[root@db12c ~]# uname -r2.6.32-431.3.1.el6.x86_64
[root@db12c ~]#
[root@db12c ~]# rpm -qa | grep -i binutils-binutils-2.20.51.0.2-5.36.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i glibcglibc-devel-2.12-1.132.el6.i686
glibc-common-2.12-1.132.el6.x86_64
glibc-2.12-1.132.el6.x86_64
glibc-devel-2.12-1.132.el6.x86_64
glibc-headers-2.12-1.132.el6.x86_64
glibc-2.12-1.132.el6.i686
[root@db12c ~]# rpm -qa | grep -i libgcclibgcc-4.4.7-4.el6.x86_64
libgcc-4.4.7-4.el6.i686
[root@db12c ~]# rpm -qa | grep -i libstdc++libstdc++-4.4.7-4.el6.i686
libstdc++-4.4.7-4.el6.x86_64
libstdc++-devel-4.4.7-4.el6.x86_64
compat-libstdc++-33-3.2.3-69.el6.x86_64
compat-libstdc++-296-2.96-144.el6.i686
libstdc++-devel-4.4.7-4.el6.i686
[root@db12c ~]# rpm -qa | grep -i libaiolibaio-devel-0.3.107-10.el6.i686
libaio-0.3.107-10.el6.x86_64
libaio-devel-0.3.107-10.el6.x86_64
libaio-0.3.107-10.el6.i686
[root@db12c ~]# rpm -qa | grep -i libXextlibXext-1.3.1-2.el6.i686
libXext-devel-1.3.1-2.el6.x86_64
libXext-1.3.1-2.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i libXtstlibXtst-1.2.1-2.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i libX11libX11-1.5.0-4.el6.x86_64
libX11-common-1.5.0-4.el6.noarch
libX11-devel-1.5.0-4.el6.x86_64
libX11-1.5.0-4.el6.i686
[root@db12c ~]# rpm -qa | grep -i libXaulibXau-1.0.6-4.el6.i686
libXau-devel-1.0.6-4.el6.x86_64
libXau-1.0.6-4.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i libxcblibxcb-1.8.1-1.el6.i686
libxcb-devel-1.8.1-1.el6.x86_64
libxcb-1.8.1-1.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i libXilibXinerama-devel-1.1.2-2.el6.x86_64
libXinerama-1.1.2-2.el6.x86_64
libXi-devel-1.6.1-3.el6.x86_64
libXi-1.6.1-3.el6.i686
libXi-1.6.1-3.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i makeautomake-1.11.1-4.el6.noarch
MAKEDEV-3.24-6.el6.x86_64
perl-ExtUtils-MakeMaker-6.55-136.el6.x86_64
perl-Locale-Maketext-Simple-0.18-136.el6.x86_64
make-3.81-20.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i sysstatsysstat-9.0.4-22.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i compat-libcap1compat-libcap1-1.10-1.x86_64
[root@db12c ~]# rpm -qa | grep -i compat-libstdc++compat-libstdc++-33-3.2.3-69.el6.x86_64
compat-libstdc++-296-2.96-144.el6.i686
[root@db12c ~]# rpm -qa | grep -i gccgcc-4.4.7-4.el6.x86_64
libgcc-4.4.7-4.el6.x86_64
libgcc-4.4.7-4.el6.i686
gcc-gfortran-4.4.7-4.el6.x86_64
gcc-c++-4.4.7-4.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i gcc-c++gcc-c++-4.4.7-4.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i glibc-develglibc-devel-2.12-1.132.el6.i686
glibc-devel-2.12-1.132.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i kshpdksh-5.2.14-30.x86_64
[root@db12c ~]# rpm -qa | grep -i libstdc++-devellibstdc++-devel-4.4.7-4.el6.x86_64
libstdc++-devel-4.4.7-4.el6.i686
[root@db12c ~]# rpm -qa | grep -i libaio-devellibaio-devel-0.3.107-10.el6.i686
libaio-devel-0.3.107-10.el6.x86_64
[root@db12c ~]#
[root@db12c ~]# rpm -qa | grep -i cloog-pplcloog-ppl-devel-0.15.7-1.2.el6.x86_64
cloog-ppl-0.15.7-1.2.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i cppcpp-4.4.7-4.el6.x86_64
abrt-addon-ccpp-2.0.8-21.el6.centos.x86_64
cppunit-1.12.1-3.1.el6.x86_64
cppunit-doc-1.12.1-3.1.el6.x86_64
mcpp-2.7.2-4.1.el6.x86_64
cppunit-devel-1.12.1-3.1.el6.x86_64
libmcpp-2.7.2-4.1.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i glibc-headersglibc-headers-2.12-1.132.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i kernel-headerskernel-headers-2.6.32-431.3.1.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i mpfrmpfr-2.4.1-6.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i pplpoppler-utils-0.12.4-3.el6_0.1.x86_64
wpa_supplicant-0.7.3-4.el6_3.x86_64
cloog-ppl-devel-0.15.7-1.2.el6.x86_64
poppler-0.12.4-3.el6_0.1.x86_64
poppler-qt4-0.12.4-3.el6_0.1.x86_64
cloog-ppl-0.15.7-1.2.el6.x86_64
gnome-python2-applet-2.28.0-5.el6.x86_64
gnome-applets-2.28.0-7.el6.centos.x86_64
ppl-devel-0.10.2-11.el6.x86_64
gdm-user-switch-applet-2.30.4-52.el6.x86_64
poppler-data-0.4.0-1.el6.noarch
ppl-0.10.2-11.el6.x86_64
[root@db12c ~]#

[root@db12c ~]# grep -i pam_limits.so  /etc/pam.d/loginsession required pam_limits.so
[root@db12c ~]#
[root@db12c ~]# gcc --versiongcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-4)
Copyright (C) 2010 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
[root@db12c ~]# g++ --versiong++ (GCC) 4.4.7 20120313 (Red Hat 4.4.7-4)
Copyright (C) 2010 Free Software Foundation, Inc.
This is free software; see the source for copying conditions.  There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
[root@db12c ~]#
[root@db12c ~]#  hostnamedb12c.askmlabs.com
[root@db12c ~]#

2.3 Extract the software and start the installation











[root@db12c ~]# /home/apps/oem12c/product/12.1.0/dbhome_1/root.sh
Performing root user operation for Oracle 12c

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /home/apps/oem12c/product/12.1.0/dbhome_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...


Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
[root@db12c ~]#




[root@db12c ~]# su - oracle
[oracle@db12c ~]$ ps -ef | grep -i pmonoracle    2598     1  0 Feb23 ?        00:00:02 ora_pmon_VIS
oracle   13254     1  0 01:09 ?        00:00:00 ora_pmon_oem12c
oracle   14186 14152  0 01:39 pts/2    00:00:00 grep -i pmon
[oracle@db12c ~]$ export ORACLE_SID=oem12c[oracle@db12c ~]$ export ORACLE_HOME=/home/apps/oem12c/product/12.1.0/dbhome_1[oracle@db12c ~]$ export PATH=$PATH:$ORACLE_HOME/bin[oracle@db12c ~]$ which sqlplus/home/apps/oem12c/product/12.1.0/dbhome_1/bin/sqlplus
[oracle@db12c ~]$ sqlplus '/as sysdba'
SQL*Plus: Release 12.1.0.1.0 Production on Mon Feb 24 01:40:33 2014
Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,user,created,CDB,CON_ID,CON_DBID from v$database;
NAME      USER                           CREATED   CDB     CON_ID   CON_DBID
--------- ------------------------------ --------- --- ---------- ----------
OEM12C    SYS                            24-FEB-14 NO           0  151531197
SQL> select instance_name,status from v$instance;
INSTANCE_NAME    STATUS
---------------- ------------
oem12c           OPEN
SQL>

Reference : MOS ID  Note 1529864.1

Hope this helps
SRI
Share this article :

Related Articles By Category



Post a Comment

Thank you for visiting our site and leaving your valuable comment.

 
Support :
Copyright © 2013. askMLabs - All Rights Reserved
Proudly powered by Blogger