Creating an Oracle database for BMC Atrium DIL and the BMC Dashboards for BSM application server

Use this procedure to create an Oracle database that will serve to store the BMC Atrium DIL database caching information and the configuration information for the BMC Dashboards for BSM application server. If you plan to create the BMC Atrium DIL database using Oracle in a high-availability environment, you must create the database and add the user before installing BMC Dashboards for BSM. Additionally, if you plan to create a clustered BMC Dashboards for BSM application server, you must also create a separate schema to store the configuration data.

As an Oracle database administrator, perform the following tasks of creating the database and adding the user.

To create an Oracle database and database user for BMC Atrium DIL

1. Create an Oracle database by using the following recommendations and by following the procedures documented in the Oracle documentation:
   • Evaluate the volume of data to provide the appropriate sizing and extension policy for some of the tablespaces.
   • The size of the tablespaces should be appropriate for the amount of data in the BMC Remedy AR System database.
   • The database will not have the same volume of data as the BMC Remedy AR System database, but it can substantially grow.
   • The database should have a sufficient number of processes for the number of concurrent users accessing the system.
2. Create a user in the new database that has the following privileges:
   • Create session
   • Create table
   • Alter table
   • Drop table
   • Insert table
   • Select table
   • Role "resource"

To create an Oracle database and database user for BMC Dashboards for BSM application server

1. Create an Oracle database by using the following recommendations and by following the procedures documented in the Oracle documentation:
   • Evaluate the volume of data to provide the appropriate sizing and extension policy for some of the tablespaces.
2. Create a user (separate from the BMC Atrium DIL database user) that has the following privileges:
   • Create session
   • Create table
   • Alter table
   • Drop table
   • Insert table
   • Select table
   • Role "resource"