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 »

  1. Thanks for the info but I am still having very real problems with my GC installation. I’m using a Windows 2008 R1 environment and have tried getting an existing 10g database attached to an installation of grid control 10g and no matter what I do, it keeps failing at the OMS configuration! No amount of aspirin is making this headache disappear! Help!!!

    Comment by Kev Burgess | October 18, 2010 | Reply

    • Hi Kev,

      What is the error ? Did you check the prerequsites for the database?

      Regards,

      Comment by gjilevski | October 19, 2010 | Reply

  2. The error message is as simple as “OMS Repository Creation Failed”. All of the prerequisites have been met (including setting system parameters and running dbmspool.sql), running the deconfig of dbcontrol and ensuring that the sysman schema (using the script you used above) has been removed along with the associated management views.

    I am now working on the premise that maybe nls_lang is a cause for the problem (others seem to have the same issue) and as a result am in the process of changing the character set. I use a german language server and nls_lang always seems to default to america_american which Oracle seems to object to.

    I would be grateful to hear your thoughts and I will certainly share my results as I get them.

    Many thanks,

    Kev

    Comment by Kev Burgess | October 19, 2010 | Reply

    • Hi,

      I would look at the logs to identify the error for the OMS to fail. Can you post the error(s) in the logs?

      What is the character set that you are using?

      Look here as well

      http://www.oracle.com/technetwork/oem/grid-control/downloads/gridr5-10205-readme-097309.html

      Look at MOS

      OMS CA: Repository Creation Fails with ORA-12152: TNS:unable to send break message [ID 376934.1]
      Repository Creation Fails with ORA-28000 Installing 10.2.0.2 Grid Control [ID 405923.1]
      Problem: OMS CA: Grid Control 10.2.0.1.0 Install Fails during Repository Creation: ORA-01429 [ID 436177.1]
      Grid Control 10.2.0.1.0 Install Fails During Repository Creation with ORA-04020 [ID 457358.1]
      Installing 10.2.0.5 GC using existing 11g DB, Encounter Problem While Executing Configuregc.pl With Error “oracle.sysman.top.oms:configureOmsService:Failed to Secure OMS=Error processing emkey” [ID 863407.1]

      Lets me know how it goes.

      Regards,

      Comment by gjilevski | October 20, 2010 | Reply

  3. Hi Guenadi

    Instead of dropping the repository and objects manually we can do the following

    emca -deconfig dbcontrol db -repos drop

    This will remove the database control. And we are ready to install Grid Control.

    Comment by Manoj | August 4, 2011 | Reply

    • Hi Manoj,

      For sure you can drop an OEM DC repository using
      emca -deconfig dbcontrol db -repos drop

      From what I can remmeber it was particularly sensitive to all synonyms so I spent time to drop all of them. Only after synonyms were dropped the OEM GC suceeded.

      Regards,

      Comment by gjilevski | August 4, 2011 | Reply

  4. Awesome website you have here but I was curious if you knew of any discussion boards that cover the same topics discussed in this article?
    I’d really love to be a part of online community where I can get feed-back from other experienced individuals that share the same interest.
    If you have any recommendations, please let me know. Cheers!

    Comment by move to hawaii with nothing | July 11, 2014 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: