Updating the Oracle database

To help ensure stability, enforce security, and maintain dependable operations, it is strongly recommended that you update your Oracle databases as required by the Oracle.

It is also strongly recommended that you test the updates in a local test environment before you update the production databases, and always make sure that you have a correct backup procedure, should you need to restore a previous system.

Supported Oracle versions

Before updating your Oracle database, you must make sure the Oracle version you are updating to is supported by your WorkZone version. Never upgrade your Oracle installation to an Oracle version that is not supported by the WorkZone version you intend to use.

All supported software is listed in the Support matrix topic in the release notes for the WorkZone version you are using. For more information, see Support matrix.

Patching your Oracle installation

Security patches and hot fixes should be installed on your Oracle database, including security patches to your operating system but you must still test all updates in a local test environment before updating the production environments.

Remember to check the compatibility between operating system updates and Oracle versions. Installing incompatible updates can lead to unforeseen errors and production downtime required to remove the updates again.