Linux clustered server: Setting up Oracle or Oracle RAC automatically or manually

You can set up Oracle Enterprise Edition to work with WebSphere® Portal automatically or manually. When setting up Oracle automatically, the database administrator runs a ConfigEngine task to create users, grant privileges, and create JCR table spaces. As an alternative to automatically setting up the database, you can manually run scripts to create users, grant privileges, and create JCR table spaces.

Prerequisites
Linux clustered server: Installing Oracle or Oracle RAC
Linux clustered server: Modifying Oracle or Oracle RAC database properties
Linux clustered server: Creating Oracle or Oracle RAC databases

About this task

Automatic configuration provides a faster path for database administrators for setting up Oracle, but does not provide in depth knowledge of how the database is configured. Manual configuration allows database administrators to understand what is going on at each end of the process. If you want the speed of automatic database setup but you would like to gain a better understanding of what is happening during the automatic configuration process, you can review the steps in the manual configuration section and then return to the automatic configuration steps.
Note:
  • You must log in as the system administrator to run the ConfigEngine task or to manually set up the database.
  • If you have configured your database automatically by running the ConfigEngine task, 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.
  • Linux clustered server: Running a task to automatically setup Oracle or Oracle RAC
    This topic provides instructions on automatically setting up your database using the ConfigEngine task. As an alternative to automatically setting up the database, you can manually create users and grant privileges.
  • Linux clustered server: Setting up Oracle or Oracle RAC manually
    As an alternative to automatically setting up the database, you can manually configure the Oracle database to create users and grant privileges. If you have configured your database automatically by running the ConfigEngine task, 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 the ConfigEngine task. For example, assigning custom table spaces is an optional task that is not covered by the automated ConfigEngine task. To learn more about automatically configuring Oracle, refer to the Configuring Oracle automatically section in the information center.
  • Parent topic: Linux clustered server: Setting up a remote Oracle or Oracle RAC database
  • Previous topic: Linux clustered server: Creating Oracle or Oracle RAC databases
  • Next topic: Linux clustered server: Configuring your portal to use Oracle or Oracle RAC