Portal, Express Beta Version 6.1 Operating systems: i5/OS, Linux,Windows

Creating databases

This section provides information on setting up Oracle RAC databases to work with WebSphere Portal Express.

When creating Oracle RAC databases for use with WebSphere Portal Express, you should consider the following information:

• The Oracle RAC databases must be created manually before configuring WebSphere Portal Express.
• All databases must be created using UNICODE Database and National character sets such as UTF8, AL32UTF8, or AL16UTF16.
• It is recommended that all databases to be used with WebSphere Portal Express are configured in Dedicated Server Mode.
• Determine if your Oracle RAC server will be remote or local to the WebSphere Portal Express installation.
• If using an earlier version of Oracle RAC (9i or earlier), ensure that Oracle RAC JVM is also installed.
• After installing the database software for WebSphere Portal Express, you will need to set the buffer pools allocated to the Oracle RAC database in order for WebSphere Portal Express to communicate with the IBM Java Content Repository database. Use the following recommended values as a guide. Refer to the Oracle product documentation for information on how to set the buffer pools. Recommended initial buffer pool sizes are:

  db_block_size = 8192
  db_cache_size = 300M
  db_files = 1024
  log_buffer = 65536
  open_cursors = 1500
  pga_aggregate_target = 200M
  pre_page_sga = true
  processes = 300
  shared_pool_size = 200M

  Note: If you are using IBM Java Content Repository, the open_cursors value may need to be increased based on the table count in the IBM Java Content Repository schema.