Is there an easy way to install Oracles Enterprise Manager Grid Control?

By kevaburg ·
We have a relatively large infrastructure consisting of over 90 Oracle 10g databases located all over the country. To ease management woes we intend to use Oracles Enterprise Manager Grid Control 10g to administer the machines.

Each 10g database is hosted on a fully patched Windows 2003 R2 x86 server machine (the databases are not big but mission-critical). Management occurs via secure remote desktop connections from our HQ to each remote location. I install the software using a pseudo admin account on a server attached to the network that uses (as expected) group policy. Maybe group policy settings have an effect on how this can be installed?

In theory, the installation is easy. We opted to install the database software first and then create our management repository database called "emrep" as the second step.

Installing the grid control itself is where the problems start.

ORACLE_BASE and ORACLE_HOME are located on the system drive with the database data itself hosted on a seperate fault-tolerant volume. There is no RAC and no other instances running. It is simply a one instance-one box affair.

I'll talk through the installation as I have done it up until now.

The Database Software

The software has been installed as I described above, without a starter database, no email or updates support (they are handled another way) and all prerequisite checks run through and show no errors. The software shows no installation errors on completion.

The Database

DBCA is used to configure a new database. It is configured as a general purpose database called "emrep" (for Enterprise Manager REPository) with a similar SID. The EM itself is configured along with the database control. I appreciate that DBControl needs to be deactivated to successfully in grid control, but I had to leave it activated to get as far as I did.

The database is stored in the file-system in a common, fault-tolerant storage area, a flash-recovery-area is installed in the same area and ARCHIVELOGMODE is activated, a necessity for the software accessing the db itself.

There is no example schema installed and no additional scripts. AMM is used for memory management.

Default values are assigned for the remainder of the database installation.

Installation of the Grid Control

As at the time of writing, grid control is currently at v5, but in order to reach v5, v2 must first be installed and then patched to meet v5 levels.

At the first stage, I select to install grid control with an existing database.

A home directory is given as c:\OracleHomes and I accept this as given. All of the prerequisite tests pass without problem

The configuration of the repository database, emrep, occurs using port 1521, with management and data tablespaces using default values-.

DBControl is disabled at this point, without stopping the installation process using the command:

%oracle_home%/bin/emca -deconfig dbcontrol db -repos drop

This throws no errors.

The parameter for SESSION_CACHED_CURSORS is changed to the minimum value of 200 using:

alter system set session_cached_cursors = 200 scope = spfile;

The database has to be restarted and once done, setup resumes from where it was. No problems up until now.

Passwords are given and the installation begins.

Everything runs well until we get the the configuration of the OMS where the installation fails. References to the creation of the REPOS owner are made with failures recorded in every instance.

On one occasion I managed to get the installation past this point and now the management agent won't install!! And I can't explain why.

Is it really the case that the software is so hard to install or have I forgotten something/need to do something before the installation can proceed?

I need some help with this desperately and if anyone has managed to do this successfully then I would be grateful for ever!!!

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Oracle Enteprise Manager Installation

by jimmy_hukom In reply to Is there an easy way to i ...

The installation of Oracle Enterprise Manager or OEM for short, at first, can be be intimidating. But with patience and a little bit of resourcefulness, it is very easy. As easy as installing Windows XP. All you need is a Full Installer version of OEM (ex. -, and the corresponding Installation Guide. Of course, you will have to read and digest the installation guide, which may seem more difficult than that actual installation itself. And lastly, the secret to any Oracle Installatiion is in the preparation. I hope this little bit of advice helps.

Related Discussions

Related Forums