TEC610645: Configure APM to connect to Oracle with Enterprise User Security (EUS). How to resolve the error: java.sql.SQLException: unsupported verifier type

Document created by mike_cook Employee on May 25, 2016Last modified by SamCreek on May 25, 2016
Version 2Show Document
  • View in full screen mode

Author: mike_cook

 

Document ID:  TEC610645

Last Modified Date:  5/5/2014

  • Products
    • CA Application Performance Management
  • Releases
    • CA Application Performance Management:Release:CA APM 9.6
  • Components
    • INTROSCOPE

 

Description:A known issue has been identified by Oracle when clients such as the APM Enterprise Manager attempt to connect when Enterprise User Security (EUS) has been enabled.EUS enables clients to connect to Oracle databases using LDAP authentication.Details about EUS are available at the Oracle documentation site:

Details about Oracle Bug ID 8254139 for the EUS problem are available at the Oracle support site:

For Oracle JDBC driver version 11.2.0.1, the workaround is to use -Doracle.jdbc.thinLogonCapability=o3 as a JVM startup option.

  • Note that this property is ignored for Oracle JDBC driver version 11.2.0.3.

style="margin-bottom:10px"

  • If the Enterprise Manager is invoked as a service:

    File : EMservice.conf
    location :<introscope install dir>\bin
    Modification Required : Add a new parameter "wrapper.java.additional.<n>=-Doracle.jdbc.thinLogonCapability=o3".
    (where <n> is the next number in sequence) to the # Java Additional Parameters section.

  • For all Enterprise Managers invoked by either method:

    File:Tess-default.properties
    Location : <introscope install dir>/config
    Modification Required : Append "-Doracle.jdbc.thinLogonCapability=o3" to the jvm option for:
         Defect Aggregation (defects.jvmArgs)
         Stats Aggregation (dailystats.jvmArgs)

 

 

Search the Entire CA APM Knowledge Base

 

search-kb.jpg

Attachments

    Outcomes