IBM Support

How to change the Oracle JDBC Driver on Unix

Question & Answer


Question

How to change the Oracle JDBC Driver on Unix

Answer

For example, to change the JDBC Driver to 11.x.x.x

       
  •    
     Download the file from oracle  
       
    •    
  •    
     Stop GIS
       
    •    
  •    
     navigate to  ../SI/jdk/jre/lib/ext
       
    •    
  •    
     take a backup copy of this file -  ojdbc6.jar
       
    •    
  •    
     copy the driver downloaded from Oracle to a temporary directory (for example /updateoracledriver) 
       
    •    
  •    
     edit the dynamicclasspath.cfg.in file and comment the lines (with #) that refer to the old ojdbc drivers
       
    •    
  •    
     in a shell start /SI/bin/Install3rdparty.sh oracle 11.1.0.7 -d /updateoracledriver/ojdbc6.jar
       
    •    
  •    
     in a shell start  /SI/bin/deployer.sh
       
    •    
  •    
     in a shell start  /SI/bin/setupfiles.sh
       
    •    
  •    
     start SI
       
    •    
  •    
     Start  /si/bin/dump_info.sh > dump_info.txt and verify the version has been updated
       

[{"Product":{"code":"SS3JSW","label":"IBM Sterling B2B Integrator"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Installation","Platform":[{"code":"PF027","label":"Solaris"}],"Version":"5.2.4.1;5.2.4;5.2.3;5.2.2;5.2.1;5.2;5.1;5.0","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SS9GLA","label":"IBM Control Center"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":"Not Applicable","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Historical Number

HTG1251

Document Information

Modified date:
17 February 2020

UID

swg21562399

Page Feedback