New Installation › UNIX › Perform a New Installation › Configure the New CMS › Specify a System Database Option › 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 will then have to configure the database.

To select and configure the database

1. Select your database type. You can choose from the following
   • 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 required for each database type is as follows:

   MySQL

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

   Oracle

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

   DB2

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

   Sybase

   • Sybase Service name
   • User ID for CMS database
   • Password for 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, you must also provide the Auditing database port number.

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

   Important! Reinitialization of the BusinessObjects Enterprise database erases all previous content in that particular database.

   After configuring 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 the CMS can access it after a system reboot. This can be done one of two ways:

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

  <INSTALLDIR>/bobje/init/BobjEnterprise120

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

• Each user can modify their own profile and add the command to source their database environment. This method must be done by each user.

More information:

Central Management Server Database Requirements and Preparation