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:

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

Follow these steps:

Download the media from the CA Support website (support.ca.com).
Unzip the media.
Burn the file to CD or open it as a cd so that the integrity of the text files is 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.
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 UNIX.

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

Open the PostCreateInstance.sh file.

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

Appendix A

This section documents the manual fix for Linux / Unix environments.

Open alter_system_large.sql and run each line manually in sqlplus, as sysdba (with an updated version of this script, it can be run normally; the following code constitutes the workaround).

oracle@iscladoral:u03/oblicore/CAOblicoreGuarantee/Setup/InstallDB/Build_DB> more alter_system_large.sql
connect sys/&l as sysdba

set echo on

alter system set "_adjust_literal_replacement"=true scope=spfile;
alter system set sga_target=629145600 scope=spfile;
alter system set pga_aggregate_target=209715200 scope=spfile;

shutdown immediate;
startup;

exit;
oracle@iscladoral:/u03/oblicore/CAOblicoreGuarantee/Setup/InstallDB/Build_DB>

oracle@iscladoral:u03/oradata/oblicore/oblicoredb/database/dbf> sqlplus sys/sys@oblicore as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Tue Mar 29 09:02:56 2011
Copyright (c) 1982, 2007, Oracle All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> set echo on
SQL> alter system set "_adjust_literal_repalcement"=true scope=spfile;

System altered.

SQL> alter system set sga_target=629145600 scope=spfile;

System altered.

SQL> alter system set pga_aggregate_target=209715200 scope=spfile;

System altered.

SQL> shutdown immediate;

SQL> startup
ORACLE instance started.
Total System Global Area 629145600 bytes
Fixed Size                 2086000 bytes    
Variable Size             16777510 bytes
Database Buffers          452984831 bytes
Redo Buffers                6299648 bytes
Database mounted.
Database opened.
SQL>

Installation

Installation

Enter the following command:

cd /u03/oblicore/CA_Oblicore_Guarantee/Setup/InstallDB

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

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 8.2.5 From Scratch/Typical Installation.
Please make your selection [1/2]

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.

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

Review the chosen parameters and click Y if they are correct.
The system creates the database.
A success message displays upon completion:
```
The installation process ended successfully .....
```

Additional Client Installation

Test logging in to the new DB as sys.
Link the sp file to the $ORACLE_HOME/dbs dir

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

export ORACLE_SID=oblicore
sqlplus sys/sys as sysdba
startup