Oracle Enterprise Manager 10g Grid Control Release 2 10.2.0.1.1 Installation On Red Hat Enterprise Linux 5.3

In the name of God, Most Gracious, Most Merciful.

In this article I will describe the installation of Oracle Enterprise Manager 10g Grid Control Release 2 10.2.0.1.1 installation On Red Hat Enterprise Linux 5.3. Before any proceedings with installation make sure that C library RPMs are installed.

Oracle Enterprise Manager 10g Grid Control Release 2 10.2.0.1.1 has four main components

1. Enterprise Manager
2. Management Service
3. Management Repository
4. Management Agent

In this article i am using already installed Oracle Database 10g Release 2 10.2.0.1.0 as Management Repository and its guide is available here. You can first install Management Repository Database by using this guide or if you are planning to use already installed database on some other machine then you can make user accounts and kernel parameters from the mentioned guide if required.

Prerequisites

1. Make Sure that database control is de-configured from Management Repository Database.
2. Parameter session_cached_cursors must be greater then or equal to 200.
3. Package DBMS_SHARED_POOL should be executed on Management Repository Database.
4. Grant execute on UTL_FILE to public.

Make Sure that database control is de-configured from Management Repository Database.
execute following script by "oracle" user

cd $ORACLE_HOME/bin

emca -deconfig dbcontrol db -repos drop

Figure - 1

if you haven't de-configured database control then you will receive following error during installation.

Figure -2

Check/Change session_cached_cursors parameter by executing following script.

sqlplus / as sysdba

show parameter session_cached_cursors

if value < 200 then execute following script

create pfile from spfile;

alter system set session_cached_cursors=200 scope=spfile;

shutdown immediate;

startup;


These steps are shown in following figure.

Figure - 3

Package DBMS_SHARED_POOL should be executed. You can check it by executing following query.

select count(*) from dba_objects

where object_name = 'DBMS_SHARED_POOL'

and object_type in ('PACKAGE', 'PACKAGE BODY');

Verify that its result is 2 otherwise execute following script.

@<ORACLE_HOME>/rdbms/admin/dbmspool.sql


This steps are shown in following figure.

Figure - 4

Execute following script.

Grant execute on UTL_FILE to public;

 


Installation


Now make directories for Enterprise Manager Installation and change ownership of these directories to “oracle” user by running following script.

mkdir –p /u01/oracle/product/10.2.0/grid

chown –R oracle:oinstall /u01

Figure - 5

Add following oracle variables in /home/oracle/.bash_profile by switching to oracle user.

export ORACLE_BASE=/u01/oracle

export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/grid

Figure - 6

make these changes permanent by executing following script.

cd ~

. ./.bash_profile

Figure - 7

Copy setup files to /u01/gc_102011_linux

Start Oracle Database installation by running following command

/u01/gc_102011_linux/runInstaller

Select "Enterprise Manager 10g Grid Control Using an Existing Database" radio button and then click Next button on following screen.

Figure - 8

Provide parent directory patch for Oracle Management Server and Agent Homes as shown in screen below.

Figure - 9

Installation starts.

Figure - 10

Make sure that overall result is passed in following screen. If not then make sure that required packages, parameters and Prerequisites are executed correctly. Click Next On following screen.

Figure - 11

Provide Management Repository Database Information in following screen and click Next.

Figure - 12

When you click Next following Warning message will appear click Continue on it.

Figure - 13

Click Next on following screen.

Figure - 14

Enter password information on following screen and click Next.

Figure - 15

Review information on following screen and click Install.

Figure - 16

View progress.

Figure - 17

View progress.

Figure - 18

You will receive following warning message during installation.

Figure - 19

This warning is due to missing library libdb.so.2 which is required to start Oracle HTTP Server. You need to download patch p6078836_101330_Linuxx86.zip containing libdb.so.2 library. Copy this library to /usr/lib/ directory. After this execute following script with oracle user and then click "Continue" on the warning message.

cd $ORACLE_HOME/oms10g/opmn/bin

./opmnctl stopall

./opmnctl startall

View progress.

Figure - 20

View progress.

Figure - 21

Start a Terminal, change user to “root” by using “su – root” command and execute following script.

mkdir -p /usr/local/bin/grid

mkdir -p /usr/local/bin/agent

copy Script Location from following screen to Terminal. Press enter and provide directory location for grid and agent as above.

Figure - 22

View progress

Figure - 23

View progress.

Figure - 24

View progress.

Figure - 25

Open browser and paste the URL of “Enterprise Manager 10g Grid Control URL:” to browser. Provide “sysman” as username and its password and click login.

Figure - 26

Insha-Allah this will help and serve the purpose. For any corrections and improvements please suggest.