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.
- Installing Oracle
View information on how to install Oracle for use with WebSphere Portal.
- Creating users
View the steps to set up users for Oracle to work with WebSphere Portal.
- Creating databases
View some important considerations before setting up Oracle databases to work with WebSphere Portal.
- 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.
- 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