1.5 Upgrading the Remote OEM Sybase SQL Anywhere Database

ZENworks 11 SP3 does not support OEM Sybase database on a 32-bit device. Ensure that you migrate the OEM Sybase database on a 32-bit device to a 64-bit device before upgrading the ZENworks Primary Server.

IMPORTANT:The ZENworks Upgrade installer does not verify whether the database is on a 64-bit device or a 32-bit device.

1.5.1 Upgrading the Remote OEM Sybase SQL Anywhere Database for a 32-bit Operating System

Upgrading the Remote OEM Sybase SQL Anywhere Database for a 32-bit Windows Device

On the 32-bit device, execute the following commands:

  1. Go to Run prompt and execute the services.msc command.

  2. In the Services page, select Novell ZENworks Embedded Datastore and stop the service.

  3. Backup the ZENworks database.

  4. Disable the network configuration on this device.

    NOTE:Before disabling the network configuration, note the network identity details for this device.

On the 64-bit device, execute the following commands:

  1. Reconfigure the network identity of the 32-bit device to the 64-bit device.

  2. Run setup.exe -c.

    NOTE:Run setup.exe -c --zcminstall if ZENworks is installed on the same device. For information on why the Audit database is created using the -c option, see Section 1.2, Database Considerations.

  3. In the Introduction page, click Next to proceed.

  4. In the License Agreement page, click Next.

  5. In the Select the Database to be Configured page, select both ZENworks and Audit.

    NOTE:If you want to create the Audit database on a separate device, do not select Audit in this step and ignore the Step 7.

  6. To create the ZENworks database:

    1. In the Select database type for ZENworks page, select OEM Sybase SQL Anywhere and click Next.

    2. In the Sybase Server Configuration page, provide the Port Number as 2638 and click Next.

      NOTE:Port 2638 is the default ZENworks database. If it is busy, provide an alternate port number.

    3. In the Sybase Access Configuration page, enter Database Name, Username, Password, and Server Name, then click Next.

      IMPORTANT:Ensure that the ZENworks database details are the same as the database details on the 32-bit device.

    4. In the Database File Location page, provide the path where the ZENworks database should be created.

    5. Review the inputs provided, then select Next to continue.

  7. To create the Audit database:

    1. In the Select database type for the Audit page, select OEM Sybase SQL Anywhere or External Sybase SQL Anywhere, then click Next.

      NOTE:For the steps to create the Audit database for External Sybase SQL Anywhere, see External Sybase SQL Anywhere Database Installation Information. The steps for OEM Sybase SQL Anywhere are given below.

    2. In the Sybase Server Configuration page, enter the Port Number as 2639, then click Next.

      NOTE:Port 2639 is the default Audit database port. If it is busy, provide an alternate port number.

    3. In the Sybase Access Configuration page, enter Database Name, Username, Password, and Server Name, then click Next.

      NOTE:Ensure that the Audit database details are unique and different from the ZENworks database details.

    4. In the Database File Location page, provide the path where the Audit database should be created, then click Next.

    5. Review the inputs provided, then click Next to continue.

  8. Go to Run prompt and execute the services.msc command.

  9. In the Sevices page, select Novell ZENworks Embedded Datastore and stop the service.

  10. Copy and replace the ZENworks database file and corresponding log file from the 32-bit device to the 64-bit device.

  11. Rebuild the Sybase database by running the following command:

    <Sybase installed path>\share\ASA\bin64s\dbunload -c "UID=<username>;PWD=<password>;DBF=<Database file path>\<Database name>.db" -ar -ap 16384 -ii –et

    Where:

    • 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 file path: Specify the path where the database has to be created.

  12. Go to Run prompt, then execute services.msc command.

  13. In the Sevices page, select Novell ZENworks Embedded Datastore and start the service.

  14. Ensure that the ports used for the ZENworks database and the Audit database are included in the firewall exception list. Run the following command:

    netsh firewall set prtopening protocol = All port = <port number> name = <port name> mode = enable net start mpsSvc

    Where:

    • port number: By default it is 2638 for ZENworks and 2639 for Audit or any alternate port number that is configured. This command must be executed separately for the ZENworks database port and the Audit database port.

    • port name: Specify the name used for the port. For example, ZENworks database port.

  15. Proceed with ZENworks Primary Server Upgrade. For information, see Section 1.6, Upgrading the Primary Servers.

Upgrading the Remote OEM Sybase SQL Anywhere Database for a 32-bit Linux Device

On the 32-bit device, execute the following commands:

  1. /etc/init.d/sybase-asa stop

    NOTE:If the OEM Sybase database and ZENworks service are running on the same device. Ensure that you stop the novell-zenworks-monitoring service or remove the entry sybase-asa from /etc/opt/novell/monitor.conf (and restart the monitoring daemon) before stopping the Sybase daemon.

  2. Backup the ZENworks database.

  3. Disable the network configuration on this device.

    NOTE:Before disabling the network configuration, note the network identity details of this device.

On the 64-bit device execute the following commands:

  1. Reconfigure the network identity of the 32-bit device to the 64-bit device.

  2. Run sh setup.sh -c.

    NOTE:Run sh setup.sh -c --zcminstall if ZENworks is installed on the same device. For information on why the Audit database is created using -c option, see Section 1.2, Database Considerations.

  3. In the Introduction page, click Next to proceed.

  4. In the License Agreement page, click Next.

  5. In the Select the Database to be Configured page, select both ZENworks and Audit.

    NOTE:If you want to create the Audit database on a separate device do not select Audit in this step and ignore Step 7.

  6. To create the ZENworks database:

    1. In the Select database type for ZENworks page, select OEM Sybase SQL Anywhere, then click Next.

    2. In the Sybase Server Configuration page, provide the Port Number as 2638, then click Next.

      NOTE:Port 2638 is the default ZENworks database port. If it is busy, provide an alternate port number.

    3. In the Sybase Access Configuration page, enter Database Name, Username, Password, and Server Name, then click Next.

      IMPORTANT:Ensure that the ZENworks database details are the same as the database details on the 32-bit device.

    4. In the Database File Location page, provide the path where the ZENworks database should be created.

    5. Review the inputs provided, then click Next to continue.

  7. To create the Audit database:

    1. In the Select database type for Audit page, select OEM Sybase SQL Anywhere or External Sybase SQL Anywhere, and click Next.

      NOTE:For the steps to create the Audit database for an External Sybase SQL Anywhere, see External Sybase SQL Anywhere Database Installation Information. The steps for OEM Sybase SQL Anywhere are given below.

    2. In the Sybase Server Configuration page, enter Port Number as 2639, then click Next.

      NOTE:Port 2639 is the default Audit database port. If it is busy, provide an alternate port number.

    3. In the Sybase Access Configuration page, enter Database Name, Username, Password, and Server Name, then click Next.

      NOTE:Ensure that the Audit database details are unique and different from the ZENworks database details.

    4. In the Database File Location page, provide the path where the Audit database is created, then click Next.

    5. Review the inputs provided and select Next to continue.

  8. /etc/init.d/sybase-asa stop

    NOTE:If the OEM Sybase database and ZENworks service are running on the same device, ensure that you stop the novell-zenworks-monitoring service or remove the entry sybase-asa from /etc/opt/novell/monitor.conf (and restart the monitoring daemon) before stopping the Sybase daemon.

  9. Copy and replace the ZENworks database file and the corresponding log file from the 32-bit device to the 64-bit device.

  10. Rebuild the Sybase database by running the following command:

    /opt/novell/zenworks/share/sybase/bin64s/dbunload -c "UID=<username>;PWD=<password>;DBF=<Database file path>\<Database name>.db" -ar -ap 16384 -ii –et

    Where:

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

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

    • database file path: Specify the path where database will be created.

  11. /etc/init.d/sybase-asa start

  12. Ensure that the ports used for the ZENworks database and the Audit database are included in the firewall exception list. Run the following command:

    iptables -I INPUT -p tcp --dport PORT--syn -j ACCEPT

    Where:

    PORT: By default it is 2638 for the ZENworks and 2639 for the Audit or any alternate port number that is configured. This command has to be executed separately for the ZENworks database port and the Audit database port.

    service iptables save

    service iptables restart

  13. Proceed with ZENworks Primary Server Upgrade. For information, see Section 1.6, Upgrading the Primary Servers.

1.5.2 Upgrading the Remote OEM Sybase SQL Anywhere Database for a 64-bit Operating System

Upgrading the Remote OEM Sybase SQL Anywhere Database for a 64-bit Windows Device

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

  1. If the OEM Sybase database is installed on a remote device, 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 SP3 installation DVD and run one of the following commands:

    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.

  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 page, 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 must 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.

  11. setup.exe -c

    NOTE:Run setup.exe -c --zcminstall if ZENworks is installed on the same device. For information on why the Audit database is created, using the -c option see, Section 1.2, Database Considerations.

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

    2. On the License Agreement page, click Next.

    3. In the Select the Database to be configured page, select Audit.

    4. In the Select database type for the Audit page, select OEM Sybase SQL Anywhere.

    5. In the Sybase Server Configuration page, enter Port number as 2639.

      NOTE:Port 2639 is the default Audit database port. If it is busy, provide an alternate port number.

    6. In the Sybase Access Configuration page, enter Database Name, Username, Password, and Server Name.

      NOTE:Ensure that the Audit database details are unique and different from the ZENworks database details.

    7. In the Database File Location page, provide the path where the Audit database should be created.

    8. Review the inputs provided, then click Next to continue.

NOTE:The log file is available at: <Install_location>\Novell\ZENworks\logs\ZENworks_OEM_Database_Upgrade_<timestamp>.log.xml.

Upgrading the Remote OEM Sybase SQL Anywhere Database for a 64-bit Linux Device

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

  1. If the OEM Sybase database is installed on a remote device, 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 the remote OEM Sybase SQL Anywhere database installed, insert the Novell ZENworks 11 SP3 installation DVD on the external database server and run the following commands in the sequence given below:

    1. /etc/init.d/sybase-asa stop

      NOTE:If the OEM Sybase database and the ZENworks service are running on the same device. Ensure that you stop the novell-zenworks-monitoring service or remove the entry sybase-asa from /etc/opt/novell/monitor.conf (and restart the monitoring daemon) before stopping the Sybase daemon.

    2. /bin/rpm -Uvh /media/ZENworks11SP3/Common/rpm/sybase-asa-12.0.1-3873.x86_64.rpm

    3. /opt/novell/zenworks/share/sybase/bin64s/dbunload -c "UID=<username>;PWD=<password>;DBF=<database path>" -ar -ap 16384 -ii –et

      Where:

      • 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 path: Specify the path where database is created.

    4. /etc/init.d/sybase-asa start

    5. sh setup.sh -c

      NOTE:Run sh setup.sh -c --zcminstall if ZENworks is installed on the same device. For information on why the Audit database is created using theSetup.sh -c command, see Section 1.2, Database Considerations.

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

      2. On the License Agreement page, click Next.

      3. In the Select the Database to be configured page, select Audit.

      4. In the Select database type for Audit page, select OEM Sybase SQL Anywhere.

      5. In the Sybase Server Configuration page, enter Port number as: 2639.

        NOTE:Port 2639 is the default Audit database port. If it is busy, provide an alternate port number.

      6. In the Sybase Access Configuration page, enter Database Name, Username, Password, Server Name.

        NOTE:Ensure that the Audit database details are unique and different from the ZENworks database details.

      7. In the Database File Location page, provide the path where the Audit database should be created.

      8. Review the inputs entered, then click Next to continue.

    6. The Database Installation prompt opens. Click OK to install the Audit database.

    7. On the Installation Complete page, click Next to exit the installer.

      NOTE:The log file is available at: /var/opt/novell/log/zenworks/ZENworks_OEM_Database_Upgrade_<timestamp>.log.xml.