Upgrading Oracle database schemas
For most versions of WorldServer, you can upgrade Oracle databases on the database server machine only one version at a time. For example, you cannot upgrade directly from version 10.4.3 to version 11.0.1; you have to upgrade from version 10.4.3 to version 10.4.4 first, then you can jump from version 10.4.4 to version 11.0.0, and only then can you upgrade from version 11.0.0 to version 11.0.1. Always take into account the versions of the available upgrade scripts before planning your upgrade.
Before you begin
- Make sure you have a database connection for the WorldServer version you want to upgrade from. For example, if you want to upgrade from version 10.4.3, make sure you have a 10.4.3 database connection.
- Make sure that the NLS_LENGTH_SEMANTICS parameter is set to its default value of
BYTE. - Make sure you have a user with the required roles and system privileges in Oracle SQL Developer. If you do not have such a user, create one.
- Required roles:
connectandresource - Required privileges:
Create synonym,Create view, andCreate table
- Required roles:
- If you want to use the System Monitor tool, connect as sysdba and run the following commands:
In this case, <user name> is the name of the database user and is provided as an argument to Oracle SQL Developer.GRANT SELECT ON SYS.V_$SESSION TO <user name>; GRANT SELECT ON SYS.V_$LOCKED_OBJECT TO <user name>; GRANT SELECT ON SYS.V_$SQLTEXT_WITH_NEWLINES TO <user name>; GRANT SELECT ON SYS.V_$SQL TO <user name>; GRANT SELECT ON SYS.DBA_OBJECTS TO <user name>; COMMIT;
Procedure
Results
What to do next
Upgrade your WorldServer software, and then validate your upgrade. Make sure you have finished running all the database upgrade scripts before you test your upgrade with the testschema script.