Administrator

Installing Oracle JDBC Drivers

To use an Oracle database, install an Oracle JDBC driver.

Procedure

  1. Download the Oracle JDBC driver from the Oracle Web site at http://www.oracle.com/technetwork/database/features/jdbc/index-091264.htmlInformation published on non-SAP site.
  2. Unzip the downloaded package and find ojdbc6.jar.
  3. Copy ojdbc6.jar to the thirdparty/oracle directory.
    There should be a manifest file in the directory called oraclemanifest.
  4. Update the manifest in ojdbc6.jar with oraclemanifest:
    1. Change to the thirdparty/oracle directory.
    2. Run:
      jar -umvf oraclemanifest ojdbc6.jar
  5. Copy the modified ojdbc6.jar to the bundle/application directory, and rename it oracle-jdbc-osgi_11.2.0.2.0-1.0.0.jar:
    cp ojdbc6.jar ${BRAND_HOME}/bundle/application/oracle-jdbc-osgi_11.2.0.2.0-1.0.0.jar 

    where BRAND_HOME is set to the SMS Builder installation directory.

  6. Configure the location of the Oracle JDBC driver:
    1. Open the conf/config.properties file.
    2. Under the #JDBC drivers section, add this line:
      ${aims.app.dir}/oracle-jdbc-osgi_11.2.0.2.0-1.0.0.jar

Next Steps

Enable the Oracle JDBC driver.