Preparing your Oracle environment - preliminary steps

About this task

To prepare your Oracle environment for data migration, perform the following preliminary steps:

Procedure

  1. Verify that your database has been upgraded to the version of Oracle that is supported for your environment. For information about system requirements, go to the IBM® Support Portal at http://www.ibm.com/support/entry/portal/Planning.
  2. Configure the INIT<INSTANCE_NAME>.ORA file to set the following parameters:
       open_cursors= <set to appropriate value> 

    For example, the minimum value for WebLogic equals the number of threads across all application servers + (connection pool size X prepared statement pool size). For IBM WebSphere®, the minimum value equals the number of threads across all application servers + the prepared statement pool size

       
       cursor_sharing=FORCE
       compatible=<set to the Oracle version>
       timed_statistics=true
       db_block_size=8192
       
  3. Ensure that you have a minimum of three 500 MB redo logs.