12.3 Post-Migration Tasks

If there is only one server in the Management Zone, all ZENworks services are automatically started after the data is successfully migrated to an Oracle database.

If there are multiple servers in the Management Zone:

  1. From the device where you ran the migration utility, copy the following files and paste them in the appropriate directory, on all other Primary Servers:

    • zdm.xml
    • dmaccounts.properties
    • dmmappings.properties

    Ensure that these files have appropriate rights. The files are located at the following path:

    • Windows: ZENworks_installation_path\conf\datamodel

    • Linux: /etc/opt/novell/zenworks/datamodel

  2. Start all the ZENworks Services on all the ZENworks Servers in the Management Zone.

    • On Windows: Do the following

      1. Execute the following command at the server prompt:

        novell-zenworks-configure -c Start

      2. Enter the number next to the Start action.

    • On Linux: Do the following:

      1. Execute the following command at the server prompt:

        /opt/novell/zenworks/bin/novell-zenworks-configure -c Start

      2. Enter the number next to the Start action.

  3. Migrate the ZENworks Reports from the Sybase SQL Anywhere database to an Oracle database:

    1. Install the Oracle client on a Primary Server that does not have an instance of the ZENworks Reporting Server.

    2. Install a new instance of the ZENworks Reporting Server on the device on which you have installed the Oracle client.

    3. Copy the reports to the device where the new instance of the Reporting Server is running. These are the ZENworks Reports that you saved before migrating them. For more information, see Section 12.1, Preparing to Move the Data.

    4. Publish the reports and restore the reporting rights and the ownership details of the reports by using the following command:

      zman rpld path_of_directory_containing_rights.xml_and_ownership.xml

    5. Uninstall the ZENworks Reporting Server instance that was installed prior to migrating the database.

The ZENworks Server now points to the new database.

For the Oracle 10g database, any administrator name is case sensitive, including login names from user sources. The default ZENworks administrator account automatically created during installation uses an initial capital, so in order to log in to ZENworks Control Center, you must enter Administrator.

NOTE:Ensure not to delete the ZENworks Sybase database files if you want to revert to using ZENworks Sybase database at a later time.

12.3.1 Configuring a migrated Oracle database on a device that has ZENworks Reporting Server installed

  1. Open the jdbc.sbo file from the following location:

    • On Windows: <zenwork_home>\share\boe\BusinessObjects Enterprise 12.0\win32_x86\dataAccess\connectionServer\jdbc

    • On Linux: /opt/novell/zenworks/share/boe/bobje/enterprise120/linux_x86/dataAccess/RDBMS/connectionServer/jdbc

  2. Locate the Oracle 11 database tag and add the following content below the JDBCDriver tag:

    • On Windows

      <ClassPath>
      <Path[zenworks_home]\share\boe-publish\drivers\jdbc\ojdbc5-11gR1.jar</Path>] 
      </ClassPath>
      
    • On Linux

      <ClassPath>

      <Path>/opt/novell/zenworks/share/boe-publish/drivers/jdbc/ojdbc5-11gR1.jar</Path>

      </ClassPath>

  3. After you modify the jdbc.sbo file, restart the BusinessObjects Enterprise services.

  4. After the BusinessObjects Enterprise services have been restarted, run the following command:

    novell-zenworks-configure -c UpdateBOE.

  5. Update BusinessObjects Enterprise from the <Zenworks_home>\bin folder.