Database server and ojdbc jar support for upgrade Pega 7.1.9 to Pega 8.X
Our details :
Pega upgrade from 7.1.9 to 8.6 | on Premise to On Premise | Pega platform | App server –WebLogic 12.1.3.0 | DB Server – Oracle server 12.1.0.2
As per PLATFORM SUPPORT GUIDE VERSION 8.6 –
- Related to JDBC Drivers , we have noticed that only Ojdbc8.jar was mentioned (there is no mention of Ojdbc7 or Ojdbc6) – so is it safe to assume that none of the Pega versions 8.1 to 8.6 supports Ojdbc7.jar or Ojdbc6.jar ?
- Also it was mentioned that “For Oracle 12c, using the following version can cause synchronization to fail when adding an offline attachment: 12.1.0.2.0. Instead, please use version 12.2.0.1 or later”
That means any of the Pega features would fail if we use Oracle 12.1.0.2.0 for Pega 8.6 or do we need to definitely upgrade to Oracle 12.2.0.1?
- On the same lines, related to Database server - it was mentioned as Oracle12c is supported for Pega versions 8.1 to 8.6.
Can you be specific with exact versions and confirm which all Pega versions support Oracle 12.1.0.2.0 without any issues and for which versions we need to upgrade to Oracle 12.2.0.1?
Any advice/direction would be much appreciated.
Updated: 8 Oct 2021 5:33 EDT
Pegasystems Inc.
US
1. The Oracle JDBC driver numbers correspond roughly to Oracle Java versions. So since Java 6 and Java 7 are not supported by Pega 8.x, the ojdbc8.jar file is recommended.
2. "Driver version 12.2.0.1" in the Guide refers to the JDBC driver version, not the version of the Oracle database itself. Make sure that the driver version of your ojdbc8.jar file is 12.2.0.1 or later.
3. The Oracle 12c database is supported for 8.x. This means that all versions of the Oracle 12c database are supported.
Tech Mahindra Ltd
IN
@STEWS Thanks much !
Quick follow up question - For Pega 8.5 also is it recommended to make sure that the driver version of your ojdbc8.jar file is 12.2.0.1 or later (or) is it only for Pega 8.6?
Tech Mahindra Ltd
IN
@STEWS Hi Susan - Thanks for all your help so far. There has been a confusion related to above posts. Could you please help in clearing the same.
1. As per above statements ojdbc8.jar file itself has 2 versions 12.1.0.2.0 and 12.2.0.1 is that correct ?
2. For Pega 8.x versions is Ojdbc7.jar is not at all supported (or) supported with some limitations (please list the same)?
3. As per above statements all versions of Oracle 12c database are supported in Pega 8.x, but as per oracle documentation
ojdbc8.jar is supported only for Oracle database version 12.2 (12cR2) but not 12.1(12cR1).
That means if Pega 8.x supports only ojdbc8.jar , we have to upgrade our Oracle database also to 12.2 ?
https://www.oracle.com/in/database/technologies/faq-jdbc.html
Pegasystems Inc.
US
You should use the ojdbc8.jar file which is version 12.2.0.1, as we found issues with version 12.1.0.2.
According to the engineers, the ojdbc8.jar file is compatible with both Oracle DB Server 12.1 and 12.2, so you should be able to use it with either database version.
Separate from the JDBC driver – our clients have encountered a number of issues with Pega running on Oracle database version 12cR1; in addition, the extended support for 12cR1 is end-of-life as of Summer 2022. Therefore, the engineers strongly recommend that your client upgrade their database to Oracle database version 12cR2/12.2. This is not required, but it is recommended.