Preparing your database
Your relational database is a critical element for performance and disaster recovery. Consult your DBA, and ensure that your database is configured for high availability and high performance and that database will be backed up regularly. For details on supported versions, see the Supported Platform List for your version of Deployment Automation on the Support website.
Before installing Deployment Automation, you must create an empty database in your DBMS. If you are evaluating Deployment Automation, you can install the database on the same machine that will host the Deployment Automation server. You can optionally use the lightweight Derby database that is provided by the installer for evaluation purposes. If you select the built-in Derby database, you do not need to prepare the database before you run the installer; the database is created as part of the installation.
Create an SQL server database
For SQL Server databases, a clustered configuration is recommended. When you are ready to install the Deployment Automation server, you will need to provide the values you enter here, including the SQL Server connection information and the da user account that has table creation privileges.
For more information, see the Microsoft Documentation.
To create an SQL Server database, run the following commands:
CREATE DATABASE da; USE da; CREATE LOGIN da WITH PASSWORD = 'password'; CREATE USER da FOR LOGIN da WITH DEFAULT_SCHEMA = da; CREATE SCHEMA da AUTHORIZATION da; GRANT BACKUP DATABASE, BACKUP LOG, CREATE DATABASE, CREATE DEFAULT, CREATE FUNCTION, CREATE PROCEDURE, CREATE RULE, CREATE TABLE, CREATE VIEW to da;
Create an Oracle database
For Oracle databases, an architecture based on Oracle RAC is recommended. When you are ready to install the Deployment Automation server, you will need to provide the values you enter here, including the Oracle connection information and the da user account that has table creation privileges.
Use the instructions for your Oracle DBMS version in the following sections.
Oracle 12 and later
To create a database in Oracle 12 or later, run the following commands:
ALTER SESSION SET "_ORACLE_SCRIPT"=true; CREATE USER da IDENTIFIED by password; GRANT CONNECT TO da; GRANT RESOURCE TO da; GRANT UNLIMITED TABLESPACE TO da;
Oracle 10g or 11g
To create a database in Oracle 10g or 11g, run the following commands:
CREATE USER da IDENTIFIED by da; GRANT CONNECT TO da; GRANT RESOURCE TO da;
Create a PostgreSQL database
To create a PostgreSQL database, run the following commands:
CREATE DATABASE db_name OWNER = role_name TEMPLATE = template ENCODING = encoding LC_COLLATE = collate LC_CTYPE = ctype TABLESPACE = tablespace_name CONNECTION LIMIT = max_concurrent_connection