Creating an Oracle database and database users (schemas)

When you create an Oracle database and database users for use with IBM® Control Center, ensure that you configure the settings required for operation with IBM Control Center.

Install the Oracle database server instance and ensure that you have the authority to create the database and database users.
Create the database with the required settings outlined in Required settings for the Oracle database and database users. You can use one Oracle database instance for the production and reports databases by creating two different database users (schemas). The following high-level steps are used to create an Oracle database:
  1. Create and configure an Oracle database instance with the required settings.
    Use AL32UTF8 as the character set when creating the instance. If your existing Oracle instance has the required settings, then you do not need to create a new instance.
  2. Identify or create table spaces for user tables and indexes.
  3. Create two different database users (schemas).
  4. Grant permissions to the users.