Skip to Content

How to Upgrade to SQL Anywhere, on-demand edition SP4

SAP SQL Anywhere, on-demand edition SP4 contains a significant change to the underlying encryption infrastructure. As a result of this change, some additional manual steps are required to upgrade an existing cloud to SP4.

The steps outlined below can be used to upgrade an existing SAP SQL Anywhere, on-demand edition SP3 cloud to SP4.

If any questions or problems arise during the upgrade, please feel free to ask questions here on the SAP Community Network, or on the SQL Anywhere Forum.

Download and install the support package

  1. Download dbcloud_sp4.patch.zip (attached at the end of this document). Unzip it to produce dbcloud_sp4.patch.
  2. You must apply the dbcloud_sp4.patch file to your cloud before you can download and install the support package. To apply the patch file to your cloud, run the following command using dbcloudcmd:
    dbcloudcmd run -internal ApplyPatch <path_to_patch_file>
          For example:
    dbcloudcmd run -internal ApplyPatch c:\dbcloud_sp4.patch
  3. Once the patch file has been applied to the cloud, upgrade your cloud by using one of the following methods outlined below:
    • Download and install the support package software, then run Upgrade Cloud Infrastructure to upgrade your cloud software, OR
    • Use Upgrade Cloud Infrastructure to upgrade your cloud software. If the support package software is not already downloaded, it will download and install it for you before upgrading.

If the DownloadCloudSoftware task fails with an error saying that your certificate file is invalid for OpenSSL, refer to the following section for instructions on creating a new cloud certificate and upgrading your cloud.

If the UpgradeCloudInfrastructure task fails, refer to the "Troubleshooting Upgrade Cloud Infrastructure" section.

Changes to cloud encryption

Cloud encryption now uses OpenSSL rather than Certicom encryption. If your attempt to download the support package software fails with an error saying that your certificate file is invalid for OpenSSL, then you must create a new cloud certificate.

  1. Use the Certificate Creation utility (createcert.exe)that came with your SAP SQL Anywhere on-demand software to create a new certificate by running the following command, supplying your own values for those in quotes:
    createcert -t rsa -b 2048 -sc "country-code" -sst "state-code" -sl "locality" -so "organization" -sou "organizational unit" -scn "common name" -x -m 0 -v 5 -ca 0 -u 1,3,4,5,6
    Note: The password for the new cloud certificate must be the same as the password for the existing cloud certificate. Contact SAP Technical Support if you have forgotten your password.
  2. Save the new certificate, identity, and private key as root-cert.pem, root-id.pem, and root-key.pem, respectively. Copy these files to the saccertificate subdirectory of the cloud data directory on each host of the cloud.
  3. Use the Cloud Console to stop the cloud.
  4. Restart the Cloud Agents on the cloud partner and arbiter servers.
  5. Use the Cloud Console to start the cloud servers and tenant databases.
  6. Upgrade your cloud software by using one of the following methods outlined below:
    • Download and install the support package software, then run the Upgrade Cloud Infrastructure to upgrade your cloud software, OR
    • Use Upgrade Cloud Infrastructure to upgrade your cloud software. If the support package software is not already downloaded, it will download and install it for you before upgrading.

If the UpgradeCloudInfrastructure task fails, refer to the following troubleshooting section.

Troubleshooting Upgrade Cloud Infrastructure

When running the UpgradeCloudInfrastructure task, the upgrade may fail with a heartbeat error. If this error occurs, then use the Cloud Console to install the support package software on the affected hosts individually. Once the support package is installed, re-run the UpgradeCloudInfrastructure task.


Tags:
Former Member

No comments