An Oracle blog about Oracle Enterprise Manager and Oracle Management Cloud

Moving A Repository To Another Machine

Moving the database

A Grid Control repository database, like any other database of an enterprise class piece of software, can over time 'out-grow' its original setup. And when that happens, there are only 2 choices: Only upgrade the hardware to make the box 'bigger', or move the database can potentially to another server.

As far as Grid Control is concerned, the repository database can be on any server (Just make sure the network latency between the OMS and the repository is kept to the absolute minimum!). Any method that moves a complete database from one machine to another can be used to migrate the repository, including a full exp/imp, an rman recovery, or even a full cold backup and restore on a different machine: As long as the complete database is migrated, any of the methods can be used.

When the new machines are running the same operating system on similar hardware, there are quite a few options available to move the database.

If the new machines are on a different platform (different Operating System), some limitations exists, and more planning will be needed for the move. The set of possibilities on what is possible and how is listed in this note on My Oracle Support:

388090.1: Cross Platform EM Grid Control Repository/OMS Migration

(Contact Oracle Support for a copy of this note)

After the move

Even though the OMS does not keep track, or does not keep information about the state and location of the repository, it does need to know where the database is so it can make connections on startup.

The connection details are stored in the emoms.properties file, located in the $ORACLE_HOME/sysman/config directory. When the location of the repository changes, the connect descriptor in that file will need to get updated.

Edit this parameter on every OMS of the infrastructure:

oracle.sysman.eml.mntr.emdRepConnectDescriptor=(DESCRIPTION\=(ADDRESS_LIST\=...rest of TNS descriptor...))

As soon as the change is made, start the Management Servers again to have them point to the new repository database:

$ emctl start oms

But there are two more things that need to happened when the database moves:

  1. The 'OMS And Repository' target needs to get re-pointed to the new database as well

    This target gets discovered automatically during the installation of the first OMS in the infrastructure. To update the monitoring configuration of this target, and make it point to the new repository database location, login to the console, go to the 'Management Services and Repository' page from the 'Setup' menu, and click on the 'Monitoring Configuration' link from the Related Links section at the bottom of the page. Once on that page update the TNS descriptor to point to the new repository database location, and save the changes.

  2. The new machines will need to get discovered in Grid Control

    Depending on what changes got made to the infrastructure, new Agents on the new machines need to get installed and added, together with the discovery of the new repository database.

    Always make sure the repository database is a managed target in Grid Control! The self-monitoring features of Grid Control use the monitoring data from the database.

Join the discussion

Comments ( 3 )
  • jcnars Tuesday, August 24, 2010
    We are in a situation where we need to create a new Grid Control environment. Is there a way we can just move the alerts from the old Grid Control (for a given database) to the new grid control repository?
  • Hugo Fotheringham Monday, August 30, 2010
    What a post!! Very informative and also easy to understand. Looking for more such writeups!! Do you have a twitter?
    I recommended it on stumbleupon. The only thing that it's missing is a bit of color. Nevertheless thank you for this information.
  • federal firearms license Monday, September 20, 2010
    I stumbled on this article on Google despite the fact that I was seeking something similar, but I just wanted to say excellent stuff and I absolutely agree. Is there any way to subscribe to fresh content?
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.