Category Archives: Virtual Servers

Fix database errors in Oracle VM Manager 3.2.1

Steps to fix database errors  in Oracle VM Manager 3.2.1

Step 1: Run fixup from ovm_upgrades.sh
1. Go to directory
     #cd /u01/app/oracle/ovm-manager-3/bin

2. Run follow command:

     #./ovm_upgrade.sh –fixup –dbuser=ovs –dbpass=Y3502K1rWO –dbhost=localhost –dbsid=ovm –dbport=1522
3. If errors show
Using existing transform XSL files
Copying deleted classes files to patch path location
2013-05-15 22:49:45,767  INFO Oracle OVM Manager Upgrade Processor
2013-05-15 22:49:45,768  INFO
2013-05-15 22:49:45,769  INFO Upgrade Initialization Starting
2013-05-15 22:49:46,088  INFO Oracle Distributed Object Fabric (ODOF): Copyright (C) 2007, 2012 Oracle.  All rights reserved.
2013-05-15 22:49:46,088  INFO ODOF Version: 1.0.0.0
2013-05-15 22:49:46,088  INFO Initializing…
2013-05-15 22:49:46,822  INFO Initialization Complete!
2013-05-15 22:49:46,822  INFO Upgrade Initialization Complete
2013-05-15 22:49:46,822  INFO Database Fixup starting
2013-05-15 22:49:47,004  INFO Fixing up Exchange… (10461 objects)
2013-05-15 22:49:50,758 ERROR ObjectNotFoundException: ONF reference to object 117:, from object 116:
2013-05-15 22:49:50,758 ERROR Fixup cannot fix Foundry stale reference in Event Log!
2013-05-15 22:49:50,758 ERROR Please run Foundry.recreateMembers() in a running Manager to fix this problem.
2013-05-15 22:49:50,915  INFO Committing fixup changed object 116:

2013-05-15 22:49:52,067  INFO Fixup has processed 1000 of 10461 objects
2013-05-15 22:49:53,648  INFO Fixup has processed 2000 of 10461 objects
2013-05-15 22:49:55,518  INFO Fixup has processed 3000 of 10461 objects
2013-05-15 22:49:56,798  INFO Fixup has processed 4000 of 10461 objects
2013-05-15 22:49:57,749  INFO Fixup has processed 5000 of 10461 objects
2013-05-15 22:49:59,205  INFO Fixup has processed 6000 of 10461 objects
2013-05-15 22:50:00,174  INFO Fixup has processed 7000 of 10461 objects
2013-05-15 22:50:01,007  INFO Fixup has processed 8000 of 10461 objects
2013-05-15 22:50:01,856  INFO Fixup has processed 9000 of 10461 objects
2013-05-15 22:50:02,474  INFO Fixup has processed 10000 of 10461 objects
2013-05-15 22:50:02,708  INFO Fixup Complete! 1 objects were updated
2013-05-15 22:50:02,708  INFO Database Fixup completed in 15.88 sec

Step 2. Fix database using ovm_upgrade.sh
1. Export database to XML
     # ./ovm_upgrade.sh –export –dbuser=ovs –dbpass=Y3502K1rWO –dbhost=localhost –dbsid=ovm –dbport=1522
2. Delete database
     # ./ovm_upgrade.sh –deletedb –dbuser=ovs –dbpass=Y3502K1rWO –dbhost=localhost –dbsid=ovm –dbport=1522
3. start OVM Manager with blank database.
#service ovmm start
4. Shutdown OVM Manager
#service ovmm stop
3. Import database
      #./ovm_upgrade.sh –import –dbuser=ovs –dbpass=Y3502K1rWO –dbhost=localhost –dbsid=ovm –dbport=1522
4. Restart OVM Server.
5. Enjoy.