Oracle Enterprise Manager 12c Installation

 

Copyright © 2013 Mokum Solutions, Inc. All rights reserved.

Distribution of the Oracle Cloud Cookbook or derivative of the work in any form for commercial purposes is prohibited unless prior permission is obtained from the copyright holder.

 

Author: Roddy Rodstein

 

This document applies to Oracle Enterprise Manager 12c Release 2 installed on Oracle Linux 5 or 6.

 

...oracle-validated RPM - Oracle Linux 5

...oracle-rdbms-server-11gR2-preinstall - Oracle Linux 6

...iptables

...SELinux

.../etc/hosts

...Adjust the Shared Memory File System for the Database Host

...Create the Required Directories using the Optimal Flexible Architecture (OFA) Standard

...SSH and X11 Forwarding

...ulimit /etc/security/limits.conf Values

 

Oracle Enterprise Manager 12c is a systems management framework consisting of an Oracle database, Oracle WebLogic, a J2EE application, an application development frame work 11g (ADF) administrative Web GUI, server and client side plug-ins, and a client side agent. In the context of Oracle Enterprise Manager, the Oracle database repository is named the “Oracle Management Repository” or “OMR”. WebLogic is the J2EE platform called the “Oracle Management Service” or “OMS”, that runs the Oracle Enterprise Manager 12c J2EE application. The administrative Web GUI is named Oracle Enterprise Manager Cloud Control. The client side agents are named the “Oracle Management Agents” or “OMA”. The server and client side plug-ins share a unique name for the managed product or technology. Monitored hosts are referred to as targets. All of the Oracle Enterprise Manager components are commonly referred to as Oracle Enterprise Manager (OEM) or Enterprise Manager (EM).

 

The Oracle Management Repository, the Oracle Management Service along with the Oracle Management Agent can be installed on a single x86-64 Linux host in an all-in-one configuration for evaluations or in an n-tier configuration for production. Traditionally, production Oracle Enterprise Manager environments are not be placed on a single server, nor should the Oracle Management Repository be shared with production or test databases on the same server. For production, the Oracle Management Repository as well as WebLogic should be on dedicated virtual or physical servers. If your Oracle Enterprise Manager environment starts out small, make sure to have a plan to scale out your Oracle Enterprise Manager infrastructure.

• Oracle Linux and Red Hat Enterprise Linux 6.x (6.x means 6.0 through 6U4)
• Oracle Linux and Red Hat Enterprise Linux 5.x (5.x means 5.0 through 5U9)
• Asianux 3
• SUSE Linux Enterprise 10 and 11

• Oracle 11.2.0.3.0
• Oracle 11.2.0.2.0
• Oracle 11.2.0.1.0
• Oracle 11.1.0.7.0
• Oracle 10.2.0.5.0

Each of the Oracle Enterprise Manager 12c components can be installed using the Oracle Universal Installer (OUI) GUI, or using silent installation scripts, or with the software only, configure later installation mode. The software only installation mode allows you to install only the Oracle Enterprise Manager software binaries without any configurations. The software only installation mode is ideal if you want to install the software at one point and configure the software later.

 

Note: This chapter reviews the Oracle Universal Installer (OUI) installation mode.

 

Oracle Enterprise Manager 12c Inter Component Communication and Data Exchange

Oracle Enterprise Manager 12c System Design Considerations

Oracle Enterprise Manager 12c server sizing is calculated by a) total number of managed agents and targets, b) the future growth of your Oracle Enterprise Manager environment and c) your organization's high availability requirements. For example, if you know the total number of managed agents and targets, sizing WebLogic and the Oracle database is as simple as following Table 2, Table 3 and Table 4. As you add more agents and targets, it is important to consider the future growth of your Oracle Enterprise Manager environment as well as the ability to scale up or to scale out with additional CPU, RAM and storage.

 

Table 1 shows the minimum physical memory and storage requirements for the WebLogic server hosting the Oracle Management Service and the Oracle Management Agent.

Installation Type	Physical Memory (RAM)	Storage
Oracle Management Service	*6 GB	10 GB
Oracle Management Agent

Deployment Size	RAM	Intel or AMD CPU Cores	Hosts
Small < 100 agents < 1000 targets	*6 GB	2	1
Medium < 1000 agents < 10,000 targets	*6 GB	4	1
Large > 1000 agents > 10,000 targets	*6 GB	4	2

* To use BI Publisher add 1.5 GB of RAM.

Table 3 shows the minimum RAM, CPU cores, storage and the number of hosts for the database server hosting the Oracle Management Repository..

Deployment Size	RAM	Intel or AMD CPU Cores	Storage	Hosts
Small < 100 agents  < 1000 targets	2 GB	2	62 GB	1
Medium < 1000 agents < 10,000 targets	4 GB	4	225 GB	1
Large > 1000 agents > 10,000 targets	6 GB	4	345 GB	2

Table 4 shows the minimum storage requirements for a standalone Oracle Management Agent installation.

Platform	Storage	TMP Directory
Linux 32 bit	1.2 GB	400 MB
Linux x86_64	1.2 GB	400 MB

Oracle recommends installing Oracle Linux and Red Hat Enterprise using the default software package selection without any customization. Using the default software packages without customizations includes most of the prerequisite packages for Oracle Enterprise Manager 12c  and helps limit the number of manual prerequisite checks. After an Oracle Linux and/or Red Hat Enterprise Linux installation, Oracle recommends to register your server with the Unbreakable Linux Network (ULN) and to install the Legacy Software Development packages by typing “up2date -i @ Legacy Software Development“ or if you have a local yum repository type “yum groupinstall "Legacy Software Development"” to install most of the remaining Oracle technology product prerequisite packages. Once the Legacy Software Development packages are installed,  install the oracle-validated RPM to meet all of the remaining Oracle Enterprise Manager 12c prerequisite packages.

 

The oracle-validated RPM simplifies meeting the software and system configuration prerequisites for installing Oracle Enterprise Manager 12c. Installing the oracle-validated RPM automatically installs all of the software RPM prerequisites for the Oracle Enterprise Manager 12c and the Oracle Database as well as meeting the system configuration prerequisites, such as creating an oracle user and the oinstall and dba groups, configuring the sysctl.conf settings, system startup parameters, user limits, and driver parameters.

 

The oracle-validated RPM is available at the Oracle Unbreakable Linux Network, on the Oracle Linux media, and from the Oracle public yum repository. The oracle-validated RPM can be installed from the Oracle Unbreakable Linux Network by typing "up2date --install oracle-validated", ULN registration and a valid Linux CSI is required.  If you do not have access to Oracle Unbreakable Linux Network, the oracle-validated RPM can be installed from a local DVD repository as well as from Oracle' public yum repository. 

 

Oracle Linux maintains yum repositories in the /etc/yum.repos.d/ directory. For example, to setup a DVD repository, mount the Oracle Linux 5.x DVD, and create a file in the /etc/yum.repos.d/<MY FILE>.repo directory that instructs the yum client to use the DVD repository. The next examples shows the syntax of a .repo file pointing to a mounted Oracle Linux DVD in the /mnt/dvd/ directory.  

# cat /etc/yum.repos.d/ol-5U7-dvd.repo
[ol5_u7_dvd]
name=Oracle Linux $releasever - $basearch
baseurl=file:///mnt/dvd/Server/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle

Before installing the oracle-validated RPM, clean the yum cache by typing “yum clean all” to re-read the repodata and caches. Once the DVD is mounted and the <MY FILE>.repo file is created, type “yum install oracle-validated” to install the oracle-validated RPM.

To install the oracle-validated RPM from the Oracle public yum repository, as root, change to the /etc/yum.repos.d/ directory and type “wget http://public-yum.oracle.com/public-yum-el5.repo” to download the public-yum-el5.repo file. Next, edit the public-yum-el5.repo file and enable the base repository for your Oracle Linux version by changing enabled=0 to enabled=1.

The next examples shows the public-yum-el5.repo file.

# vi  /etc/yum.repos.d/public-yum-el5.repo
[el5_ga_base]
name=Enterprise Linux $releasever GA - $basearch - base
baseurl=http://public-yum.oracle.com/repo/EnterpriseLinux/EL5/0/base/$basearch/
gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-el5
gpgcheck=1
enabled=0
 
[el5_u1_base]
name=Enterprise Linux $releasever U1 - $basearch - base
baseurl=http://public-yum.oracle.com/repo/EnterpriseLinux/EL5/1/base/$basearch/
gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-el5
gpgcheck=1
enabled=0
 
[el5_u2_base]
name=Enterprise Linux $releasever U2 - $basearch - base
baseurl=http://public-yum.oracle.com/repo/EnterpriseLinux/EL5/2/base/$basearch/
gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-el5
gpgcheck=1
enabled=0
 
[el5_u3_base]
name=Enterprise Linux $releasever U3 - $basearch - base
baseurl=http://public-yum.oracle.com/repo/EnterpriseLinux/EL5/3/base/$basearch/
gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-el5
gpgcheck=1
enabled=0
 
[el5_u4_base]
name=Enterprise Linux $releasever U4 - $basearch - base
baseurl=http://public-yum.oracle.com/repo/EnterpriseLinux/EL5/4/base/$basearch/
gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-el5
gpgcheck=1
enabled=0
 
[el5_u5_base]
name=Enterprise Linux $releasever U5 - $basearch - base
baseurl=http://public-yum.oracle.com/repo/EnterpriseLinux/EL5/5/base/$basearch/
gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-el5
gpgcheck=1
enabled=0
 
[ol5_u5_base]
name=Oracle Linux $releasever - U5 - x86_64 - base
baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL5/5/base/x86_64/
gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-el5
gpgcheck=1
enabled=0
 
[ol5_u6_base]
name=Oracle Linux $releasever - U6 - $basearch - base
baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL5/6/base/$basearch/
gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-el5
gpgcheck=1
enabled=0
 
[ol5_u7_base]
name=Oracle Linux $releasever - U7 - $basearch - base
baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL5/7/base/$basearch/
gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-el5
gpgcheck=1
enabled=0
 
[el5_addons]
name=Enterprise Linux $releasever - $basearch - addons
baseurl=http://public-yum.oracle.com/repo/EnterpriseLinux/EL5/addons/$basearch/
gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-el5
gpgcheck=1
enabled=0
 
[el5_oracle_addons]
name=Enterprise Linux $releasever - $basearch - oracle_addons
baseurl=http://public-yum.oracle.com/repo/EnterpriseLinux/EL5/oracle_addons/$basearch/
gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-el5
gpgcheck=1
enabled=0

Tip: Enable a repository by changing enabled=0 to enabled=1. Enable the base repository for the Oracle Linux version being used. The next examples shows how to enable the Oracle Linux 5U7 base repository.

 

[ol5_u7_base]
name=Oracle Linux $releasever - U7 - $basearch - base
baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL5/7/base/$basearch/
gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-el5
gpgcheck=1
enabled=1

 

The next examples shows how to enable the Oracle Linux 5U6 base repository.

 

[ol5_u6_base]
name=Oracle Linux $releasever - U6 - $basearch - base
baseurl=http://public-yum.oracle.com/repo/OracleLinux/OL5/6/base/$basearch/
gpgkey=http://public-yum.oracle.com/RPM-GPG-KEY-oracle-el5
gpgcheck=1
enabled=1

Once you have enabled the desired base repository by changing enabled=0 to enabled=1, clean the yum cache by typing “yum clean all” to re-read the repodata and caches. Next, type “yum install oracle-validated” to install the oracle-validated RPM.

 

The oracle-rdbms-server-11gR2-preinstall RPM, formally know as oracle-validated, simplifies meeting the software and system configuration prerequisites for installing Oracle Enterprise Manager 12c on Oracle Linux 6. Installing the oracle-rdbms-server-11gR2-preinstall RPM automatically installs all of the software RPM prerequisites for Oracle Enterprise Manager 12c as well as meeting the system configuration prerequisites, such as creating an oracle user and the oinstall and dba groups, configuring the sysctl.conf settings, system startup parameters, user limits, and driver parameters.

The oracle-rdbms-server-11gR2-preinstall RPM is available at the Oracle Unbreakable Linux Network, on the Oracle Linux media, and from the Oracle public yum repository.

To install the oracle-rdbms-server-11gR2-preinstall RPM from the Oracle public yum repository, as root type the following commands:

# cd /etc/yum.repos.d/
# wget http://public-yum.oracle.com/public-yum-ol6.repo
# yum install oracle-rdbms-server-11gR2-preinstall

 

iptables is a userspace firewall application used to configure the Linux IPv4 and IPv6 packet filtering rulesets. iptables is installed and enabled by default on Oracle Linux with a default policy and ruleset in /etc/sysconfig/iptables. iptables rules can be configured at the command line as well as with the system setup utility, i.e. "/usr/bin/setup".

# service iptables stop && service ip6tables stop && chkconfig iptables off && chkconfig ip6tables off

 

iptables can be re-inabled by typing the following command as root.

# service iptables start && service ip6tables start && chkconfig iptables on && chkconfig ip6tables on

 

The Finish screen shows the Enterprise Manager Database Control URL. Click the Close button to close the installation program

Next, as the oracle user drop Enterprise Manager Database Control by typing the following command. Substitute  <sys pasword> with the sys password and <sysman password> with the sysman password selected during the database installation.

$ $ORACLE_HOME/bin/emca -deconfig dbcontrol db -repos drop -SYS_PWD <sys pasword> -SYSMAN_PWD <sysman password>

STARTED EMCA at Nov 22, 2011 1:44:08 PM
EM Configuration Assistant, Version 11.2.0.0.2 Production
Copyright (c) 2003, 2005, Oracle.  All rights reserved.

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

Do you wish to continue? [yes(Y)/no(N)]: Y
Nov 22, 2011 1:44:23 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/product/cfgtoollogs/emca/orcl/emca_2011_11_22_13_44_08.log.
Nov 22, 2011 1:44:23 PM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Nov 22, 2011 1:44:45 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Nov 22, 2011 1:47:18 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Nov 22, 2011 1:47:21 PM

Next, assess the database as sysdba and create a pfile from the spfile. 

Next, edit the database init file and change the *.memory_target parameter to 3221225472, i.e. add a new line with "*.memory_target=3221225472" in the init file:
# vi /u01/app/oracle/product/11.2.0/dbhome_1/dbs/initorcl.ora
*.memory_target=3221225472
:wq!

Next, create a directory for the redo log files, as shown in the next example.

# mkdir /u01/app/oracle/product/redo_logs/

Next, access the database as sysdba and make the following initialization parameter changes, then restart the database.

sqlplus / AS SYSDBA
ALTER SYSTEM SET processes=300 SCOPE=SPFILE;
System altered.
ALTER SYSTEM SET session_cached_cursors=200 SCOPE=SPFILE;
System altered.
ALTER SYSTEM SET sga_target=2G SCOPE=SPFILE;
System altered.
ALTER SYSTEM SET shared_pool_size=600M SCOPE=SPFILE;
System altered.
ALTER SYSTEM SET pga_aggregate_target=1G SCOPE=SPFILE;
System altered.
ALTER SYSTEM SET job_queue_processes=20 SCOPE=SPFILE;
System altered.
ALTER DATABASE force logging;
System altered.
ALTER TABLESPACE users FORCE LOGGING;
System altered.
EXEC dbms_auto_task_admin.disable('auto optimizer stats collection',null,null);
PL/SQL procedure successfully completed.
ALTER DATABASE ADD LOGFILE ('/u01/app/oracle/product/redo_logs/log1c.rdo', '/u01/app/oracle/product/redo_logs/log2c.rdo', '/u01/app/oracle/product/redo_logs/log3c.rdo') SIZE 100M;
System altered.

SHUTDOWN IMMEDIATE;
SQL> CREATE SPFILE FROM PFILE;
SQL> startup;
ORACLE instance started.

Total System Global Area 3206836224 bytes
Fixed Size            2217632 bytes
Variable Size         1744832864 bytes
Database Buffers     1442840576 bytes
Redo Buffers           16945152 bytes
Database mounted.
Database opened.

SQL> quit

Oracle Enterprise Manager 12c Installation

This section walks through an Advanced installation of the Oracle Enterprise Manager 12c Release 2 (12.1.0.2) Oracle Management Service and the Oracle Management Agent using the Oracle Universal Installer (OUI) on Oracle Linux 5U9.

Tip: Make sure that the Oracle user environmental variables are not set until after the installation of Oracle Enterprise Manager. For example, do not setup the .bash_profile file until after the installation of all the software. To temporarily unset the Oracle user environmental variables, as the oracle user type "unset ORACLE_BASE ORACLE_HOME EMDROOT AGENT_HOME OMS_HOME ORACLE_INSTANCE ORACLE_SID ORACLE_UNQNAME ORACLE_TERM".

With the software downloaded and staged for the Oracle Linux host, as the oracle user, run the runInstaller script by typing "./runInstaller" as shown in the next example.

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 400 MB.   Actual 3965 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 6160 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-12-01_11-13-51AM. Please wait ...

• Select Skip to not search My Oracle Support for updates or to install updates from a local directory
• Select Local Directory if you have allready downloaded and staged updates
• Select My Oracle Support (Requires Internet Connection) to enter your My Oracle Support credentials to search My Oracle Support for updates.