If you are planning to move your OMS repository database from the existing host to a new host, then follow below easy steps.

In the below example we will migrate the repository database from host01.dbaclass.com to host02.dbaclass.com

PRE-REQUISITES:

1. Agent need to be deployed on the new host 

2. Same version of ORACLE rdbms binary need to be installed on target( same as that of source)

EXAMPLE:

1. Check the OMS repository configuration:[ on OLD HOST]

 

 

2. Stop the OMS [ on OLD HOST ] 

 

3. Clone the database to new host

We have used rman active cloning for cloning the database.

Refer the link for complete steps – https://dbaclass.com/article/rman-active-cloning-in-oracle-12c/

Else other cloning methods like hot backup or cold backup method can be used.

4. Now update the OMS repository configuration with new connection string

 

 

5. Shutdown the database [ on OLD HOST]

6. Restart the OMS  

useful metalinks

Oracle Bug 23074675 : EM 13c – Unable to start oms after switchover of EM Repos DB

Unable To Start 13c OMS After Repository Database Switchover (Doc ID 2214218.1)