System Requirements › Preinstalled Database

Preinstalled Database

CA Configuration Automation uses a relational database to store blueprint and application-related data. You can create the database within your existing Oracle or Microsoft SQL Server environment. The requirements are as follows:

• The licensed database software is installed before you run the CA Configuration Automation Server installation program.
• You can create the database instance and administrative user during CCA Server installation.
• Ensure the user performing the installation or upgrade has the following database user rights:

  Microsoft SQL Server User Rights

  • Minimum install rights: dbcreator
  • Minimum user rights: db_owner

  Oracle User Rights

  The user needs to be granted quota space for the tablespaces. If the user is assigned the RESOURCE role, the user has unlimited tablespace. If the RESOURCE role is not assigned, the user must have quota space assigned using the alter command as follows:

  alter user cca quota unlimited on CCADATA; 
  alter user cca quota unlimited on CCAINDEX; 
  

  The following privileges are required:

  • CREATE PROCEDURE
  • CREATE SEQUENCE
  • CREATE SESSION
  • CREATE TABLE
  • CREATE TRIGGER
  • CREATE VIEW

Regardless of the database type, you need to provide the following database-related details to connect with and create or update the database schema during CCA Server installation:

• CCA Database user name
• CCA Database password
• Database server name
• Database name (if you are using Microsoft SQL Server) or Oracle Service name (if you are using an Oracle database)
• If you choose to create the database user during CA Configuration Automation Server installation, you need to provide the user name and password of the administrator authorized to create the database instance