Before migrating the data from the Sybase database to Oracle database, do the following:
Make sure that the license state of ZENworks 11 is Active. The product must be installed and running either in the licensed version or the evaluation version.
Save all the reports, rights.xml, and ownership.xml by using the zman report-save (rpsv) (destination folder) command. The XML files contain rights and ownership details of all the reports.
Make sure that the Oracle database is installed on a device that does not have ZENworks 11 installed.
Make sure 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.
Make sure 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%';
(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:
Make sure that the user schema has the following rights to create the database.
Make sure 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.
On Windows: Do the following:
Execute the following command at the server prompt:
novell-zenworks-configure -c Stop
Enter the number next to the Stop action.
On Linux: Do the following:
Execute the following command at the server prompt:
/opt/novell/zenworks/bin/novell-zenworks-configure -c Stop
Enter the number next to the Stop action.
Make sure that your external Sybase database service is running.
(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:
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
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.