Change Repository DB Connection in EM 13c

Sometimes it’s hard to find what you’re looking for in the Oracle documentation or on MOS if you don’t already know what exactly to search for. This happened to me while trying to find out  how the method of changing the DB connection for the EM repository changed in 13c. So I thought my findings are worth sharing.

In earlier releases of Enterprise Manager (Grid Control or Cloud Control), connection settings were stored in a file named “emoms.properties”. While this file still existed on the EM 13.2 environment I was working on, there wasn’t any connection string in it.

After searching for quite a while (sifting a wealth of outdated documents), I found out there’s a specific emctl command to set the DB connection. This command already exists since 11g where it had to be used when the repository DB was put in a RAC. Now it seems to be the only way to change the connect string, be it RAC or single instance.

Here’s an example of configuring a connect string to a RAC DB using a SCAN listener:

emctl stop oms
emctl config oms -store_repos_details -repos_user sysman -repos_conndesc \
 "'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=oracls-scan.example.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=emrep)))'"
emctl start oms

Mind the double quotes around the connect string.

Double-Check

To ensure that the connect descriptor has been updated, check

  • all XML files under “../gc_inst/user_projects/domains/GCDomain/config/jdbc
  • jps-config.xml, jps-config-jse.xml and embi-policystoremerge-jpscfg.xml under “../gc_inst/user_projects/domains/GCDomain/config/fmwconfig”

Post-Config Actions

Update the “OMS And Repository” target (“Setup” – “Management Services and Repository” – “Monitoring Configuration”) to point to the relocated DB.

If you moved your repository DB to a new server, make sure to discover the server in EM.

References

  1. OEM 13.2 Docs: EMCTL Commands for OMS
  2. Oracle Blogs: Moving A Repository To Another Machine
  3. Unable To Start 13c OMS After Repository Database Switchover (Doc ID 2214218.1)
  4. How to configure the OMS 10g and 11g Connect Descriptor when RAC database is used as Repository (Doc ID 457854.1)
Advertisements

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