How can we re-create OA database?

Document ID:KM03765247
Creation Date:30-Nov-2020
Modified Date:30-Nov-2020
- Micro Focus Products:
  operations agent

Archived Content: This information is no longer maintained and is provided "as is" for your convenience.

Summary

This KM documents how we can re-create OA database

Question

How can we re-create OA database?

Answer

We can follow below steps to re-create OA database:

1. ovc -stop AGENT
2. pctl stop
Note: The above command is to stop PERFD in case it is running

3. Take a backup of the entire directory %OvDataDir%databases/oa
4. Run the below command to create the file oa.db under %OvDataDir%databases/oa: %OvInstallDir%sqlite3 "%OvDataDir%databases/oa/oa.db" < "%OvDataDir%conf/oa/Model/DMLMetaMetaSchema"
5. Set UPDATED_MODEL_AVAILABLE to true:
ovconfchg -ns oacore -set UPDATED_MODEL_AVAILABLE true

6. ovc -start AGENT