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 Platform Matrix link for your version of Deployment Automation on the Serena Support product download page.

Before you install 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.

For details on creating a database for production, refer to one of the corresponding sections below.

Creating a 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 serena_ra user account that has table creation privileges.

To create the SQL Server database, execute the following command:

CREATE DATABASE serena_ra;
USE serena_ra;
CREATE LOGIN serena_ra WITH PASSWORD = 'password';
CREATE USER serena_ra FOR LOGIN serena_ra WITH DEFAULT_SCHEMA =
serena_ra;
CREATE SCHEMA serena_ra AUTHORIZATION serena_ra;
GRANT ALL TO serena_ra;

Note: You will receive a warning because of using the GRANT ALL option in this command. You can safely ignore the warning. GRANT ALL does not grant all possible permissions, but it does grant the subset of privileges needed by Deployment Automation. For more information, see http://technet.microsoft.com/en-us/sqlserver/default.

Creating 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 serena_ra user account that has table creation privileges.

Use the instructions for your Oracle DBMS version in the following sections.

Oracle 12 and Higher

To create the database in Oracle 12 or higher, execute the following commands:

ALTER SESSION SET "_ORACLE_SCRIPT"=true;
CREATE USER serena_ra IDENTIFIED by serena_password;
GRANT CONNECT TO serena_ra;
GRANT RESOURCE TO serena_ra;
GRANT UNLIMITED TABLESPACE TO serena_ra;

Oracle 10g or 11g

To create the Oracle 10g or 11g database, execute the following commands:

CREATE USER serena_ra IDENTIFIED by serena_ra;
GRANT CONNECT TO serena_ra;
GRANT RESOURCE TO serena_ra;