Embedded Database Maintenance
309
n
ov
do
cx (e
n)
16
Ap
ril 20
10
3
Migrate the ZENworks Reports from the Sybase SQL Anywhere database to an Oracle
database:
3a
Install the Oracle client on a Primary Server that does not have an instance of the
ZENworks Reporting Server.
3b
Install a new instance of the ZENworks Reporting Server on the device on which you have
installed the Oracle client.
3c
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 34.6.1, “Preparing to Move the Data,” on page 305
.
3d
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
3e
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
.
34.6.4 Troubleshooting Database Migration
“Troubleshooting a Java Heap Space Exception” on page 309
“Troubleshooting an Oracle Database Crash” on page 310
“Troubleshooting an Oracle Tablespace Issue” on page 310
“Troubleshooting the Database Migration Failure Issue” on page 311
“Troubleshooting the Database Migration by Using An Existing User Schema” on page 311
Troubleshooting a Java Heap Space Exception
If you encounter a Java Heap Space exception during the database migration because of low
memory:
1
Edit the
ZENworks_installation_path
\bin\novell-zenworks-configure.bat
file on
Windows or
/opt/novell/zenworks/bin/novell-zenworks-configure
on Linux to
change the heap space value in the following line, depending upon the RAM of the device
where the migration utility is running:
"%JAVA_HOME%\bin\java" -Djava.library.path=%ZENLIB% -cp "%MYCP%"
%DEBUG_OPTS% %JAVA_OPTS% -Xmx128m
com.novell.zenworks.configure.ConfigureLoader %CONFIG_OPTS%
The heap space value is represented in megabytes (MB) within
-Xmx128m
. By default, it is
128.
For example, if the RAM of the device is 512 MB, then the line in the
novell-zenworks-
configure.bat
file can be updated as follows: