Archive for the ‘Oracle Grid control’ Category

Oracle Enterprise Manager Cloud Control Installation on Solaris Spark 64bit


As stated earlier on my post about the installation of Oracle 12c enterprise manager cloud control installation. So , friends this post belong to the installation….

Please comment your suggestion or any feedback.


The minimal Hardware requirement for OMS (got the data from metalink docs) –


1 OMS, < =1000 targets, <100 agents 2 OMSes for < =10,000 targets and <1000 agents >2 OMSes, >=10,000 targets, >=1000 agents
CPU Cores/Host 2 4 8
RAM 4 GB 6 GB 8 GB
RAM with ADP, JVMD 6 GB 10 GB 14 GB
Oracle WebLogic Server JVM Heap Size 512 MB 1 GB 2 GB
Hard Disk Space 7 GB 7 GB 7 GB
Hard Disk Space with ADP, JVMD 10 GB 12 GB 14 GB


Note – If you have Enterprise Manager 10g Grid Control Release 4 ( or lower installed, then you must first upgrade to Enterprise Manager 10g Grid Control Release 5 ( or Enterprise Manager 11g Grid Control Release 1 ( before you can upgrade to the new release.


Before proceeding please drop the old enterprise manager repository database.

Follow the steps to drop the old EM (Single Instance) repository –

  1. $ORACLE_HOME/bin/emca <space>-deconfig <space> dbcontrol <space> db<space> -repos <space> drop <space> – SYS_PWD <SYS Password> <space> – SYSMAN_PWD <SYSMAN Password>
  2. Enter the following information:

Database SID: DBTEST11G

Listener port number: 1525

To de-configure Database Control for a Real Application Clusters (RAC) database, follow the following command on database host:

  1. Set the environment variable <ORACLE_HOME>.
  2. Now run the following command:

$ORACLE HOME/bin/emca <space> -deconfig <space> dbcontrol <space> db <space> -repos <space>drop <space> -cluster <space> -SYS_PWD <space> <sys password> <space> -SYSMAN_PWD <sysman password>



Oracle strongly suggest to make below changes on your database before start 12c installation Init.ora parameter dedicated to EM12.







MEMORY_TARGET => should not be used

Or if your using and using automatic memory management then no need to update SGA_TARGET or PGA_AGGREGATE_TARGET


Now that the environment and repository database is ready let’s start the installation.

First we need to update the parameters as per our environment.

SQL> alter system set shared_pool_size=600M scope=both sid=’*’;

alter system set PGA_AGGREGATE_TARGET=1G scope=both sid=’*’;

alter system set PROCESSES=300 scope=spfile sid=’*’;

alter system set sessions=335 scope=spfile sid=’*’;

(as the 10g rule applied for 1.1*process+5)

alter system set JOB_QUEUE_PROCESSES=20 scope=both sid=’*’;

alter system set SESSION_CACHED_CURSORS=300 scope=spfile sid=’*’;

Oracle recommended to use UNDO tablespace is at least 200M in size.


In 11g version We need to install Weblogic separately but in 12c its comes by default .(Default version is 10.3.5

Please be sure DO NOT SET ORACLE_HOME or ORACLE_SID before start installation

Oracle also recommended to set umask 022 before start installation

Now we can start 12.1 installation.


Go to 12.1 setup path and type below command to can start installation



  • ./runInstaller


  • Optional screen to provide oracle support credentials.


  • If you are skipping the support credentials page. Just press yes and proceed.



  • Next screen is the prerequisite check(here we got a failed prerequisite check ulimit)


To solve the ulimit error we need to add set ulimit = 4096 /etc/system file if available but in our scenario as it is a virtual server we have to add it to /etc/project file.


save the file and do source /etc/project and check it

bash-3.2$ projects -l


projid : 0

comment: “”

users : (none)

groups : (none)



projid : 1

comment: “”

users : (none)

groups : (none)



projid : 2

comment: “”

users : (none)

groups : (none)



projid : 3

comment: “”

users : (none)

groups : (none)



projid : 10

comment: “”

users : (none)

groups : (none)



projid : 100

comment: “”

users : (none)

groups : (none)

attribs: project.max-sem-ids=(privileged,100,deny)






  •  Once the prerequisite have passed we can proceed with Installation type.


Here we need to select the installation type depend upon our environment to monitor.

If you use Simple than Cloud Control will install by default plugins. (Exadata ,Oracle Database, Fusion Middleware, My Oracle Support)

  • Next we have to provide the location for Middleware and Agent Binaries.


  • Next we need to supply the oms admin credentials with the DB details where you want to install the management repository database.


While specifying Database Host name please be sure to use the fully qualified domain name like testDB.oracle.com or you can also supply the host IP.

  • Review the setup and click next.


  • In addition after proceeding with the setup you may get yes/no and ok/cancel screen just review and proceed further.


  • After the installation is successful. Just execute the root.sh

Now wait for around 45 minutes to complete the setup and open the URL at the browser…


  1. After everything is done successfully. Use the link to open the enterprise manager console.



Login with the username sysman and the password you have provided during installation.


  To check the status of enterprise manager agent.

cd $AGENT_HOME/bin

bash-3.2$ ./emctl status agent

Oracle Enterprise Manager Cloud Control 12c Release 4

Copyright (c) 1996, 2014 Oracle Corporation. All rights reserved.


Agent Version         :

OMS Version           :

Protocol Version       :

Agent Home             : /u01/oracle/enterprise_mang/agent/agent_inst

Agent Log Directory   : /u01/oracle/enterprise_mang/agent/agent_inst/sysman/log

Agent Binaries         : /u01/oracle/enterprise_mang/agent/core/

Agent Process ID      : 5969

Parent Process ID     : 5918

Agent URL             : https://testDB:3872/emd/main/

Local Agent URL in NAT : https://testDB:3872/emd/main/

Repository URL         : https://testDB:1159/empbs/upload

Started at             : 2014-09-15 21:24:42

Started by user       : oracle

Operating System       : SunOS version 5.10 (sparcv9)

Last Reload           : (none)

Last successful upload                       : 2014-09-16 12:16:28

Last attempted upload                       : 2014-09-16 12:16:28

Total Megabytes of XML files uploaded so far : 2.06

Number of XML files pending upload           : 0

Size of XML files pending upload(MB)         : 0

Available disk space on upload filesystem   : 44.19%

Collection Status                           : Collections enabled

Heartbeat Status                             : Ok

Last attempted heartbeat to OMS             : 2014-09-16 12:17:03

Last successful heartbeat to OMS             : 2014-09-16 12:17:03

Next scheduled heartbeat to OMS             : 2014-09-16 12:18:03



Agent is Running and Ready




Hope that will help a bit…


Thanks & Regards

Nimai Karmakar

Read Full Post »


Few days back we have a requirement to install oracle 12c enterprise manager cloud control for a Solaris Server 10 with 16 database to be monitored.

So, it was a good opportunity for me to learn and share , so as discussed on my earlier post for some griding.

Below are some of the basic concepts which help me from docs.


In case you want to know anything other than this please comment ….



Oracle 12c Enterprise manager Cloud control basic concepts……




Monitoring Overview

Enterprise Manager Cloud Control monitoring functionality permits unattended monitoring of your IT environment. Enterprise Manager comes with a comprehensive set of performance and health metrics that allows monitoring of key components in your environment, such as applications, application servers, databases, as well as the back-end components on which they rely (such as hosts, operating systems, storage).

The Management Agent on each monitored host monitors the status, health, and performance of all managed components (targets) on that host. If a target goes down, or if a performance metric crosses a warning or critical threshold, an event is triggered and sent to Enterprise Manager. Administrators or any interested party can be notified of the triggered event through the Enterprise Manager Notification system.


Adding targets to monitor is simple. Enterprise Manager provides you with the option of either adding targets manually or automatically discovering all targets on a host. Enterprise Manager can also automatically and intelligently apply monitoring settings for newly added targets.


As your data center grows, it will become more challenging to manage individual targets separately, thus you can use Enterprise Manager’s group management functionality to organize large sets of targets into groups, allowing you to monitor and manage many targets as one.



Comprehensive Out-of-Box Monitoring

Monitoring begins as soon as you install Enterprise Manager Cloud Control 12c. Enterprise Manager’s Management Agents automatically start monitoring their host’s systems (including hardware and software configuration data on these hosts) as soon as they are deployed and started. Enterprise Manager provides auto-discovery scripts that enable these Agents to automatically discover all Oracle components and start monitoring them using a comprehensive set of metrics at Oracle-recommended thresholds.

Metrics from all monitored components are stored and aggregated in the Management Repository, providing administrators with a rich source of diagnostic information and trend analysis data. When critical alerts are detected, notifications are sent to administrators for rapid resolution.

Out-of-box, Enterprise Manager monitoring functionality provides:

  • In-depth monitoring with Oracle-recommended metrics and thresholds.
  • Monitoring of all components of your IT infrastructure (Oracle and non-Oracle) as well as the applications and services that are running on them.
  • Access to real-time performance charts.
  • Collection, storage, and aggregation of metric data in the Management Repository. This allows you to perform strategic tasks such as trend analysis and reporting.
  • E-mail and pager notifications for detected critical events.

Enterprise Manager can monitor a wide variety of components (such as databases, hosts, and routers) within your IT infrastructure.

Some examples of monitored metrics are:

  • Archive Area Used (Database)
  • Segments Approaching Maximum Extents Count (Database)
  • Network Interface Total I/O Rate (Host)

Monitoring: Basics

Enterprise Manager Cloud Control 12c comes with a comprehensive set of predefined performance and health metrics that enables automated monitoring of key components in your environment, such as applications, application servers, databases, as well as the back-end components on which they rely, such as hosts, operating systems, storage. While Enterprise Manager can monitor for many types of conditions (events), the most common use of its monitoring capability centers around the basics of monitoring for violation of acceptable performance boundaries defined by metric values.

Some metrics have associated predefined limiting parameters called thresholds that cause metric alerts (specific type of event) to be triggered when collected metric values exceed these limits. Enterprise Manager allows you to set metric threshold values for two levels of alert severity:

  • Warning – Attention is required in a particular area, but the area is still functional.
  • Critical – Immediate action is required in a particular area. The area is either not functional or indicative of imminent problems.

Hence, thresholds are boundary values against which monitored metric values are compared. For example, for each disk device associated with the Disk Utilization (%) metric, you might define a warning threshold at 80% disk space used and critical threshold at 95%.




Blackouts allow you to support planned outage periods to perform scheduled or emergency maintenance. When a target is put under blackout, monitoring is suspended, thus preventing unnecessary alerts from being sent when you bring down a target for scheduled maintenance operations such as database backup or hardware upgrade. Blackout periods are automatically excluded when calculating a target’s overall availability.

A blackout period can be defined for individual targets, a group of targets or for all targets on a host. The blackout can be scheduled to run immediately or in the future, and to run indefinitely or stop after a specific duration. Blackouts can be created on an as-needed basis, or scheduled to run at regular intervals. If, during the maintenance period, you discover that you need more (or less) time to complete maintenance tasks, you can easily extend (or stop) the blackout that is currently in effect. Blackout functionality is available from both the Enterprise Manager console as well as via the Enterprise Manager command-line interface (EM CLI).



For a typical monitoring scenario, when a target becomes unavailable or if thresholds for performance are crossed, events are raised and notifications are sent to the appropriate administrators. Enterprise Manager supports notifications via e-mail, pager, SNMP traps, or by running custom scripts and allows administrators to control these notification mechanisms through:

  • Notification Methods
  • Rules and Rule Sets


Notification Methods

A notification method represents a specific way to send notifications. Besides e-mail, there are three types of notification methods: OS Command, PL/SQL, SNMP Traps.


A rule instructs Enterprise Manager to take specific action when events or incidents (entity containing one important event or related events) occur, such as notifying an administrator or opening a helpdesk ticket.


Incident Manager

Enterprise Manager Cloud Control simplifies managing incidents through an intuitive UI called Incident Manager. Incident Manager provides and easy-to-use interface that allows you to search, view, manage, and resolve incidents and problems impacting your environment. To access Incident Manager, from the Enterprise menu, select Monitoring, and then Incident Manager.


Accessing Monitoring Information

Enterprise Manager provides multiple ways to access monitoring information. The primary focal point for incident management is the Incident Manager console, however Enterprise Manager also provides other ways to access monitoring information. The following figures show the various locations within Enterprise Manager that display target monitoring information. The following figure shows the Enterprise Manager Overview page that conveniently displays target status rollup and rollup of incidents.





Discovering, Promoting, and Monitoring

Enterprise Manager Cloud Control (Cloud Control) enables you to discover, promote, add, and then monitor software deployments across your network, using a single GUI-rich console.

What is Discovery?

Discovery refers to the process of identifying unmanaged hosts and targets in your environment. You can discover hosts and targets automatically or manually.



Autodiscovery Process

For discovery of a host, the autodiscovery process enables a Management Agent running on the host to run an Enterprise Manager job that scans for unmanaged hosts. You then convert these unmanaged hosts to managed hosts by deploying Management Agents on these hosts.


Guided Discovery Process

The guided discovery process enables you to explicitly add a specific database target as a target to bring under management. The discovery wizard guides you through the process and most of the specifications required are filled by default.

The benefits of using this process are as follows:

  • You can find targets with less effort.
  • You can find a new database that has been added recently even if autodiscovery has not been run.
  • You can find a non-promoted database that already exists in autodiscovery results, but has a change in details. For example, the port.
  • You eliminate unnecessary consumption of resources on the Management Agent when discovery is not needed.


Specifying Target Monitoring Properties

Specifying target monitoring properties enables you to manually specify all the details required to discover the database target, such as the host name and location, target name and location, and other specific information.


What is Promotion?

Promotion refers to the process of converting unmanaged hosts and targets, which have been discovered in your network, to managed hosts and targets in Cloud Control so that they can be monitored and managed efficiently. While conversion of unmanaged hosts to managed hosts involves deployment of a Management Agent on those hosts, conversion of unmanaged targets running on those hosts to managed targets involves only adding the targets as manageable entities in Cloud Control without deploying any additional component on the hosts.


What is Monitoring?

Monitoring refers to the process of gathering information and keeping track of activity, status, performance, and health of targets managed by Cloud Control on your host. A Management Agent deployed on the host in conjunction with plug-ins monitors every managed target on the host.


Hope this serve the purpose a bit..

Thanks & Regards

Nimai Karmakar







Read Full Post »

Coming soon ….

Hello friends ,

It’s been a long time that I have not done any posts in the blog… “Life was messed up… :(” . But I will be back with some Oracle Enterprise Manager cloud control 12c ( issues…

1. Basic concepts

2. Installation

3. Offline Up gradation of agents

4. Troubleshooting

Waiting for your precious response, what issue do you want… Please comment

Read Full Post »

Bitbach's Blog

Just another Oracle weblog @ WordPress

Daniel Westermann's Blog

simplicity...that's it

Oracle Application DBA

sharing the information about realtime experience

My Oracle Notes

Emiliano Fusaglia RAC DBA/Data Architect

Johribazaar's Blog

Just another WordPress.com weblog


Site for Ayurveda and Yoga articles


Few adventures in my slow running life...


4 out of 5 dentists recommend this WordPress.com site


Technical Articles by Kanchana Selvakumar

SAP Basis Cafe

SAP Basis Cafe - Exploring SAP R/3 Basis World