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 Proprietary information hidden | DB Server – Oracle server Proprietary information hidden
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: Proprietary information hidden.0. Instead, please use version Proprietary information hidden or later”
That means any of the Pega features would fail if we use Oracle Proprietary information hidden.0 for Pega 8.6 or do we need to definitely upgrade to Oracle Proprietary information hidden?
- 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 Proprietary information hidden.0 without any issues and for which versions we need to upgrade to Oracle Proprietary information hidden?
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 Proprietary information hidden" 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 Proprietary information hidden 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
CA
@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 Proprietary information hidden or later (or) is it only for Pega 8.6?
Tech Mahindra Ltd
CA
@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 Proprietary information hidden.0 and Proprietary information hidden 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 Proprietary information hidden, as we found issues with version Proprietary information hidden.
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.