Regenerate Oracle VM Manager repository database

0

Some quick notes to regenerate a corrupted Oracle VM manager repository database.

How did we discover the corruption?
The MySQL repository databases was increasing in size, the file “OVM_STATISTIC.ibd” was 62G. We also found the following error messages in the “AdminServer.log” logfile:

####<2018-02-13T07:52:17.339+0100> <Error> <com.oracle.ovm.mgr.task.ArchiveTask> <ovmm003.gemeente.local> <AdminServer> <Scheduled Tasks-12> <<anonymous>> <> <e000c2cc-e7fe-4225-949d-25d2cdf0b472-00000004> <1518504737339> <BEA-000000> <Archive task exception:
com.oracle.odof.exception.ObjectNotFoundException: No such object (level 1), cluster is null: <9208>

Regenerate steps
– Stop the OVM services
restore_db_1

– Delete the Oracle VM Manager repository database
restore_db_2

“/u01/app/oracle/ovm-manager-3/ovm_upgrade/bin/ovm_upgrade.sh –deletedb –dbuser=ovs –dbpass=<PASSWORD> –dbhost=localhost –dbport=49500 –dbsid=ovs”

restore_db_3

– Generate replacement certificate
restore_db_4

– Start the OVM services and generate new certificates
restore_db_5

– Restart OVM services
restore_db_6

– Repopulate the database by discovering the Oracle VM Servers
restore_db_7.png

– Restore simple names
Copy the restoreSimpleName script to /tmp, see Oracle Support note: 2129616.1
restore_db_8

Resources
[OVM] Issues with huge OVM_STATISTIC.ibd used as OVM_STATISTIC Table. (Doc ID 2216441.1)
Oracle VM: How To Regenerate The OVM 3.3.x/3.4.x DB (Doc ID 2038168.1)
Restore OVM Manager “Simple Names” After a Rebuild/Reinstall (Doc ID 2129616.1)

About Author

Ronnie is an Oracle consultant at AMIS. He is specialized in Oracle database (Data Guard, RAC, ASM, RMAN, SQL, PL/SQL) and has experience with EM Cloud Control, Oracle VM Server, Oracle Failsafe, Oracle Fusion Middleware, Oracle/Red Hat Linux, ODA (bare metal/virtualized).

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.