Preparing your Oracle environment - preliminary steps

To prepare your Oracle environment for data migration, you will need to complete preliminary steps.

About this task

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.
  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.