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.

The details of the diagram are provided in the figure caption.

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.

IBM Business Process Manager Express system requirements

Procedure

To upgrade the databases to V8.5, run the DBUpgrade utility.

BPM_home\bin\DBUpgrade.bat -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.bat -propertiesFile "C:\bpm 85\util\migration\resources\migration.properties" -backupFolder C:\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.