Pega upgrade from 7.1.9 to 8.5 | Weblogic | jdbc driver jar path
Our details: We are working on a pega upgrade
Pega upgrade from 7.1.9 to 8.5 | on Premise to On Premise | Pega platform | App server –WebLogic Proprietary information hidden | DB Server – Oracle server Proprietary information hidden
Any help/advices on below questions would be highly appreciated.
1. In setupDatabase.properties, we need to provide path for pega.jdbc.driver.jar, could you please suggest in WebLogic app server where do we find this jar typically ? (exact path) and any examples for the same please
2. When we try to find ojdbc jar in the directory , we found this at 3 places as below. Which one do you think we need to use in the setupDatabase.properties ?
- /opt/bns/pef /usr/lib/rda/da/lib/ojdbc14.jar
- /opt/bns/pega/apps/weblogic Proprietary information hidden.0/Oracle/Middleware/Oracle_Home/Oracle_common/rda_20210115/da/lib/ojdbc14.jar
- /opt/bns/pega/apps2/weblogic Proprietary information hidden.0/Oracle/Middleware/Oracle_Home/Oracle_common/rda_20210115/da/lib/ojdbc14.jar
Our environment has 1 server and 2 JVMs running in 2 different paths.
3. Can the actual Java and this jdbc driver jar path be at 2 different path?
Pegasystems Inc.
IN
1. In setupDatabase.properties, we need to provide path for pega.jdbc.driver.jar, could you please suggest in WebLogic app server where do we find this jar typically ? (exact path) and any examples for the same please
--> Pega upgrade is run as with standalone JVM, so the jdbc driver jar, should be accessible ( with execute permission) from the location where you will initiate upgrade command.
2. When we try to find ojdbc jar in the directory , we found this at 3 places as below. Which one do you think we need to use in the setupDatabase.properties ?
---> You can use any one of these or a new one as well. However the user which triggers the upgrade, should have access to the jdbc jar and execute permissions.
3. Can the actual Java and this jdbc driver jar path be at 2 different path?
--> Yes, JAVA_HOME environment variable to be set for java. In setupDatabase.properties, set pega.jdbc.driver.jar, for JDBC jar.