Page tree

Unsupported content


This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Skip to end of metadata
Go to start of metadata

This topic describes how you can manually Set up database users and tablespaces when installing BMC Capacity Optimization for the first time.


Use a Database Administrator account to execute the following steps only if it is NOT possible for the Database Administrator to provide you the sysdba password to automatically create users and tablespaces while installing BMC Capacity Optimization. If you follow the procedure given below, you must select the Database users and tablespaces have been created externally option while performing the BMC Capacity optimization installation.

If you are an Oracle database administrator and you need or choose to manually set up or migrate database users and tablespaces in BMC Capacity Optimization, do the following:

  1. Create or migrate tablespaces.
  2. Create or migrate users.
  3. Grant or verify privileges.

For information about BMC Capacity Optimization tablespaces and users, see Database requirements.

To manually set up BMC Capacity Optimization database users and tablespaces when installing BMC Capacity Optimization for the first time

If you have Oracle-Managed Files enabled, and you are creating database users and tablespaces, you can download and use the create_users_and_tablespaces.sql example database creation script. For all other situations, you can download, modify, and use the create_users_and_tablespaces_template_filesystem.sql template file to suit your Oracle DB datafile position.


To view the contents of the attached script files, see Contents of create_users_and_tablespaces.sql and Contents of create_users_and_tablespaces_template_filesystem.sql. If needed, modify the database creation script according to your policies. In particular, to modify default database users, roles and tablespace names, edit the first section of the SQL script.