Guenadi N Jilevski's Oracle BLOG

Oracle RAC, DG, EBS, DR and HA DBA BLOG

Installing Oracle Enterprise Manager Grid Control 10.2.0.2 on Windows

Installing Oracle Enterprise Manager Grid Control 10.2.0.2 on Windows

Here in the article we will look at install Oracle EM GC using an existing database.

  1. Make sure that the database selected does not have EM DB console installed. If it is installed drop the setup.
  2. Run the following script in a script against the new OMR database prior to the running OUI for installing Oracle EM GC.

    drop user sysman cascade;

    drop public synonym MGMT_ADMIN;

    drop public synonym MGMT_AS_ECM_UTIL;

    drop public synonym MGMT_AVAILABILITY;

    drop public synonym MGMT_COLLECTION_PROPERTIES;

    drop public synonym MGMT_CREDENTIAL;

    drop public synonym MGMT_CURRENT_AVAILABILITY;

    drop public synonym MGMT_CURRENT_METRICS;

    drop public synonym MGMT_CURRENT_METRIC_ERRORS;

    drop public synonym MGMT_CURRENT_SEVERITY;

    drop public synonym MGMT_DELTA;

    drop public synonym MGMT_DELTA_ENTRY;

    drop public synonym MGMT_DELTA_ENTRY_VALUES;

    drop public synonym MGMT_DELTA_IDS;

    drop public synonym MGMT_DELTA_ID_VALUES;

    drop public synonym MGMT_DELTA_VALUE;

    drop public synonym MGMT_DELTA_VALUES;

    drop public synonym MGMT_GLOBAL;

    drop public synonym MGMT_GUID_ARRAY;

    drop public synonym MGMT_GUID_OBJ;

    drop public synonym MGMT_IP_TGT_GUID_ARRAY;

    drop public synonym MGMT_JOB;

    drop public synonym MGMT_JOBS;

    drop public synonym MGMT_JOB_EXECPLAN;

    drop public synonym MGMT_JOB_EXECUTION;

    drop public synonym MGMT_JOB_EXEC_SUMMARY;

    drop public synonym MGMT_JOB_OUTPUT;

    drop public synonym MGMT_JOB_PARAMETER;

    drop public synonym MGMT_JOB_SCHEDULE;

    drop public synonym MGMT_JOB_TARGET;

    drop public synonym MGMT_LOG;

    drop public synonym MGMT_LONG_TEXT;

    drop public synonym MGMT_MESSAGES;

    drop public synonym MGMT_METRICS;

    drop public synonym MGMT_METRICS_1DAY;

    drop public synonym MGMT_METRICS_1HOUR;

    drop public synonym MGMT_METRICS_COMPOSITE_KEYS;

    drop public synonym MGMT_METRICS_RAW;

    drop public synonym MGMT_METRIC_COLLECTIONS;

    drop public synonym MGMT_METRIC_ERRORS;

    drop public synonym MGMT_METRIC_THRESHOLDS;

    drop public synonym MGMT_NAME_VALUE;

    drop public synonym MGMT_NAME_VALUES;

    drop public synonym MGMT_PREFERENCES;

    drop public synonym MGMT_SEVERITY;

    drop public synonym MGMT_SEVERITY_ARRAY;

    drop public synonym MGMT_SEVERITY_OBJ;

    drop public synonym MGMT_STRING_METRIC_HISTORY;

    drop public synonym MGMT_TARGET;

    drop public synonym MGMT_TARGETS;

    drop public synonym MGMT_TARGET_BLACKOUTS;

    drop public synonym MGMT_TARGET_MEMBERSHIPS;

    drop public synonym MGMT_TARGET_PROPERTIES;

    drop public synonym MGMT_TYPE_PROPERTIES;

    drop public synonym MGMT_USER;

    drop public synonym MGMT_VIEW_UTIL;

    drop public synonym MGMT$DELTA_ORACLE_HOME;

    drop public synonym MGMT$DELTA_OS_COMPONENTS;

    drop public synonym MGMT$DELTA_OS_COMP_DETAILS;

    drop public synonym MGMT$DELTA_OS_KERNEL_PARAMS;

    drop public synonym MGMT$DELTA_PATCHSETS;

    drop public synonym MGMT$DELTA_PATCHSET_DETAILS;

    drop public synonym MGMT$DELTA_TABLESPACES;

    drop public synonym MGMT$DELTA_VENDOR_SW;

    drop public synonym MGMT$DELTA_VIEW;

    drop public synonym MGMT$DELTA_VIEW_DETAILS;

    drop public synonym MGMT$ECM_CURRENT_SNAPSHOTS;

    drop public synonym MGMT$ECM_VISIBLE_SNAPSHOTS;

    drop public synonym MGMT$GROUP_DERIVED_MEMBERSHIPS;

    drop public synonym MGMT$GROUP_FLAT_MEMBERSHIPS;

    drop public synonym MGMT$GROUP_MEMBERS;

    drop public synonym MGMT$HA_BACKUP;

    drop public synonym MGMT$HA_FILES;

    drop public synonym MGMT$HA_INFO;

    drop public synonym MGMT$HA_INIT_PARAMS;

    drop public synonym MGMT$HA_MTTR;

    drop public synonym MGMT$HA_RMAN_CONFIG;

    drop public synonym MGMT$HW_NIC;

    drop public synonym MGMT$METRIC_COLLECTION;

    drop public synonym MGMT$METRIC_CURRENT;

    drop public synonym MGMT$METRIC_DAILY;

    drop public synonym MGMT$METRIC_DETAILS;

    drop public synonym MGMT$METRIC_HOURLY;

    drop public synonym MGMT$MISSING_TARGETS;

    drop public synonym MGMT$MISSING_TARGETS_IN_GROUPS;

    drop public synonym MGMT$OS_COMPONENTS;

    drop public synonym MGMT$OS_FS_MOUNT;

    drop public synonym MGMT$OS_HW_SUMMARY;

    drop public synonym MGMT$OS_KERNEL_PARAMS;

    drop public synonym MGMT$OS_PATCHES;

    drop public synonym MGMT$OS_SUMMARY;

    drop public synonym MGMT$SOFTWARE_COMPONENTS;

    drop public synonym MGMT$SOFTWARE_COMPONENT_ONEOFF;

    drop public synonym MGMT$SOFTWARE_COMP_PATCHSET;

    drop public synonym MGMT$SOFTWARE_DEPENDENCIES;

    drop public synonym MGMT$SOFTWARE_HOMES;

    drop public synonym MGMT$SOFTWARE_ONEOFF_PATCHES;

    drop public synonym MGMT$SOFTWARE_OTHERS;

    drop public synonym MGMT$SOFTWARE_PATCHES_IN_HOMES;

    drop public synonym MGMT$SOFTWARE_PATCHSETS;

    drop public synonym MGMT$TARGET;

    drop public synonym MGMT$TARGET_COMPONENTS;

    drop public synonym MGMT$TARGET_COMPOSITE;

    drop public synonym MGMT$TARGET_PROPERTIES;

    drop public synonym MGMT$TARGET_TYPE;

    drop PUBLIC SYNONYM SMP_EMD_AVAIL_OBJ;

    drop public synonym EMD_MNTR;

    drop public synonym SMP_EMD_AVAIL_OBJ;

    drop public synonym SMP_EMD_DELETE_REC_ARRAY;

    drop public synonym SMP_EMD_INTEGER_ARRAY;

    drop public synonym SMP_EMD_INTEGER_ARRAY_ARRAY;

    drop public synonym SMP_EMD_NVPAIR;

    drop public synonym SMP_EMD_NVPAIR_ARRAY;

    drop public synonym SMP_EMD_STRING_ARRAY;

    drop public synonym SMP_EMD_STRING_ARRAY_ARRAY;

    drop public synonym SMP_EMD_TARGET_OBJ;

    drop public synonym SMP_EMD_TARGET_OBJ_ARRAY;

    drop public synonym ECM_UTIL;

    drop role mgmt_user;

    drop public synonym SETEMVIEWUSERCONTEXT;

Run OUI and specify installation type as follows. Select Enterprise Manager 10g Grid Control Using an Existing Database. Press Next to continue.

Specify the location e:\OracleHomes and press Next to continue.

The windows appear for a while to inform you that a preparation for install takes place.

Wait until the OUI completes all the of the prerequisites checks. Make sure that there are no errors. After you make sure that there are no errors press Next to continue.

The Screen ‘Specify Repository Database Configuration appears’ after entering the details for the target OMR database I was prompted to:

  1. /rdbms/admin/dbmspool.sql
  2. Session_cached_cursors=300

After successfully implementation of the suggested OMR database reconfiguration press Next to continue.

Enter the details for connection to Metalink as in the case. For the rest specify details that fit for purpose in your case. Press Next to continue.

Specify the password and press Next to continue.

The summary screen appears. Examine the components and make sure that resources on disk are sufficient. Press Install to start the installation.

The next screen shows the progress of the installation. Wait for until completion.

After completion of the installation the Configuration Assistants screen appears. Monitor the progress of the Oracle EM configuration.

The next screen will show a failure. This is known windows bug related to the DST in different time zones. Leave the window and apply patch 5872134 as per Note
419700.1 from a separate session.

In order to continue with successful completion of the Agent Configuration Assistant apply patch 5872134 as per Note
419700.1

Leaving the installer with the “Retry” option available, download the DST agent patch 5872134 for the Windows platform affected and agent version 10.2.0.2.0 and apply to the …\agent10g\ Oracle Home.

When patch application has completed, click the “Retry” button on the primary installer to complete the installation and observe successful agent startup.

Note that the …\oms10g\ and …\db10g\ Oracle Homes will still need be patched for DST according to 409225.1.

NOTE:<<409225.1>> – Impact of 2007 DST changes on Grid Control Release 2 – Preparation and Patching guidelines

Get the information for logging in to the Oracle Enterprise Manager Grid Control and press exit to finish the installation.

See below for information pertaining to your Enterprise Manager Installation:

1. Use the following URL to access the Enterprise Manager Grid Control:

https://userpc.gj.com:1159/em

2. The Enterprise Manager installation includes an Oracle Application Server instance, which is administered using a special “ias_admin” user account. The following information was defaulted for the embedded Application Server instance:

Instance Name: EnterpriseManager0.userpc.gj.com

ias_admin password: This password is the same the SYSMAN account.

3. The connection details for the Enterprise Manager Repository are:

Host: userpc.gj.com

Port: 1521

SID: DB10g

4. The Enterprise Manager Release Notes are located at:

E:\OracleHomes\agent10g\relnotes\README_EM.htm

After login to the Oracle Enterprise Manager Grid Control site we have as below.

This we have successfully installed Oracle Enterprise Manager 10.2.0.2 on windows. Stay tuned for the upgrade to 10.2.0.5.

February 24, 2010 Posted by | oracle | 7 Comments