2.5 Upgrading the Remote OEM Sybase SQL Anywhere Database

OEM Sybase SQL Anywhere 12 is supported by ZENworks 11 SP2. If you are using a remote OEM Sybase SQL Anywhere database, you need to upgrade it to OEM Sybase SQL Anywhere 12 on your remote database server.

Perform the following steps to upgrade the Sybase engine and then upgrade and rebuild the remote OEM Sybase SQL Anywhere database:

IMPORTANT:Before you upgrade the Remote OEM Sybase SQL Anywhere database, you need to backup the database files to the default location. For more information, see TID 7009199.

  1. If the OEM Sybase database is installed on a remote machine, you need to stop the ZENworks services on all the Primary Servers. However, if the OEM Sybase database is installed on the ZENworks server, you need to stop the services only on the remaining servers. The upgrade installer will stop and start the services on the ZENworks server.

  2. On the device that has remote OEM Sybase SQL Anywhere database installed, insert the Novell ZENworks 11 SP2 installation DVD and run one of the following commands:

    • On Windows, run the following command on the external database server: DVD_drive:\setup.exe --upgrade-oemdb

      or

      DVD_drive:\setup.exe -O

      O” should be typed in uppercase.

    • On Linux, run the following command on the external database server:

      sh /media/cdrom/setup.sh --upgrade-oemdb

      or

      sh /media/cdrom/setup.sh -O

      O” should be typed in uppercase.

  3. On the Language Selection page, select the language in which you want to run the installer, then click OK.

  4. On the Introduction page, click Next to proceed.

  5. On the License Agreement page, click Next.

  6. On the External Database Configuration page, specify the following details:

    • Database Name: Specify the name of the existing database.

    • Username: Specify the user who can modify the database. The user must have read/write permissions to modify the database.

    • Password: Specify the password of the user who has read/write permissions to the database.

    • Database Server Name: Specify the name of the OEM Sybase SQL Anywhere database server.

  7. Click Next.

  8. In the next screen, click OK to proceed with the upgrade.

    If the database configuration details specified in Step 6 are correct, the OEM Sybase SQL Anywhere database is upgraded and the Installation Complete page is displayed.

    If the database configuration details are incorrect, an error message is displayed. To proceed with the upgrade you need to re-enter the correct details on the Database Configuration page.

  9. Click Next.

  10. On the Upgrade Completed Successfully page, click Finish to complete the upgrade.

NOTE:After the upgrade is completed, check for errors in the log file (ZENworks_OEM_Database_Upgrade_<timestamp>.log.xml) located in <Install_location>/Novell/ZENworks/logs on Windows or in /var/opt/novell/log/zenworks on Linux. If there are any errors, contact Novell Support for assistance.