7.1 Preparing to Move the Data

Before migrating the data from the Sybase database to Oracle database, perform the following:

  • Ensure that the license state of ZENworks 11 SP4 is Active. The product must be installed and running either in the licensed version or the evaluation version.

  • Ensure that the Primary Server to which the Sybase database is configured has been upgraded to ZENworks 11 SP4.

  • Ensure that the ZENworks Primary Server has an internal Sybase database installed.

  • Ensure that the Oracle database is installed on a device that does not have ZENworks 11 SP4 installed.

  • Ensure that the USERS tablespace has sufficient space to create and store the ZENworks database schema. The tablespace requires a minimum of 100 MB to create ZENworks database schema without any data in it and an appropriate additional space depending upon the size of the database to be migrated. The database migration utility uses only the USERS tablespace by default. You cannot manually specify any other tablespace during the migration.

  • Ensure that the NLS_CHARACTERSET parameter is set to AL32UTF8 and the NLS_NCHAR_CHARACTERSET parameter to AL16UTF16 by running the following query at the database prompt:

    select parameter, value from nls_database_parameters where parameter like '%CHARACTERSET%';
  • Ensure that the sharename, filename, and path columns do not contain blank strings in the NC_VRBSOFTWARE table. In case these column have blank strings, delete those records from the table. Deleting these records will remove the usage of these software from database.

    Query to delete the records from NC_VRBSOFTWARE:

    DELETE FROM NC_VRBSOFTWARE WHERE SHARENAME='' OR PATH='' OR FILENAME='' OR SHARENAME IS NULL OR PATH IS NULL OR FILENAME IS NULL;

  • (Conditional) If you want to migrate the database by creating a new user schema, ensure that the following additional requirements are met:

    • You must be aware of the database administrator credentials.

    • A tablespace must already exist for associating to the Oracle access user

  • You can choose to migrate the database by using an existing user schema that resides on a server in your network in the following scenarios:

    • The database administrator creates a user schema with the necessary rights and you get the credentials for that user schema from the database administrator. In this case, the database administrator credentials are not required to migrate the database.

    • You create a user schema in the Oracle database and choose to use it during the database migration.

    If you want to migrate the database by using an existing user schema, ensure that the following additional requirements are met:

    • Ensure that the user schema has the following rights to create the database.

      • CREATE SESSION
      • CREATE_TABLE
      • CREATE_VIEW
      • CREATE_PROCEDURE
      • CREATE_SEQUENCE
      • CREATE_TRIGGER
    • Ensure that the quota for the user schema is set to Unlimited on the USERS tablespace.

  • Manually stop the ZENworks services running on all the ZENworks Servers in the Management Zone. For more information, see Step 2.a in the Backing Up the Embedded Sybase SQL Anywhere Database on a Windows or Linux Server.

    NOTE:If external Sybase database is installed by using Sybase installer instead of OEM installer from ZCM iso, then “Novell ZENworks Embeded Datastore Service” does not exists in database server. The external database service should be running before initiating the database migration.

  • Ensure that the Novell ZENworks Embedded Datastore service on the Primary Server is running.

    • On Windows:

      1. From the Windows desktop Start menu, click Settings > Control Panel.

      2. Double-click Administrative Tools > Services.

      3. Ensure that the status of the Novell ZENworks Embedded Datastore service is Started.

    • On Linux: At the console prompt, enter /etc/init.d/sybase-asa status.

  • Ensure that the Novell ZENworks Embedded Datastore for auditing service on the Primary Server is running.

    • On Windows:

      1. From the Windows desktop Start menu, click Settings > Control Panel.

      2. Double-click Administrative Tools > Services.

      3. Ensure that the status of the Novell ZENworks Embedded Datastore For Auditing service is Started.

    • On Linux: At the console prompt, enter /etc/init.d/sybase-audit-asa status.

  • (Optional) The status of database migration is logged into the novell-zenworks-configure.log file. By default, only the messages of the type Info and Severe are logged. If you want other message types (such as Finer, Finest, and Warning) to also be logged into the file, do the following in the novell-zenworks-configure.properties file:

    1. Set the value of Logger.logLevel to the appropriate message type.

      For example, if you want messages of the type Finest to be logged:

       #Logger.logLevel   = FINEST
    2. Uncomment the line by removing the “#” as follows:

      Logger.logLevel   = FINEST

    The novell-zenworks-configure.properties file is located in %ZENWORKS_HOME%\conf\ on Windows and in /etc/opt/novell/zenworks/ on Linux.