New Installation › UNIX › Perform a New Installation › Configure the New CMS › Configure an Existing Database

Configure an Existing Database

If you specified to use an existing database for the CMS, use the Select the database type for your new CMS screen to select your existing database type. You then configure the database.

To select and configure the database

1. Select your database type from the following options:
   • SQL Anywhere
   • MySQL
   • Oracle
   • DB2
   • Sybase

   A new screen displays containing fields for configuring your database.

2. Provide information about your database and press Enter.

   The information that is required for each database type is as follows:

   SQL Anywhere

   • Host Name
   • User ID for the CMS database
   • Password for the CMS database
   • SQL Anywhere port number
   • Database name for CMS
   • Data Source Name

   MySQL

   • Host Name
   • User ID for the CMS database
   • Password for the CMS database
   • MySQL port number
   • Database name for CMS

   Oracle

   • TNS name
   • User ID for the CMS database
   • Password for the CMS database
   • CMS port number

   DB2

   • Alias name
   • User ID for the CMS database
   • Password for the CMS database

   Sybase

   • Sybase Service name
   • User ID for the CMS database
   • Password for the CMS database

3. To enable an auditing database, type an x in the field provided.

   Provide information about your new auditing database.

   Auditing

   • Auditing database name
   • User ID
   • Password

   Note: If you are using Sybase as the auditing database, provide the Auditing database port number.

4. Decide if you want to reinitialize the database and press Enter.

   Important! Re-initialization of the BusinessObjects Enterprise database erases all previous content in that particular database.

   After you configure your CMS and auditing database, you are prompted for information about the Server Intelligence Agent.

If you are using an existing database, you must source your database environment variable so that the CMS can access the variable after a system reboot. You can perform this action in one of two ways:

• Someone with root access can modify the BusinessObjects Enterprise script BobjEnterprise120 and can add the command to source your database environment. This script can be found at the following location:

  <INSTALLDIR>/bobje/setup/env.sh

  This method will source the database environment variable for all users.

• Users can modify their own profiles and can add the command to source their database environment. Each user performs this method.

More information:

Central Management Server Database Requirements and Preparation