Preparing your Oracle environment - preliminary steps
About this task
To prepare your Oracle environment for data
migration, perform the following preliminary steps:
Procedure
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.
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
Ensure that you have a minimum of three 500
MB redo logs.