Business Intelligence (BI) Interface Guide › Creating Target Database Using DB Installer Tool

Creating Target Database Using DB Installer Tool

Note: This section is only relevant when configuring the BI Interface for installation on two separate databases.

To create the CA Business Service Insight target database using the CA Business Service Insight DB Installer tool:

1. Copy the InstallDB folder from the CA Business Service Insight package /SetupDB folder.
2. Edit the start_parameters.ini file according to the start_parameters_readme.txt file.
3. Run the Main.bat file (for Windows) or Main.sh (for Unix).
4. Recreate the CA Business Service Insight user as follows:

   DROP USER OBLICORE CASCADE;
   
   CREATE USER OBLICORE
   IDENTIFIED BY OBLICORE
   DEFAULT TABLESPACE TBS_SLA_DATA_01
   TEMPORARY TABLESPACE TEMP
   ACCOUNT UNLOCK
   /
   GRANT  ALTER SESSION TO OBLICORE
   /
   GRANT  CONNECT TO OBLICORE
   /
   GRANT  CREATE DATABASE LINK TO OBLICORE
   /
   GRANT  CREATE PROCEDURE TO OBLICORE
   /
   GRANT  CREATE PUBLIC SYNONYM TO OBLICORE
   /
   GRANT  CREATE SEQUENCE TO OBLICORE
   /
   GRANT  CREATE SYNONYM TO OBLICORE
   /
   GRANT  CREATE TABLE TO OBLICORE
   /
   GRANT  CREATE TRIGGER TO OBLICORE
   /
   GRANT  CREATE TYPE TO OBLICORE
   /
   GRANT  CREATE VIEW TO OBLICORE
   /
   GRANT  DROP PUBLIC SYNONYM TO OBLICORE
   /
   GRANT  EXECUTE ANY PROCEDURE TO OBLICORE
   /
   GRANT  EXECUTE ON DBMS_LOCK TO OBLICORE
   /
   GRANT  SELECT ON V_$SESSION TO OBLICORE
   /
   GRANT  SELECT ANY TABLE TO OBLICORE
   /
   GRANT  UNLIMITED TABLESPACE TO OBLICORE
   /
   GRANT SELECT ANY DICTIONARY TO OBLICORE
   /