Database Installation

Install Oracle or PostgreSQL database software for Identity Management runtime data and for reporting data.

PostgreSQL

You can download the PostgreSQL software from http://www.postgresql.org/
Install the PostgreSQL client (postgresql-8.4.7-2.el6.x86_64) on the systems with the SiteMinder Policy Server and the Identity Management server.
Install SQLAnywhere as the runtime database for reporting.
For Business Objects, use the CA Business Intelligence Installation Guide to perform a custom installation and choose SQLAnywhere for the Business Objects(CMS and the Audit database).

Oracle

You can purchase the software from Oracle.
All customers should install CABI 3.2 SP2 with the patch.
Customers can upgrade to CA CloudMinder 1.53 and continue to use Oracle 11g
Important! CA Technologies has not tested migrating an existing and deployed CA CloudMinder Oracle 11g database to Oracle 12c. As a precaution, we recommend doing a fresh installation of CA CloudMinder when you intend to start using Oracle 12c.
Configure the database with all services (such as listener and DB) running.
For good performance, the Oracle database requires the following settings:
- Sessions=772
- Processes=500
Configure the Oracle database with a UTF-8 encoded character set. If you plan to enable Advanced Authentication for your environment, install the AL32UTF8 Oracle database character set.
Create an Oracle user with the username CamAdmin and privileges to create tablespaces and users. Assign the CamAdmin user the DBA and Connect roles in Oracle. The CamAdmin user is used to create other base CA CloudMinder system users. Make a note of the password for CamAdmin for later use during installation.
If you plan to install CA Business Intelligence for reporting, install and configure an additional logical database to house reporting data; install the new database on the same Oracle RAC server as the runtime database.