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.
To use a PostgreSQL database for reporting, install SQLAnywhere for the Business Objects CMS and the audit database.
For Business Objects, use the CA Business Intelligence Installation Guide to perform a custom installation and choose SQLAnywhere.

Oracle

You can purchase the software from Oracle. Install an Oracle 11g database.
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. This 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 Oracle 11g database to house reporting data.