Creating the database

Run the Oracle database configuration assistant to create the database.

About this task

To create the Oracle database that will be used for IBM® BigFix® Remote Control, complete the following steps:

Procedure

  1. Run the Oracle database configuration assistant.
    Windows® systems
    For example, Select Start > All Programs > Oracle > Configuration and Migration Tools > Database Configuration Assistant.
    UNIX®-based systems
    Enter the command dbca from the $ORACLE_HOME/bin directory.
  2. Click Next on the welcome screen.
  3. Step 1: Select Create a Database. Click Next.
  4. Step 2: Select General Purpose for the template. Click Next.
  5. Step 3:
    1. Specify a name for the database. For example, TRCDB.
    2. Specify an SID to be used to reference the database. For example, TRCDB.

    Click Next.

  6. Step 4: Select the database management option that you require. For example, Use Database Control for Database Management. Click Next.
  7. Step 5: Specify a password for the database and confirm the password. For example, dboracle. Click Next.
  8. Step 6: Specify where the database will be stored. For example, File System. Click Next.
  9. Step 7: Specify locations for the database files. For example, Use Database File Locations from Template. Click Next.
  10. Step 8: Select the recovery options for the database. Click Next.
  11. Step 9: On the Database Content window, click Next.
  12. Step 10: On the Initialization Parameters screen select the Character Sets tab.
    1. Select the required Database Character Set
    2. Click Next.
  13. When you are using Oracle 11g, the following two steps are also required.
    1. Security Settings, accept the enhanced 11g default security settings.
    2. Automatic Maintenance Tasks, enable automatic maintenance tasks.
  14. Step 11: On the Database Storage window click Next.
  15. Step 12: Select the required Creation Options. Click Finish.
  16. On the Confirmation screen, click OK to start the database creation.
    Note: This may take some time as it goes through the different stages.
  17. Click Exit when the database creation is complete.

Results

The Oracle database that will be used for IBM BigFix Remote Control is created.