Reinstalling OEM 11g

• When reinstalling OEM 11g from any reasons don’t forget to clean up your environment from previous installation attempts.
• Clean up ORACLE_HOME directories on OMS server
• Get rid of EM stuff from EM managed database
• 
  
• The first issue I faced is the existence of SYSMAN schema. I ran the following command to drop it:

[oracle@host ~]$  $<ORACLE_HOME>/bin/emca -deconfig dbcontrol db -repos drop -SYS_PWD / 
<sys pasword> -SYSMAN_PWD <sysman password>

• Also drop “sysman_mds” schema and recompile invalid objects (if applicable) in DBSNMP and MGMT_VIEWschemas. Re-compile invalid objects using:

SQL> @$ORACLE_HOME/sysman/admin/emdrep/sql/core/latest/admin/admin_recompile_invalid.sql SYSMAN

• After the above script was executed you must check invalid objects:

SQL> select count(*) from dba_objects where status<>'INVALID';

• 
  
• If invalid objects still exists you must re-compile them: see http://dbataj.blogspot.com/2007/08/how-to-compile-invalid-objects.html
• 
  
• During the first install the MDS Schema Configuration inserts 1 line into table SCHEMA_VERSION_REGISTRY. When reinstalling OEM "MDS Schema Configuration" will fail.

• Don’t forget to delete that entry from SCHEMA_VERSION_REGISTRY table:

SQL> delete from SCHEMA_VERSION_REGISTRY where COMP_NAME='Metadata Services';

• Then retry and the "MDS Schema Configuration" will be configured successfully.

11g Grid Control - how to change the OMS Repository Database Listener Port or Hostname

In versions prioor to 11g Grid Control we had to update the emoms.properties file in case we needed to modify the Listener Port used to connect to the repository database. But in 11g OEM, it has been changed and we now have to use the emctl command.

There are a lot of other options added to the emctl command which can be seen via the emctl -help command.

To change the listener port or the hostname of the Repository Database we now have to use the emctl config oms command as shown below.

emctl config oms -store_repos_details -repos_port 1528 -repos_sid emrep -repos_host wintest01 -repos_user SYSMAN -repos_pwd oracle11g

To check what are the OMS Repository details we can use the emctl config oms -list_repos_details command.

For example –

D:\Oracle\Product\Middleware\oms11g\BIN>emctl config oms -list_repos_details

Oracle Enterprise Manager 11g Release 1 Grid Control
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.
Repository Connect Descriptor : (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=wintest01)(PORT=1528)))(CONNECT_DATA=(SID=emrep)))
Repository Host : wintest01
Repository Port : 1528
Repository SID : emrep
Repository User : SYSMAN

The emoms.properties file actually has these lines ….

###########################################################################################################
##################################### README ###########################################
###########################################################################################################

#NOTE
#—-
#1. EMOMS(LOGGING).PROPERTIES FILE HAS BEEN REMOVED

#2. OMS PROPERTIES / LOGGING PROPERTIES SHOULD BE MODIFIED USING EMCTL GET/SET/DELETE/LIST PROPERTY COMMANDS

#3. The USAGE OF EMCTL GET/SET/DELETE/LIST PROPERTY IS PROVIDED BELOW, BUT
# FOR LATEST UPDATED COMMANDS PLEASE CHECK EMCTL HELP MESSAGE

Source: http://gavinsoorma.com/2010/10/11g-grid-control-how-to-change-the-oms-repository-database-listener-port-or-hostname/