Previous Topic: Typical Installation From ScratchNext Topic: Create a New Database Manually


Before You Begin

Important: In 1-tier installations, Windows, Oracle Server, and Oracle client must be 32-bit. Do not use any 64-bit version of the applications. Oracle Server must be version 11.2.0.3.

3rdPartyCD

Before you install CA Business Service Insight, download the folder named "CA Business Service Insight" and the folder named "CA Business Service Insight - Third Party". During installation, a message displays. Enter the location of the appropriate folder to download files that you need for proper installation of the product.

The folder "CA Business Service Insight - Third Party" contains files for third party products used with CA Business Service Insight.

Follow these steps:

  1. Log in to Support (support.ca.com).
  2. Go to the Download Center link (on the left).
  3. Enter the Product: CA Business Service Insight - WINDOWS-ALL.
  4. Select the version.

    All available files for download display.

  5. Download the required folders and record the location of each for later use.

Stop Services

Verify that you have stopped all the services mentioned in the instructions in the section Before You Begin.

Installation and Regional Settings

In some cases, regional language settings other than English sometimes change certain installation commands and disrupts the installation.

When your regional language setting is not English you must temporarily change your regional settings to English (USA) and adhere to the following installation sequence.

  1. Before installing CA Business Service Insight, change your regional settings to English (USA).
  2. Install according to the procedures described in this Guide.
  3. Reboot.
  4. Revert to your local regional settings.
  5. Reboot.
  6. Use CA Business Service Insight

Installing on more than one server

When installing on more than one server:

  1. Go to the web server; set the Distributed Transaction Coordinator service to Start.
  2. Go to the web server; set the World Wide Web Publishing service to Start.
  3. Install and configure the Oracle client and the database connection configuration components correctly (for example, TNSnames.ora, listener.ora) so you can establish a connection to the database through OLEDB.
    1. Install and configure TNSnames.ora on all servers
    2. Install and configure Listener.ora on the Database server

Application and Web servers

  1. Make sure the local naming configuration file ($ORACLE_HOME\network\admin\TNSNAMES.ORA) contains the service alias, with the correct host name and the correct port (default 1521).

Note: See the example TNSNAMES.ORA file, below.

DB Server

  1. Make sure that the listener configuration file ($ORACLE_HOME\network\admin\LISTENER.ORA) is configured correctly and that it recognizes the instance to be created (See the example LISTENER.ORA file, below).
  2. Run the following command from the command line
    lsnrctl status 
    

    A list of services summary is displayed. The following message displays.

  3. If the message does not appear, run the following command:
    lsnrctl start 
    

    The following message appears:

  4. Verify that the file ($ORACLE_HOME\network\admin\SQLNET.ORA) contains the line:
    SQLNET.AUTHENTICATION_SERVICES = (NTS)
    
  5. Test communication between the Oracle client and the Listener.
    1. Run the following command from the command line:
      	Tnsping  <tns_entry_name>
      

    The system responds with "OK" followed by the response time.

TSNAMES.ORA File
OBLICORE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = server12.ca.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = oblicore)
    )
  )
LISTENER.ORA File
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = OBLICORE)
      (ORACLE_HOME = C:\app\Administrator\product\11.2.0\dbhome_1)
      (SID_NAME = oblicore)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = server12.ca.com)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )