Manually Create the Database

Prepare the database for the  system. This procedure describes a standard Oracle server configuration and provides and example. For more information, see the Oracle documentation or contact Oracle for assistance.
bsi83
Prepare the database for the
CA Business Service Insights
system. This procedure describes a standard Oracle server configuration and provides and example. For more information, see the Oracle documentation or contact Oracle for assistance.
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 default.
Follow these Steps:
  1. Locate the installation file on the installation CD in Server\program files\CA\Cloud Insight\Setup\InstallDB, and copy the directory contains to:
    • (Windows) %OBLICORE_ROOT%\Setup\InstallDB
    • (Unix) Linux File System:/Software
      Do not include & or . in the installation directory name.
  2. Edit start_parameter.ini file that is located in the InstallDB directory. Update the following parameters:
    • OBLICORE_ROOT
      Specifies a location for the database where the setup creates a folder with the database name.
      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.
      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 Insights
      database entities.
      If you change the user name, the BRV does not function.
    • 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 for Windows:
    [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
    Example for Linux/Unix:
    [DataBaseDetailes]
    OBLICORE_ROOT=/oracle/Oblicore
    DB_NAME=OBLICORE
    ORACLE_HOME=/opt/oracle/product/11.2.0/dbhome_1
    SYS_PASS=sys
    OBLICORE_USER=oblicore
    OBLICORE_PASS=oblicore
    OBLIDBADMIN_PASS=oblidbadmin
    DB_CHARSET=utf8
    DB_SYNONYM=public
  3. In Unix/Linux server you may need to change the scripts format and add permissions, before running the script. For more information, see Prepare Unix/Linux Directory for the Installation.
  4. Run the script:
    1. (Windows) Main.bat
    2. (Unix) Main.sh
  5. Verify that the parameters are correct.
  6. Follow the on-screen instructions.
  7. Check the log file for errors.
    The database is set up and you can install the
    CA Business Service Insights
    servers.
Prepare Unix/Linux Directory for the Installation
To prepare the directory for installation, perform the following tasks.
Follow these steps:
  1. Copy the directory SetupDB from \Server\program files\CA\Cloud insight\ on the installation CD to the Linux File System:/Software.
  2. Execute the following commands:
    • Create the directory for the logs:
      Mkdir - p /Software/SetupDB/InstallDB/Log
    • Grant the Oracle user permissions to access the installation script files:
      Chown - R oracle:oinstall /Software/SetupDB
  3. Convert the file from dOS format to UNIX:
    1. Create BSI-conv.sh in /InstallDB.
    2. Copy the following code
      #!/bin/bash
      dos2unix_recursive()
      {
      for file in "$1"/*; do
      if [ ! -d "$file" ] ; then
      if [ ! -L "$file" ] ; then
      echo Convert $file to Unix format...
      dos2unix $file $file
      fi
      else
      if [ ! -L "$file" ] ; then
      dos2unix_recursive $file
      fi
      fi
      done
      }
      dos2unix_recursive "$PWD"
      chmod -R +rx *.sh
    3. Run the bat file.
  4. Verify that the directory /oracle/oblicore exists. If it does not exist, create it.