Supported Oracle Client And Database Versions

Products

• CA Business Service Insight

Issue/Introduction

This document discusses supported versions of the Oracle client and server.

Environment

CA Business Service Insight 8.3.5.x

Resolution

Required Version of Oracle Client and Supported Version of Database Server:

Client

Either Oracle client version 11.2.0.4 32-bit (with 11.2.0.4 ODAC 32-bit) must be installed on the App/Web server(s) even if the Oracle database server is a different version.

If you have BSI 8.3.5.3 or higher, you can use Oracle 12.x (32-bit) (with 12.x ODAC 32-bit) for the client.

The Oracle instant client can never be used.

Database Server

With BSI version 8.3.5 we mostly care about the client version. Even if you use 11.2.0.4 (32-bit) for the client, if the database is remote then you can use Oracle 12.x (32 or 64 bit)

If the database is on the same box as the APP and WEB server, then it is recommended to use the same version as the client for simplicity's sake and to prevent problems.

32-bit vs. 64-bit

BSI requires the client software to be 32-bit. The database can be either 32 or 64 bit.

Oracle RAC and ASM

As long as the database is remote, you can use RAC and ASM for Oracle.

However, the BSI installer does not take RAC/ASM into account and you will not be able to use the automated installer for the database.

Instead, you will need to have the DBA create the database (with at least 600 sessions, or more, and persistent connections) and then have them manually run the SQLs called from our main.bat install script.

Additional Information

Database Supportability Matrix