Using the APM PowerPack for Oracle (Oracle PP) with the Oracle JDBC OCI driver & TNSNames Alias Syntax(Oracle RAC connectivity)

Document created by Lynn_Williams Employee on Jan 6, 2016Last modified by Lynn_Williams Employee on Aug 2, 2017
Version 5Show Document
  • View in full screen mode

Background:

  • 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)

 

Details:

  • A small change needs to be made to the getConnectionString() method for com.wily.introscope.oracle.util.DBConnectionData  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 PPOracleDB.properties 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

 

Benefits:

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

  • Connection to an Oracle RAC could be achieved via the RAC TNS_ALIAS (usually configured with a VIP for the hostname)

 

Attachments:

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

 

Feedback:

Please post any questions/problems back to this page

 

Disclaimer:

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

2 people found this helpful

Outcomes