topic Reset OCUM DB in Active IQ Unified Manager Discussions

Reset OCUM DB

marcusgross — Mon, 15 May 2017 10:54:47 GMT

Hi,

our OCUM 7.1 database is corrupt. If I remove a cluster, the cluster nodes still remain in the database.

How can I reset the database without removing and reinstalling the application?

Marcus

mbeattie — Tue, 16 May 2017 06:00:05 GMT

Hi Marcus,

Which version of OCUM 7.1 are you using? Is it a windows or linux installer or the vSphere vApp?

I'll see if i can find any information on reseting the OCUM database schema to the default install.

Do you have a database backup you can restore from that is in a known stable state?

Please note the following KB article as AV scanning software can result in DB corruption so it's important to create scanning exclusions.

Additionally if you are using WFA with OCUM then you might want to reset your WFA datasource afterwards.

Login to your WFA portal using an account that has the admin role assigned to it
Click the "Execution" tab
Select "Data sources" from the navigation menu
Select the OCUM datasource, right click on it and select "Reset Scheme"
Once reset, right click on the datasource and select "Acquire Now"

Hope that helps

/Matt

marcusgross — Tue, 16 May 2017 08:01:49 GMT

Hi,

It's OCUM on RHEL.

You can reset it:

/etc/init.d/ocie stop
/opt/netapp/ocum/bin/db r umadmin

and recreate the maintenance user:

/opt/netapp/ocum/scripts/add-maintenance-user.sh

But the script doesn't work. It wants to use following parameters that are not supported by the adduser command:

--quiet 
--disabled-login

Fix the script:

cp add-maintenance-user.sh add-maintenance-user_mod.sh
chmod 755 add-maintenance-user_mod.sh

removing the parameters.

Marcus