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

Sunday, 4 March 2012

Installation of Oracle Enterprise Manager 12c cloud control on Linux

This article will demonstrate step-by-step procedure to Install Oracle Enterprise Manager Cloud Control 12c software on Linux. The Installation is performed on Oracle Enterprise Linux 5.6 (32-bit).

Oracle EM 12 c cloud control is the next generation system management and monitoring software.

This software is certified on Oracle enterprise Linux 4 and 5 only. Its still not certified on oracle Linux 6.

Software's used:

1) Oracle Enterprise Linux 5.6
2) Oracle Database 11.2.0.1
3) Oracle Enterprise manager 12c cloud control


The complete Installation and configuration is performed in three steps:

step 1 : Perform all OS related per-requisites
step 2 : Install and configure database
step 3 : Install Oracle 12c cloud control



step 1 : Perform all OS related per-requisites

-> Hardware requirement:

CPU - 2 cores
RAM - 4 GB Min.
HDD Space - 8 GB required

I've used one virtual machine with single core CPU, 4 GB RAM and 20 GB HDD space.


-> Os package requirement:

The below listed are the required rpms.



make-3.81
binutils-2.17.50.0.6
gcc-4.1.1
libaio-0.3.106
glibc-common-2.3.4
compat-libstdc++296-2.96
libstdc++ 4.1.1
libstdc++devel-4.1.0
setarch-1.6
sysstat-5.0.5
compat-db 4.1.25
rng_utils-2.0
libXtst-1.0.1-3.1(i386)
xorg-x11-utils



This packages can be verified whether it's installed or not using command:



rpm -qa | grep package-name


[root@oracloud1 ~]# rpm -qa | grep binutils-2*
binutils-2.17.50.0.6-14.el5
[root@oracloud1 ~]# rpm -qa | grep gcc-4*
gcc-c++-4.1.2-50.el5
libgcc-4.1.2-50.el5
compat-gcc-34-g77-3.4.6-4.1
gcc-4.1.2-50.el5
compat-gcc-34-c++-3.4.6-4.1
compat-libgcc-296-2.96-138
compat-gcc-34-3.4.6-4.1
gcc-java-4.1.2-50.el5
gcc-gfortran-4.1.2-50.el5
[root@oracloud1 ~]# rpm -qa | grep libaio*
libaio-0.3.106-5
libaio-devel-0.3.106-5
[root@oracloud1 ~]# rpm -qa | grep glibc-common-2*
glibc-common-2.5-58
[root@oracloud1 ~]# rpm -qa | grep libstdc++*
compat-libstdc++-296-2.96-138
libstdc++-4.1.2-50.el5
libstdc++-devel-4.1.2-50.el5
compat-libstdc++-33-3.2.3-61
[root@oracloud1 ~]# rpm -qa | grep syssta*
sysstat-7.0.2-3.el5_5.1
[root@oracloud1 ~]# rpm -qa | grep setarch*
setarch-2.0-1.1
[root@oracloud1 ~]# rpm -qa | grep rng-utils*
rng-utils-2.0-4.el5
[root@oracloud1 ~]#



-> create OS group and User:

ora11g is the user who is the owner of oracle database as well as EM 12c cloud software it belongs to dba group



[root@oracloud1 ~]# groupadd dba
[root@oracloud1 ~]# useradd -g dba ora11g
[root@oracloud1 ~]# passwd ora11g
Changing password for user ora11g.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully



-> create directories for Installation:

/u01/oradb --> Oracle database
/u01/em12_home --> Oracle EM 12c cloud control



[root@oracloud1 ~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda1 4.8G 3.2G 1.4G 71% /
/dev/sda3 26G 173M 24G 1% /u01
tmpfs 2.0G 0 2.0G 0% /dev/shm
[root@oracloud1 ~]# cd /u01
[root@oracloud1 u01]# mkdir oradb
[root@oracloud1 u01]# mkdir em12_home
[root@oracloud1 u01]# chmod -R 775 /u01/oradb
[root@oracloud1 u01]# chown -R ora11g:dba /u01/oradb
[root@oracloud1 u01]# chmod -R 775 /u01/em12_home
[root@oracloud1 u01]# chown -R ora11g:dba /u01/em12_home
[root@oracloud1 u01]#



-> Configure OS kernel parameters:



#All below kernel parameters are related to oracle
#################
kernel.shmall = 268435456
kernel.shmmax = 429496729
kernel.shmmni = 4096
kernel.sem = 256 32000 100 142
fs.file-max = 327679
net.ipv4.ip_local_port_range = 10000 65000
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_max = 4194304
:wq





[root@oracloud1]# vi /etc/security/limits.conf
ora11g hard nofile 65536
ora11g soft nofile 4096
ora11g hard nproc 16384
ora11g soft nproc 2047
:wq



-> Verify kernel parameters:


[root@oracloud1 ~]# sysctl -p
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 2
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 4294967295
kernel.shmall = 268435456
kernel.shmmax = 429496729
kernel.shmmni = 4096
kernel.sem = 256 32000 100 142
fs.file-max = 327679
net.ipv4.ip_local_port_range = 10000 65000
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_max = 4194304
[root@oracloud1 ~]#



-> create environment file for database 11g and EM 12c


[ora11g@oracloud1 ~]$ more emdb.env
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_UNQNAME=emdb; export ORACLE_UNQNAME
ORACLE_BASE=/u01/oradb/ora11g; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME
ORACLE_SID=emdb; export ORACLE_SID
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
OMS_HOME=/u01/em12_home/oms; export OMS_HOME
AGENT_HOME=/u01/em12_home/agent/core/12.1.0.1.0; export AGENT_HOME

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
[ora11g@oracloud1 ~]$




step 2 : Install and configure database

The below steps to install and configure database.

































-> de-configure enterprise manager from database



[ora11g@oracloud1 ~]$ emca -deconfig dbcontrol db -repos drop -SYS_PWD oracle -SYSMAN_PWD oracle

STARTED EMCA at Mar 3, 2012 11:29:16 AM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: emdb
Listener port number: 1521

Do you wish to continue? [yes(Y)/no(N)]: Y
Mar 3, 2012 11:29:28 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/oradb/ora11g/cfgtoollogs/emca/emdb/emca_2012_03_03_11_29_15.log.
Mar 3, 2012 11:29:28 AM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Mar 3, 2012 11:29:53 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Mar 3, 2012 11:32:13 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Mar 3, 2012 11:32:18 AM
[ora11g@oracloud1 ~]$



-> Modify Initialization parameters as required by EM 12c




SQL> !more mem_mod.sql
ALTER SYSTEM SET processes=300 SCOPE=SPFILE;
ALTER SYSTEM SET session_cached_cursors=200 SCOPE=SPFILE;
ALTER SYSTEM SET sga_target=2G SCOPE=SPFILE;
ALTER SYSTEM SET shared_pool_size=600M SCOPE=SPFILE;
ALTER SYSTEM SET pga_aggregate_target=1G SCOPE=SPFILE;
ALTER SYSTEM SET job_queue_processes=20 SCOPE=SPFILE;

[ora11g@oracloud1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sat Mar 3 11:35:51 2012

Copyright (c) 1982, 2009, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @mem_mod.sql

System altered.


System altered.


System altered.


System altered.


System altered.


System altered.

SQL>



-> shutdown and startup database



SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> create pfile from spfile;

- comment paramter memory_target in initemdb.ora file
- startup database with pfile


SQL> startup
ORACLE instance started.

Total System Global Area 2142679040 bytes
Fixed Size 1337720 bytes
Variable Size 671090312 bytes
Database Buffers 1459617792 bytes
Redo Buffers 10633216 bytes
Database mounted.
Database opened.




step 3 : Install Oracle 12c cloud control

- I've extracted the sw zip files in windows and copied it to the linux box as i faced problems with installation when i unzipped it on the server

- Set the proper display variable and begin with the Installation

- screens for Installation








- here it failed for package compat-db, after Instillation of this package the pre-req check was successfull



- swap space is almost nearest value (4094 MB) as recommended (4096 MB) so ignored







- Here /u01/em12_home/oracle is actual value


































Done with the Installation.

All comments/suggestion/issues with configuration of EM 12c cloud control are appreciated


My next articles related to EM 12c cloud control:

1) Installation of EM12c on Solaris sparc and Solaris X86-64
2) upgrading EM12c from 10g/11g grid control.
2) Deployment and management of agent on targets
3) Managing RAC databases with EM 12c

thanks and regards,
Syed Zaheer

2 comments:

Oracle Apps DBA said...
This comment has been removed by the author.
Oracle DBA said...

good job dude!