Upgrading Oracle databases
For Oracle, upgrade your existing schemas and data so that your
databases work with the new version of IBM® Business Process Manager.
Figure 1. Sample environment after existing schemas and data are updated. The source environment is not
running and the databases are not in use. The databases contain updated schemas and data. The target
is not running but contains a stand-alone environment.
Run the DBUpgrade command to modify your existing database
schemas and data for use with IBM Business Process Manager
V8.5. The DBUpgrade
utility updates the following items to V8.5:
- System Data toolkit
- Process Portal process application
- Hiring Sample tutorial process application
Note: Although the DBUpgrade utility updates the System Data toolkit to
IBM Business Process Manager
V8.5, it does not automatically update
existing dependencies. The dependencies must be updated after migration.
Before you begin
Ensure that you have shut down the source environment before you proceed with the migration.
Important: You
must upgrade your Oracle database to a supported version. If your
Oracle database is at 9i or 10g, upgrade it to 11g before migration.
Verify
that the users that are configured to access your Oracle databases
have the necessary privileges to upgrade the databases. The following
database privileges are needed to modify existing Oracle database
schemas and data for use with IBM Business Process Manager V8.5.- The CONNECT, RESOURCE, DBA_TABLES, and SELECT privileges are required on the database level.
- The upgrade process accesses system views. Grant the SELECT privilege
to the user who performs the upgrade. These privileges are already
granted to the public group by default; it is not necessary to grant
them again unless they were revoked.
all_indexes all_tables USER_TAB_COLUMNS all_objects all_constraints all_tab_columns
For a list
of supported database versions, refer to the system requirements.
Procedure
To upgrade the databases to V8.5, run
the DBUpgrade utility.
BPM_home/bin/DBUpgrade.sh -propertiesFile migration_properties_file -backupFolder snapshot_folder
where:- migration_properties_file is the full path to the migration properties file in which you specified the configuration information for the target environment. Ensure that the value of the target.config.property.file property is set to the full path of the configuration properties file that you used to create your target environment. You must also set the value of profile.name.
- snapshot_folder is the directory that contains the information that was extracted from the source environment
For example:
BPM_home/bin/DBUpgrade.sh -propertiesFile /opt/BPM85/util/migration/resources/migration.properties -backupFolder /tmp/snapshot
What to do next
You might see warning messages similar to the following in the upgrade log: Couldn't load Resource META-INF*****. These messages can safely be ignored.