Preparing to install without a sysdba password
If you do not have a sysdba password, you will need to manually set up the database users and tablespaces before you install the product.
Note
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 you install TrueSight 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 TrueSight 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 TrueSight Capacity Optimization, complete the following steps:
- Create or migrate tablespaces.
- Create or migrate users.
- Grant or verify privileges.
For information about TrueSight Capacity Optimization tablespaces and users, see Database requirements.
To manually set up database users and tablespaces when installing the product
If you have Oracle-Managed Files enabled, and you are creating database users and tablespaces, you can use the create_users_and_tablespaces.sql
example database creation script. For all other situations, you can download and modify the create_users_and_tablespaces_template_filesystem.sql
template file to suit your Oracle DB datafile position.
Note
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.
Comments
In the 2 SQL scripts we have some differences.
We don't list the permission for this role: SELECT_CATALOG_ROLE
We list the permission SELECT_CATALOG_ROLE
I think this permission belongs to all scripts, and not only to the second.
Log in or register to comment.