Previous Topic: Before You BeginNext Topic: Installation and Regional Settings

Installation Guide › Performing a Typical Installation › Manually Create a New Database

Manually Create a New Database

This procedure is optional and (if you choose to use it) must be performed before you install any other element (servers or client) of CA Business Service Insight.

Note: This procedure (create database manually) does not use the Cloud_ Insight_Server_8.2.exe file; it uses the Main.bat file (Windows) or the Main.sh File (Unix).

Note: The location of the bat and sh files is in the CA Business Service Insight main installation CD under Server\program files\CA\Cloud Insight\Setup\InstallDB.

Note: This procedure does not install the Application server or the Web server.

Follow these steps:

  1. Edit the parameters in the start_parameter.ini file so that the parameter values you enter are in accord with the Parameter Descriptions.

    Note: Only the parameters listed in the table should be present in the start_parameter.ini file; erase any other parameters.

Parameter

Parameter Description

OBLICORE_ROOT

Desired database location. Setup creates a folder with the database name under this folder. For example: c:\Oblicore.

Note: Create this folder before beginning the installation. The installation setup does not create this folder.

DB_NAME

The database name. Length of name must be less than or equal to eight characters.

ORACLE_HOME

This is the folder where "Oracle Home" is located (in Windows: according to the registry). "Oracle Home" is the location of the Oracle Server software used to create and to run the BSI instance, is not the Oracle Client software used to connect to the instance.

SYS_PASS

SYS user password.

OBLICORE_USER

Name of user-schema where the CA Business Service Insight database objects are to be located.

OBLICORE_PASS

The schema password.

OBLIDBADMIN_PASS 

Administrative database user password.

DB_CHARSET

Select UTF-8 or MSWIN (1252). UTF-8 is recommended.

DB_SYNONYM

Select Public or Private Synonym.
  1. Run the Main file appropriate to your operating system:

    Note: Run the file from within the Setup\InstallDB folder.

  2. Review the parameters indicated in the command line window.
  3. Type Y to start the database creation process.
  4. Click any key, at the prompt, to complete the process.
  5. Check the log file for errors.

    The file's location is shown in the pop-up screen.