Difference between revisions of "OVM Install from the Start"

From PeformIQ Upgrade
Jump to navigation Jump to search
(Created page with 'Got stuck last time with no IPs allocated to the VMs and could not boot them So have just dropped the OVM tables and done a restore of the DB taken just after the last installat...')
 
Line 1: Line 1:
=Intro=
Got stuck last time with no IPs allocated to the VMs and could not boot them
Got stuck last time with no IPs allocated to the VMs and could not boot them
=Drop Old Tables=
<pre>
DROP TABLE "MGR_ABCSTORE";
DROP TABLE "MGR_ACCESSMANAGER";
DROP TABLE "MGR_ACTIONENGINEPROPERTIES";
DROP TABLE "MGR_ACTIONMANAGER";
DROP TABLE "MGR_ARCHIVEMANAGER";
DROP TABLE "MGR_BACKUPMANAGER";
DROP TABLE "MGR_BUSINESSMANAGER";
DROP TABLE "MGR_COHERENCE";
DROP TABLE "MGR_DISCOVERENGINEPROPERTIES";
DROP TABLE "MGR_DISCOVERMANAGER";
DROP TABLE "MGR_EVENTENGINEPROPERTIES";
DROP TABLE "MGR_EVENTLOG";
DROP TABLE "MGR_EVENTMANAGER";
DROP TABLE "MGR_FILEMANAGER";
DROP TABLE "MGR_FOUNDRY";
DROP TABLE "MGR_HASHMAP";
DROP TABLE "MGR_INFORMATIONALEVENT";
DROP TABLE "MGR_INTERNALSYSTEMLOG";
DROP TABLE "MGR_LINKEDLIST";
DROP TABLE "MGR_LOGENGINEPROPERTIES";
DROP TABLE "MGR_LOGMANAGER";
DROP TABLE "MGR_LOGSTORE";
DROP TABLE "MGR_MODELENGINEPROPERTIES";
DROP TABLE "MGR_MODELMANAGER";
DROP TABLE "MGR_OBJECTCHANGEEVENT";
DROP TABLE "MGR_PROPERTIES";
DROP TABLE "MGR_RASENGINEPROPERTIES";
DROP TABLE "MGR_RASMANAGER";
DROP TABLE "MGR_RESTOREMANAGER";
DROP TABLE "MGR_ROLESERVICE";
DROP TABLE "MGR_ROOTSTATISTICLOG";
DROP TABLE "MGR_RULESENGINEPROPERTIES";
DROP TABLE "MGR_RULESMANAGER";
DROP TABLE "MGR_SCHEDULABLETASKPROPERTIES";
DROP TABLE "MGR_SERVERNOTIFICATION";
DROP TABLE "MGR_SERVERYUMREPOSITORYINFORMA";
DROP TABLE "MGR_STATISTICMANAGER";
DROP TABLE "MGR_TASKENGINEPROPERTIES";
DROP TABLE "MGR_TASKMANAGER";
DROP TABLE "MGR_TREESTORE";
DROP TABLE "MGR_USERACCOUNT";
DROP TABLE "MGR_USERSTORE";
DROP TABLE "MGR_VNICMANAGER";
DROP TABLE "MGR_VNICMANAGERPROPERTIES";
DROP TABLE "ODOF_ID_TO_TYPE";
DROP TABLE "ODOF_NOT_TABLED";
DROP TABLE "ODOF_SYS_PROPERTIES";
DROP TABLE "ODOF_TYPE_TO_CLASS";
</pre>
Now restore the database:
$ imp ovs/xxxx file=/var/ovm/ovs_20110922_201611.dmp full=y


So have just dropped the OVM tables and done a restore of the DB taken just after the last installation.  Restarted the ovmm service
So have just dropped the OVM tables and done a restore of the DB taken just after the last installation.  Restarted the ovmm service
Line 7: Line 68:
and a few minutes later the application was available again.
and a few minutes later the application was available again.


I will now rebuild the vmserver and see where that leads...


 
=
[[Category:Oracle]]
[[Category:Oracle]]
[[Category:OVM]]
[[Category:OVM]]

Revision as of 12:58, 24 September 2011

Intro

Got stuck last time with no IPs allocated to the VMs and could not boot them

Drop Old Tables

DROP TABLE "MGR_ABCSTORE";
DROP TABLE "MGR_ACCESSMANAGER";
DROP TABLE "MGR_ACTIONENGINEPROPERTIES";
DROP TABLE "MGR_ACTIONMANAGER";
DROP TABLE "MGR_ARCHIVEMANAGER";
DROP TABLE "MGR_BACKUPMANAGER";
DROP TABLE "MGR_BUSINESSMANAGER";
DROP TABLE "MGR_COHERENCE";
DROP TABLE "MGR_DISCOVERENGINEPROPERTIES";
DROP TABLE "MGR_DISCOVERMANAGER";
DROP TABLE "MGR_EVENTENGINEPROPERTIES";
DROP TABLE "MGR_EVENTLOG";
DROP TABLE "MGR_EVENTMANAGER";
DROP TABLE "MGR_FILEMANAGER";
DROP TABLE "MGR_FOUNDRY";
DROP TABLE "MGR_HASHMAP";
DROP TABLE "MGR_INFORMATIONALEVENT";
DROP TABLE "MGR_INTERNALSYSTEMLOG";
DROP TABLE "MGR_LINKEDLIST";
DROP TABLE "MGR_LOGENGINEPROPERTIES";
DROP TABLE "MGR_LOGMANAGER";
DROP TABLE "MGR_LOGSTORE";
DROP TABLE "MGR_MODELENGINEPROPERTIES";
DROP TABLE "MGR_MODELMANAGER";
DROP TABLE "MGR_OBJECTCHANGEEVENT";
DROP TABLE "MGR_PROPERTIES";
DROP TABLE "MGR_RASENGINEPROPERTIES";
DROP TABLE "MGR_RASMANAGER";
DROP TABLE "MGR_RESTOREMANAGER";
DROP TABLE "MGR_ROLESERVICE";
DROP TABLE "MGR_ROOTSTATISTICLOG";
DROP TABLE "MGR_RULESENGINEPROPERTIES";
DROP TABLE "MGR_RULESMANAGER";
DROP TABLE "MGR_SCHEDULABLETASKPROPERTIES";
DROP TABLE "MGR_SERVERNOTIFICATION";
DROP TABLE "MGR_SERVERYUMREPOSITORYINFORMA";
DROP TABLE "MGR_STATISTICMANAGER";
DROP TABLE "MGR_TASKENGINEPROPERTIES";
DROP TABLE "MGR_TASKMANAGER";
DROP TABLE "MGR_TREESTORE";
DROP TABLE "MGR_USERACCOUNT";
DROP TABLE "MGR_USERSTORE";
DROP TABLE "MGR_VNICMANAGER";
DROP TABLE "MGR_VNICMANAGERPROPERTIES";
DROP TABLE "ODOF_ID_TO_TYPE";
DROP TABLE "ODOF_NOT_TABLED";
DROP TABLE "ODOF_SYS_PROPERTIES";
DROP TABLE "ODOF_TYPE_TO_CLASS";

Now restore the database:

$ imp ovs/xxxx file=/var/ovm/ovs_20110922_201611.dmp full=y


So have just dropped the OVM tables and done a restore of the DB taken just after the last installation. Restarted the ovmm service

$ service ovmm start

and a few minutes later the application was available again.

I will now rebuild the vmserver and see where that leads...

=