Discussion Of Supported Oracle Client And Database Versions
search cancel

Discussion Of Supported Oracle Client And Database Versions

book

Article ID: 20792

calendar_today

Updated On:

Products

CA Business Service Insight

Issue/Introduction

Due to recent document changes regarding oracle versions, this document was created in order to clarify those changes. This document discusses supported versions of the Oracle client and server. It also describes the nature of problems you may see if working in a non-supported version of Oracle.


Environment

CA Business Service Insight 8.3.5

Cause

Due to recent document changes regarding oracle versions, this document was created in order to clarify those changes. This document discusses supported versions of the Oracle client and server. It also describes the nature of problems you may see if working in a non-supported version of Oracle.

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 even if the database server is a different version.

OR, if you apply cumulative patch 3 to the BSI ISO, as instructed in the patch, then 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's recommended to use the same version as the client for simplicity's sake and to prevent problems.

In either case, the database install from our installer will only work with 11.2.0.4 unless you install cumulative patch 3.

With cumulative patch 3 the installer should be able to create the database on Oracle 12.x but in the event you still have a problem,

You can run DBCA to create the DB manually (make sure sessions are increased appropriately for performance, I suggest at least 600) and then remove our dbca call from main.bat and run that from the setupdb folder to complete the DB install.


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 then you can use RAC and ASM for Oracle.

However our 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.