Installation Guide › Performing a Typical Installation › Installation and Regional Settings

Installation and Regional Settings

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

Follow these steps:

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

Follow these steps:

1. Go to the web server; set the Distributed Transaction Coordinator service to Start.
2. Set the World Wide Web Publishing service to Start.
3. Install and configure the Oracle client and the database connection configuration components correctly to 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).

DB Server

Follow these steps:

1. Verify 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. Open a command-prompt window and run the following command.

   lsnrctl status 
   

   • A list of services summary is displayed.
3. If a message does not appear, run the following command:

   lsnrctl start 
   

   The message appears informing you that the command completed successfully

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.

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))
    )
  )

TSNAMES.ORA File

OBLICORE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = server12.ca.com)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = oblicore)
    )
  )