7.2 Migrating the Data from the Internal Sybase Database to an Oracle Database

7.2.1 Migrating the Data from the Internal Sybase Database to an Oracle Database

  1. Ensure that all the tasks listed in Preparing to Move the Data are completed.

  2. Run the database migration utility.

    • On the Windows Primary Server: At the command prompt, go to ZENworks_installation_path\bin\, then enter the following command:

      novell-zenworks-configure.bat -c DBMigrateConfigureAction

    • On the Linux Primary Server: At the console prompt, go to /opt/novell/zenworks/bin, then enter the following command:

      novell-zenworks-configure -c DBMigrateConfigureAction

  3. Enter the target database type as Oracle.

  4. Choose the purging option for data before database migration.

  5. Enter the IP address or host name of the Oracle database server.

  6. Enter the port used by the Oracle database server.

  7. Enter the fully qualified net service name for the Oracle database.

  8. You can choose to create a new user schema or use an existing user schema.

    If you choose to create a new schema, continue with Step 9.

    If you choose to use an existing user schema, skip to Step 10.

  9. Enter the database server administrator's user name and password.

  10. Enter the database schema name when prompted for the database user name.

  11. Enter the database schema password when prompted for the database user's password.

  12. Perform the steps from Step 5 to Step 11 for ZENworks audit database. The database migration starts.

  13. When the database migration is complete, you can check the novell-zenworks-configure.log file. The log file is located in %ZENWORKS_HOME%\log\ on Windows and in /var/opt/novell/log/zenworks/ on Linux.

  14. Remove the Novell ZENworks Embedded Datastore service from the device that has the internal Sybase database installed:

    On the Windows device: Perform the following tasks:

    1. At the server prompt, execute the following command:

      sc delete SQLANYs_ZENDatastore

      sc delete SQLANYs_ZENAuditDatastore

    2. Edit the%ZENWORKS_HOME%\conf\monitor.conf to remove dbsrv10 from the line highpriority=zenserver,casaserver,dbsrv10.

    On the Linux device: Perform the following tasks:

    1. At the console prompt execute the following command:

      • Sybase Database:

        • /etc/init.d/sybase-asa stop on SLES 11

        • systemctl stop sybase-asa.service on SLES 12.

      • Audit Database

        • /etc/init.d/sybase-audit-asa stop on SLES 11

        • systemctl stop sybase-audit-asa.service on SLES 12.

    2. Perform any of the following:

      • On SLES 11:

        1. Rename sybase-asa to sybase-asa1 by executing the following command:

          mv sybase-asa sybase-asa1

        2. Edit the /etc/opt/novell/zenworks/monitor.conf to remove sybase-asa from the line services=novell-zenserver novell-zenload sybase-asa.

      • On SLES 12:

        Rename sybase-asa.service to sybase-asa.service1 in the /usr/lib/systemd/system folder.

  15. After the database is successfully migrated, continue with the following steps:

    1. Perform post-migration tasks. See Post-Migration Tasks.

    2. Re-configure the ZENworks Reporting Server to point to the Oracle database, because it will still be pointing to the Sybase database.

7.2.2 Resuming the Database Migration

If the migration of the database is stopped for any reason, the ZENworks migration utility allows you to resume the migration if the dbmigration.xml file has been created. The file is located in the %ZENWORKS_HOME%\bin directory on Windows, and in the /opt/ novell/zenworks/bin directory on Linux.

  1. Run the database migration utility. For more information, see Step 2 in the Migrating the Data from the Internal Sybase Database to an Oracle Database.

  2. Enter the target database type as Oracle.

  3. Enter the IP address or host name of the Oracle database server.

    You must specify the IP address or host name of the Oracle database server used while migrating the database. For example, if you had specified the IP address of the database server while migrating the database, then you must specify the same IP address while resuming the database migration. You cannot specify the host name of the database server.

  4. Enter the port used by the Oracle database server.

  5. Enter the fully qualified net service name for the Oracle database.

  6. Choose to use an existing schema.

  7. Enter the schema name when prompted for the database user name specified before stopping the database migration.

  8. Enter the database schema password when prompted for the database user's password specified before stopping the database migration.

  9. Choose to resume the database migration.

    The database migration starts.

  10. After the database is successfully migrated, continue with Post-Migration Tasks.