Create Oracle databases for HP-UX

Have the DB admin create Oracle databases manually before attempting to integrate WebSphere Portal with Oracle.

For remote Oracle databases, copy ojdbc14.jar from the remote Oracle server to...

All databases must be created using UNICODE and National character sets such as...

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

  • Determine if your Oracle server will be remote or local to the WebSphere Portal installation.

  • After installing the database software for WebSphere Portal, set the buffer pools allocated to the Oracle database in order for WebSphere Portal to communicate with the 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:

    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 Java Content Repository schema.

  • Raise the number of parallel servers as appropriate.

    For example, if you have more than 875 parallel servers, you should set the parallel_max_servers to 1200.


    Prerequisites

    Installing Oracle

    Creating users


    Parent topic:

    Configure WebSphere Portal to use Oracle


    Previous topic:

    Creating users


    Next topic:

    Modifying database properties