Previous Topic: Prepare the Enterprise Management Server on LinuxNext Topic: Central Database Script Deployment Examples


Prepare the Central Database for Enterprise Management

CA ControlMinder Enterprise Management requires a relational database management system (RDBMS). Set this up before you install CA ControlMinder Enterprise Management.

You have two options for setting up your database to work with CA ControlMinder Enterprise Management:

Follow these steps:

  1. If you do not already have one, install a supported RDBMS as the central database.

    Note: For a list of supported RDBMS software, see the Release Notes.

  2. Configure the RDBMS for CA ControlMinder Enterprise Management:

    Verify that the database can be accessed locally and from a remote client.

    1. Create a user for the central database. This user must have the following permissions and settings:
      • System Privileges: ADMINISTER DATABASE TRIGGER, ALTER SESSION, CREATE CLUSTER, CREATE DATABASE LINK, CREATE SEQUENCE, CREATE SESSION, CREATE SYNONYM, CREATE TABLE, CREATE VIEW, CREATE ANY INDEXTYPE, CREATE OPERATOR, CREATE PROCEDURE, CREATE TRIGGER, CREATE TYPE, EXECUTE ON SYS.DBMS_CRYPTO, SELECT ANY DICTIONARY, UNLIMITED TABLESPACE
    2. Enter the following commands to increase the number of connections to the database:
      ALTER SYSTEM SET transactions=275 SCOPE=SPFILE
      
      ALTER SYSTEM SET sessions=250 SCOPE=SPFILE
      
      ALTER SYSTEM SET processes=200 SCOPE=SPFILE
      
  3. (Optional) Prepopulate the central database using the deployment scripts CA ControlMinder provides.
    1. Insert the appropriate CA ControlMinder Server Components DVD for your operating system into your optical disc drive.
    2. Copy the deployment script for your RDBMS to a temporary local folder.

      By default, the database deployment scripts are on the optical media at the following location:

      • Oracle: /Schema/oracle_database_deployment_script.sql
      • SQL Server: /Schema/mssql_database_deployment_script.sql
    3. Deploy the deployment scripts.
    4. Configure the database user that you use for the CA ControlMinder Enterprise Management installation.
      • For Oracle, keep the ALTER SESSION, CREATE SESSION, EXECUTE ON SYS.DBMS_CRYPTO, and SELECT ANY DICTIONARY system privileges for the user you created.
      • For SQL Server, create a user, select the database that you created earlier as the default, map the user to the database, and set the following permissions: CONNECT.SELECT, INSERT, DELETE, UPDATE, EXECUTE.
    5. Reset the predefined user account passwords. Follow these steps:
      1. Login to CA ControlMinder Enterprise Management as a user with administrative privileges.
      2. Select Users and Groups, Users, Reset User Password.

        The Reset User Password screen opens.

      3. Type in a search query to display all available users and select Search.

        CA ControlMinder Enterprise Management displays the following user accounts: [default user], superadmin, neteautoadmin, selfreguser

      4. Do the following for each account:

        Select a user account and click Select.

        The reset password window opens.

        Type in the account password in the Confirm Password field.

        (Optional) Select the Password Must Change option and click Submit.

        CA ControlMinder Enterprise Management resets the account password.