Windows stand-alone: Set up Oracle or Oracle RAC manually

If you have configured the database automatically by running ConfigEngine, you should not manually create users, privileges, or table spaces. You may decide to perform additional manual configuration for items that are not provided to you when you automatically when you run ConfigEngine.

For example, assigning custom table spaces is an optional task that is not covered by the automated ConfigEngine task.

• Windows stand-alone: Create Oracle or Oracle RAC database schemas and users
  To create database schemas and users, we can create a copy of the template SQL scripts and edit this copy to manually create the database schemas and users. The template SQL scripts should be used as a guide for creating executable scripts and contain invalid SQL syntax.
• Windows stand-alone: Grant privileges to Oracle or Oracle RAC database users
  Configuration and runtime database users are granted a different set of privileges, depending on whether these users are schema owners or not. We can create a copy of the SQL scripts and edit this copy to manually grant permissions to configuration and runtime database users.
• Windows stand-alone: Create JCR table spaces
  This topic provides manual instructions for creating JCR table spaces for Oracle.
• Windows stand-alone: Assign custom Oracle or Oracle RAC table spaces
  The repository of WebSphere Portal consists of many tables and indicecreated 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.

Parent: Windows stand-alone: Set up Oracle or Oracle RAC automatically or manually