Solaris clustered server: Set up Oracle or Oracle RAC automatically or manually

We can set up Oracle Enterprise Edition to work with WebSphere Portal automatically or manually. When setting up Oracle automatically, we run a ConfigEngine task to create users, grant privileges, and create JCR table spaces. Alternatively, we can manually run SQL scripts to create users, grant privileges, and create JCR table spaces.

Prerequisites

Solaris clustered server: Install Oracle or Oracle RAC

Solaris clustered server: Modify Oracle or Oracle RAC database properties

Solaris clustered server: Create Oracle or Oracle RAC databases

• You must log in as the system administrator to run ConfigEngine or to manually set up the database.

• If you have configured the database automatically by running ConfigEngine, you do not need to run manual tasks for creating users, privileges, or table spaces, but you may decide to refer to the manual configuration section to perform the optional step of assigning custom table spaces.

• Solaris clustered server: Run a task to automatically setup Oracle or Oracle RAC
  When you set up Oracle or Oracle RAC automatically, modify the approriate properties files before transferring your data from the default database to the Oracle or Oracle RAC database.
• Solaris clustered server: Set up Oracle 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.

Parent: Solaris clustered server: Set up a remote Oracle or Oracle RAC database
Previous: Solaris clustered server: Create Oracle or Oracle RAC databases
Next: Solaris clustered server: Configure Portal to use Oracle or Oracle RAC