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/