Prerequisites

General Prerequisites

Create an empty database which will play the role of the CA Business Service Insight target database. This database can be created using:
1. Oracle scripts. The tablespaces that should be created are:
  - TBS_CSL_DATA_TAB_01
  - TBS_CSL_INDEX_TAB_01
  - TBS_DASH_DATA_01
  - TBS_DASH_INDEX_01
  - TBS_LOB_DATA_01
  - TBS_OBL_DATA_01
  - TBS_OBL_INDEX_01
  - TBS_PSL_DATA_TAB_02
  - TBS_PSL_INDEX_TAB_02
  - TBS_SLA_DATA_01
  - TBS_SLA_DATA_02
  - TBS_SLA_INDEX_01
  - TBS_SLA_INDEX_02
2. CA Business Service Insight DB Installer tool. For more information, see Creating Target Database Using DB Installer Tool.
If the CA Business Service Insight source and CA Business Service Insight target databases are not the same Oracle version, set or add the compatible parameter in the init.ora file on the higher database to the lower version number.

Example:

The CA Business Service Insight source database is version 10 and the CA Business Service Insight target database is 9.
In the init.ora file on the CA Business Service Insight source database set up the compatible parameter to equal 9.0.0.
Verify you have enough disk space (approximately 30% of the source database size) on the machine you are working from (CA Business Service Insight source database or the BI Installation machine) for the dump file.
Verify that the machine you are working from (CA Business Service Insight source database or the BI Installation machine) has Java Runtime Environment, version 1.5 or later, installed on it. This is required so that the batch files for installing the replication environment can be executed. Additional information on how to install and set up the Java Runtime environment can be found at the Java web site.
Verify you have a connection from the machine you are working from (CA Business Service Insight source database or the BI Installation machine) to the CA Business Service Insight source and CA Business Service Insight target databases for sys user (e.g. sys/sys as sysdba) and check for proper connectivity to this instance using SQLPLUS (e.g. conn sys/sys@<DBNAME>).

CA Business Service Insight Source Database Prerequisites

Verify the CA Business Service Insight source database is connected to the CA Business Service Insight target database. To verify:
- In the tnsnames.ora file on the CA Business Service Insight source database, define a connection to the CA Business Service Insight target database.
- From the CA Business Service Insight source database use SQLPLUS and try to connect to the CA Business Service Insight target database (e.g. conn sys/sys@<DBNAME>).
Stop all CA Business Service Insight services if any exist. Verify that there is no mechanism that can start them up automatically.
Set the CA Business Service Insight source database to archive log mode. For more information, see Setting CA Business Service Insight Source Database to Archive Log Mode.
In the init.ora file on the CA Business Service Insight source database, set up the following parameters:
- AQ_TM_PROCESSES = 1
- JOB_QUEUE_PROCESSES = 2 or more
- _FIRST_SPARE_PARAMETER = 50
For Oracle10, set up the SGA_TARGET parameter to 800MB or more.
For Oracle9, double the size of the shared_pool_size parameter, but make sure it is not less than 400MB.

Note: CA recommends that the Streams operation have 200MB allocated to the streams pool.

CA Business Service Insight Target Database Prerequisites

In the init.ora file on the CA Business Service Insight target database, set up the following parameters:
- AQ_TM_PROCESSES = 1
- JOB_QUEUE_PROCESSES = 2 or more
- _FIRST_SPARE_PARAMETER = 50
For Oracle10, set up the SGA_TARGET parameter to 600MB or more
For Oracle9, double the size of the shared_pool_size parameter, but make sure it is not less than 400MB
Note: CA recommends that the Streams operation have 200 MB allocated to the streams pool.