Configuring APM Oracle PowerPack/Extension for Oracle to use Oracle JDBC OCI driver & TNSNames Alias Syntax(enables use of Oracle RAC & Oracle Secure External Password Store)

Document created by Lynn_Williams Employee on Jan 6, 2016Last modified by Lynn_Williams Employee on Oct 3, 2017
Version 8Show Document
  • View in full screen mode


  • Out of the box the Oracle PP only supports the use of the Oracle JDBC Thin driver with Thin-style Service Name Syntax (@//host_name:port_number/service_name) when building the DB connection string.
  • This document covers how to use the Oracle JDBC OCI driver with TNSNames Alias Syntax (@MyTNSAlias)



  • A small change needs to be made to the getConnectionString() method for  contained in the PPOracleDB.jar file.The change simply modifies the Oracle JDBC connection string to just take the hostname part of the  hostname-port-db property in the field and uses that as the TNS alias.
  • To avoid a syntax error at PP startup the hostname-port-db property still needs to contain the 3 parameters for "Hostname/Port/Database" e.g. orcl_iscope/1521/orcl where orcl_iscope is the TNS alias from the tnsnames.ora file



          So that means the username & password fields can be set to null in the file for improved security.



  • Modified version of, compiled class DBConnectionData.class and APM 10.1 version of updated PPOracleDB.jar
  • Example file



Please post any questions/problems back to this page



Please note that like any other Field pack this change is not officially supported\tested\certified.

6 people found this helpful