Set up a remote Oracle database on Windows for a stand-alone production server

Setting up the Oracle database includes creating user IDs and databases on a remote server. A task is provided to assist with creating the users. Before you can use the task, modify properties files.

  1. Installing Oracle

    View information on how to install Oracle for use with WebSphere Portal.

  2. Creating users

    View the steps to set up users for Oracle to work with WebSphere Portal.

  3. Creating databases

    View some important considerations before setting up Oracle databases to work with WebSphere Portal.

  4. Modifying database properties

    Learn how to modify the wkplc.properties, wkplc_comp.properties, and wkplc_dbtype.properties files to work with your database. Modify these property files before running tasks to create datbases, create users, or transfer data.

  5. Set up databases

    This topic provides instructions on automatically setting up your database using...

      ConfigEngine task to create users, grant permissions, and create Java Content Repository table spaces.

    • Optional: Assigning custom table spaces

      The repository of WebSphere Portal consists of many tables and indices that are created in default table spaces. When using an existing set of table spaces for the objects of the repository, specify this when executing the database transfer to the target database system.

    • Configure WebSphere Portal to use Oracle

      View information on manually transferring data to the Oracle database you have installed and set up. Follow these steps to transfer WebSphere Portal, and Java Content Repository databases to Oracle. As an alternative to the manual database transfer procedure described here, you can use the configuration wizard to complete the database transfer task.


Parent topic:

Set up a database