Unable to create an Oracle datasource using Oracle 11g/12c drivers

Unable to create an Oracle datasource using Oracle 11g/12c drivers

book

Article ID: KB0083047

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization -

Description

ORA-12516:TNS:Listener could not find available handle with matching protocol stack 
 

Issue/Introduction

Unable to create an Oracle datasource using Oracle 11g/12c drivers

Resolution

Current CIS ODBC drivers are not RAC aware. There is an open feature request (CIS-66786) to fix this.
Issue can be fixed by replacing ojdbc6.jar under <install>/apps/dlm/cis_ds_oracle folder with Db Visualizer's ODBC driver since it is RAC aware.