We recommend consulting your Oracle database administrator before performing this upgrade. The upgrade script provided is intended to upgrade your database from the latest released version of ZENworks Linux Management. If upgrading from a different version, you might need to modify the upgrade script.
Before you upgrade your database, your Oracle server must have access to the Oracle upgrade script, which was copied to your ZENworks Linux Management server during installation to the following location:
/usr/share/rcserver/schema-upgrade.sql
On the server hosting Oracle, become the Oracle user using the su command:
su - oracle
Run SQL*Plus to log in to your database:
sqlplus user/password@database
Run the database upgrade script:
@path_to_script/schema-upgrade.sql
Your Oracle database is now upgraded.