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

---

 

Create databases and users for Oracle RAC

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

 

Before you begin

• You should have completed Installing Oracle RAC.

 

Note the following information:

• If WebSphere Portal Express Version 6.0 and an earlier version of WebSphere Portal Express coexist, the database user IDs for WebSphere Portal Express Version 6.0 must be different than earlier versions to avoid conflicts during installation.

 

Database considerations

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.

• IBM recommends 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 DB2^® Content Manager Runtime Edition database. Use the following recommended values as a guide. Refer to Oracle product documentation for information on how to set the buffer pools. Recommended initial buffer pool sizes:

  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

  If you are using DB2 Content Manager Runtime Edition, the open_cursors value may need to be increased based on the table count in the DB2 Content Manager Runtime Edition schema.

 

Set up databases

You must create the databases that you are planning to use, create users, and grant privileges before you can configure WebSphere Portal Express to use the database. After you finish setting up the databases, you should continue to Transferring Oracle RAC manually.

 

Create databases and users

Create Oracle RAC databases. A database might have several instances in RAC, please refer to the Oracle RAC documentation for more information. Startup Oracle databases and verify the status of all the instances by running the following SQL commands:

  SQL> select * from v$active_instances;
	INST_NUMBER	INST_NAME

node1:instance1
node2:instance2

Create equivalent users in Oracle RAC. Please refer to Creating databases and users for Oracle for more information.

 

Next steps

You have completed this step. Continue to the next step.

 

Parent topic:

Configuring Oracle RAC

 

Previous topic

Installing Oracle RAC

 

Next topic

Transferring Oracle RAC

---