Create Oracle RAC databases for standalone prod servers

The Oracle RAC databases must be created manually before configuring WebSphere Portal.

All databases must be created using UNICODE Database and National character sets such as UTF8, AL32UTF8, or AL16UTF16.

IBM recommends that all databases to be used with WebSphere Portal are configured in Dedicated Server Mode.

Determine if your Oracle RAC server will be remote or local to the WebSphere Portal 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, set the buffer pools allocated to the Oracle RAC database in order for WebSphere Portal 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

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


Prerequisites

Installing Oracle RAC

Create users
Refer to the following instructions to create tablespaces:

  1. In the database directory, create the data directory data and the index directoryindex.

  2. Create the tablespaces.

    You must use the same tablespace names listed in the commands. The tablespace names cannot be customized or modified.

    1. Find and edit the SQL script jcr_ora_tablespaces.sql in the directory wp_proflie_root/ConfigEngine/work/db/oracle.

    2. In the define section, replace the following variables with the values from your environment:

      jcrdb

      Name of the database created to store user data.

      logfile

      Location to store the log file.

      dbpath

      Directory where created the database.

    3. Set the size, autoextend, and maxsize values according to your environment.

      For example, you may want to change the maxsize to a set value rather than UNLIMITED. Consult your Database Administrator for more info.

    4. Execute the following SQL script: Notes:

      • The DBA or a user with sufficient credentials (CREATE tablespace) must execute the script.

      • The script will prompt for the database username and password.

      # sqlplus SQL > @jcr_ora_tablespaces.sql
      


Parent topic:

Set up a remote Oracle RAC database on AIX, HP-UX, Linux, and Solaris for a stand-alone production server


Previous topic:

Create users


Next topic:

Modifying database properties