Installation Guide › Installing CA Business Service Insight Database on Linux Servers

Installing CA Business Service Insight Database on Linux Servers

This section describes installation of a CA Business Service Insight database on Linux servers.

This section contains the following topics:

Linux Installation

Linux Installation

This section describes how to install a CA Business Service Insight database on a Linux system.

Note: Before you install the database on Linux, connect to oracle user in the O/S level (do not run main.sh from user root).

Download Media to DB Server

Download Media to DB Server

1. Download the media from the CA Support website (support.ca.com).
2. Unzip the media.
3. Burn the file to CD or open it as a cd so that the integrity of the text files in not corrupted.
   1. Alternatively, copy the ISO to the Linux server and use the command mount –o loop to ensure integrity, or:
   2. Transfer the folder Server\program files\CA\Cloud Insight\Setup\InstallDB from the main installation CD using a proper ftp or SCP tool to copy from Windows to Linux.
4. Use binary ftp to transfer the media to the Linux DB server.

   Note: If you cannot use binary ftp for the transfer, convert the files to Linux/UNIX.

TNSNames Setup

1. Update the file tnsnames.ora with an entry for the database and sid being used (oblicore).

Setup

File conversion [Optional]

If files were not transferred in binary version, convert the required files to Unix.

cd /u03/oblicore/CA_Oblicore_Guarantee

  dos2unix Setup/InstallDB/Main.sh
  dos2unix Setup/InstallDB/start_parameters.ini 
  dos2unix Setup/InstallDB/Build_Schema/schema_build.sh
  dos2unix Setup/InstallDB/Build_DB/makedir.sh
  dos2unix Setup/InstallDB/Build_DB/CreateInstance.sh
  dos2unix Setup/InstallDB/Build_DB/PostCreateInstance.sh 
  dos2unix Setup/InstallDB/Build_TBS_Users/tbs_users_build.sh

File permission update

Set execute permission on .sh files.

find . -name "*.sh" | xargs -n1 chmod u+x

Install Sub-script fix

Install Sub-script fix

cd /u03/oblicore/CA_Oblicore_Guarantee/Setup/InstallDB/Build_DB

1. Open the PostCreateInstance.sh file.
2. Replace these lines in the PostCreateInstance.sh file:

   If [$ORACLE_VERSION = 9 ]
   then SQL_FILE=alter_system_large_9.sql
   else SQL_FILE=alter_system_large_10_11.sql
   
   

   with the following lines:

   If [ $ORACLE_VERSION = “9” ]
   then SQL_FILE=alter_system_large.sql
   else SQL_FILE=alter_system_large.sql
   

Installation

Installation

1. Log in and become oracle.

   Note: Specific steps depend upon your Linux/Unix installation "flavor".

2. Enter the following command:

   cd /u03/oblicore/CA_Oblicore_Guarantee/Setup/InstallDB
   

   1. Edit the start_parameters.ini file (see below for Client dev actual).

      [DataBaseDetailes]
      OBLICORE_ROOT=/u03/oradata
      ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1
      SYS_PASS=sys
      OBLICORE_USER=oblicore
      OBLICORE_PASS=oblicore
      DB_CHARSET=utf8
      DB_SYNONYM=public
      

   Note: CERT ORACLE_HOME=c:\oracle\product\11.1.0\db_1

3. Run the command:

   /u03/oblicore/CA_Oblicore_Guarantee/Setup/InstallDB/Main.sh 
   

   Answer the resulting prompt:

   Please select the characterset to be used in your databse:
   1. UTF8     (AL21UTF8)
   2. PUBLIC  (WE8MSWIN1252)
   For more information about selecting the character set, please see 
   the Installation Document, Oblicore Server Installation/Installing OG [assign the version number for your book] From Scratch/Typical Installation.
   Please make your selection [1/2]
   

4. Select: 1. UTF8

   Answer the resulting prompt:

   Please select type of synonyms to be used in your database:
   1.PUBLIC
   2.PRIVATE
   For more information about selecting private or public synonyms, please see the Installation Document, Installing OG 7.0 From Scratch/Typical Installation.
   

5. Select:1 PUBLIC

   The following parameters display.

   CHARATER_SET
   OBLICORE_ROOT
   ORACLE_HOME
   ORACLE_VERSION
   DB_NAME
   DB_SIZE
   SYS_PASS
   OBLICORE_USER
   OBLICORE_PASS
   SYNONYMS_TYPE
   

6. Review the chosen parameters and click Y if they are correct.
7. The system creates the database.

   A success message displays upon completion:

   The installation process ended successfully .....
   

Additional Client Installation

1. Test logging in to the new DB as sys.
2. Link the sp file to the $ORACLE_HOME/dbs dir
3. Link from /u03/oradata/oblicore/oblicoredb/admin/spfile/spfileoblicore.ora

   cd $ORACLE_HOME/dbs
   ln -s /u03/oradata/oblicore/oblicoredb/admin/spfile/spfileoblicore.ora ./spfileoblicore.ora
   restart database.
   export ORACLE_SID=oblicore
   sqlplus sys/sys as sysdba
   startup
   

Restart Database

1. export ORACLE_SID=oblicore
2. sqlplus sys/sys as sysdba
3. startup