Java Post Steps in SAP after Oracle Upgrade
If you are running with Dual Stack and You have recently upgrade Oracle to new version then Java will not come ,You’ll have to do some additional steps pointing to correct oracle client version and correct rdbms.driverLocation.Please follow below steps after oracle upgrade for Java:
Change the file config.properties as follows:
1) Change to the correct directory containing the file config.properties
Goto /usr/sap/<SAPSID>/DVEBMGS<instance_number>/j2ee/configtool
2) Replace the old driver location with the new one:/oracle/client/<Oracle_client_major_version>x_64/instantclient/<java_class_archive>.jar
where <Oracle_client_major_version> is the major version of the Oracle client that you are using after this upgrade.
Make sure correct ODBC jar file should be pointed.
Open Config tool and make changes:
1) Change to Configuration Editor mode.
2)Use the Edit mode to replace the driver location in the following property sheets that contain the string rdbms.driverLocation= followed by the driver location: cluster_data/Propertysheet instance.properties.IDXXXXXXX/IDXXXXXXX.JavaParameters
where XXXXXXX is the instance number
NOTE
Make sure that you change all occurrences.If you have more than one server or dispatcher you must modify all relevant property sheets.
3) Close Editor mode and do global search and change correct rdbms.driverLocation.
4) Close the J2EE Engine – ConfigTool.
Change the driver location in the Java instance profile as follows:
1) Change to the correct directory containing the instance profile <SAPSID>_JC<instance_number>_<host>:/usr/sap/<SAPSID>/SYS/profile
2) Replace the old driver location with the new one:/oracle/client/<Oracle_client_major_version>x_64/instantclient/<java_class_archive>.jar in instance profile.
Change the file sdmrepository.sdc as follows:
1) Goto /usr/sap/<SAPSID>/DVEBMGS<instance_number>/SDM/program/config
2) Search for the following text
<Param type=”String” hide=”false” name=”jarPaths” encrypted=”false” displayName=”Driver Paths (separated by ;)”>
3) If required, replace the old driver location with the new one:/oracle/client/<Oracle_client_major_version>x_64/instantclient/<java_class_archive>.jar
Change the file bootstrap.properties as follows:
1) Goto /usr/sap/<instance_ID>/DVEBMGS<instance_number>/j2ee/cluster/bootstrap
2) Open the file with your text editor and search for the property rdbms.driverLocation.
3) Replace the old driver location with the new one:/oracle/client/<Oracle_client_major_version>x_64/instantclient/<java_class_archive>.jar
Change the file rdb.properties as follows
1) Goto /usr/sap/<SAPSID>/DVEBMGS<instance_number>/j2ee/deploying
2) Open the file with your text editor and search for the property rdbms.driverLocation
3) Replace the old driver location with the new one:/oracle/client/<Oracle_client_major_version>x_64/instantclient/<java_class_archive>.jar
I really like your writing style, fantastic information, thanks for putting up eadkdaagbdca