Regenerate Oracle VM Manager repository database

Ronnie Kalisingh
0 0
Read Time:1 Minute, 13 Second

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 Post Author

Ronnie Kalisingh

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).
Happy
Happy
0 %
Sad
Sad
0 %
Excited
Excited
0 %
Sleepy
Sleepy
0 %
Angry
Angry
0 %
Surprise
Surprise
0 %
Next Post

First steps with Docker Checkpoint - to create and restore snapshots of running containers

Docker Containers can be stopped and started again. Changes made to the file system in a running container will survive this deliberate stop and start cycle. Data in memory and running processes obviously do not. A container that crashes cannot just be restarted and will have a file system in […]
%d bloggers like this: