Embedded Database Maintenance
305
n
ov
do
cx (e
n)
16
Ap
ril 20
10
34.6.1 Preparing to Move the Data
Before migrating the data from the Sybase database to Oracle database, do the following:
Make sure that the license state of ZENworks 10 Configuration Management 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
report-save (rpsv)
(destination folder)
command. The XML files contain rights and ownership details of all
the reports.
Make sure that the Primary Server on which the Sybase database is configured has been
upgraded to ZENworks 10 Configuration Management.
Make sure that the ZENworks Primary Server has an internal or external Sybase database
installed.
Make sure that the Oracle database is installed on a device that does not have ZENworks 10
Configuration Management 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.
CREATE SESSION
CREATE_TABLE
CREATE_VIEW
CREATE_PROCEDURE
CREATE_SEQUENCE
