Before migrating data to the new Oracle database, ensure that its version matches the source database (for example Oracle 19c, 21c).
Stop the ZENworks services on all the ZENworks Primary Servers in the Management Zone.
On the Primary Server:
Execute the following command at the server prompt:
microfocus-zenworks-configure -c Start
Enter the number next to the Stop action.
Ensure that ORDB2 is installed with the same database credentials as the ORDB1, assuming that the device currently hosting the Oracle database is called ORDB1 and the new Oracle database device is called ORDB2.
Move the data from ORDB1 to ORDB2. For more information about moving the data, see the Oracle database documentation.
Once the data migration is completed, perform the following actions on all the Primary Servers in the Management Zone to configure the ZENworks Primary Server to point to the new Oracle database (ORDB2).
Take back up, and edit the zdm.xml and edit zenaudit.xml files (located in /etc/opt/microfocus/zenworks/datamodel), and amedatasource.properties (located in /etc/opt/microfocus/zenworks/antimalware to do the following:
Edit the datamodel configuration files to point to the ORDB2.
Update the value for key 'Jdbc_Url' with the JDBC URL pointing to ORDB2 in zdm.xml and zenaudit.xml for ZENworks and audit databases.
(Conditional) If you have Antimalware enabled, update the value for the key 'database.jdbc.url' with the JDBC URL pointing to ORDB2 in amedatasource.properties.
Execute the following configure actions:
Run the microfocus-zenworks-configure -c GenerateOSPProperties command.
Run microfocus-zenworks-configure -c GenerateContentDatasourceConfigureAction on all the ZENworks servers.
Start the ZENworks services on all the ZENworks Servers in the Management Zone.
On the Primary Server:
Execute the following command at the server prompt:
/opt/microfocus/zenworks/bin/microfocus-zenworks-configure -c Start
Enter the number next to the Start action.
ZENworks Server should now point to the new database.