Preparing your Oracle environment

Review all the information to prepare your Oracle environment for data migration.

The following sections provide instructions for preparing your Oracle environment for data migration.

Note: If you are upgrading in sharded mode, the instructions described in this section must be followed for all shards in all colonies.

Preparing your Oracle environment - preliminary steps
To prepare your Oracle environment for data migration, you will need to complete preliminary steps.
Preparing your Oracle environment - database tables
Before migrating your Oracle environment, it is recommended that you analyze your database tables.
Preparing your Oracle environment - Oracle parameters
You will set certain Oracle parameters to prepare your Oracel environment for migration.
Preparing your Oracle environment - undo retention
For the data migration process, the interval of the Undo retention should be increased to handle the database changes.
Preparing your Oracle environment - undo tablespace
For the data migration process, the size of the Undo tablespace should be doubled to handle the database changes.
Preparing your Oracle environment - additional indexes
Ensure that you do not need additional indexes through monitoring your migration process in a test environment.
Preparing your Oracle environment - redo log files on raw devices
You can boost system performance if you implement the Oracle’s Redo log files on raw devices option.

Parent topic: Upgrading to Release 9.5