Manually Create the Database

CA Business Service Insight Installation Guide › How to Install CA Business Service Insight › Manually Create the Database

Manually Create the Database

To set up the CA Business Service Insight database on a non-Windows server, manually create the database.

If you are not planning on using the CA default configuration, print The CA Technologies Naming Conventions Policy for Database Objects. Complete the form and consult CA Support before the installation if your database naming convention differs from the CA Technologies policy.

Follow these steps:

Locate installation file on the installation CD in Server\program files\CA\Cloud Insight\Setup\InstallDB, and copy the file to %OBLICORE_ROOT%\Setup\InstallDB:
- (Windows) Main.bat
- (Unix) Main.sh
Update the parameters in start_parameter.ini locate in %OBLICORE_ROOT%\Setup\InstallDB:

OBLICORE_ROOT

Specifies a location for the database where the setup creates a folder with the database name.

Important! Create the root folder before you run the database creation script.

DB_NAME

Specifies the name of the database instance.

Limit: 1-8 characters

ORACLE_HOME

Specifies the location of Oracle Home.

Note: If the server has multiple homes, use the home that references an Oracle server installation and not a client installation.

SYS_PASS

Specifies the SYS user password.

OBLICORE_USER

Specifies the name of the schema user that holds the CA Business Service Insight database entities.

OBLICORE_PASS

Specifies the password of the schema user.

OBLIDBADMIN_PASS

Specifies the password of the Oracle user oblidbadmin that is used during database installation and migrations.

DB_CHARSET

Specifies the database character set, UTF-8 or MSWIN1252.

DB_SYNONYM

Specifies public or private synonym.

Example:
```
[DataBaseDetailes]
OBLICORE_ROOT=c:\oblicore
DB_NAME=oblicore
ORACLE_HOME=c:\oracle\product\11.1.0\db_1
SYS_PASS=sys
OBLICORE_USER=oblicore
OBLICORE_PASS=oblicore
OBLIDBADMIN_PASS=oblidbadmin
DB_CHARSET=utf8
DB_SYNONYM=public
```
Run the script.
Verify that the parameters are correct.
Follow the on-screen instructions.
Check the log file for errors.
The database is set up and you can install the CA Business Service Insight servers.