Resolve 'ORA-12560: TNS: Protocol Adapter' error on Sagent with using Oracle patch

Product Feature: DataFlow Server
Operating System: Oracle 11g


While using Oracle patch as repository/baseview database, 'ORA-12560: TNS: Protocol Adapter' error is encountered.


This is a known defect in Oracle patch


UPDATED: August 23, 2017
Download and install the following or above patch versions of Oracle:

Windows machine:
  • Windows Client 32bit OOB:18694146 --> TARGET
  • Windows Client 64bit OOB:18694138 --> TARGET
  • Windows Client 32bit OOB:18694165 --> TARGET
  • Windows Client 64bit OOB:18694152 --> TARGET
Solaris machine:
  • Solaris SPARC Client 64bit OOB:18694138
  • Solaris SPARC Client 64bit OOB:18694190
HP-UX machine:
  • HP-UX Itanium Client 64bit OOB:18694199
  • HP-UX Itanium Client 64bit OOB:18694203
AIX machine:
  • AIX on POWER Client 64bit OOB:18694219
  • AIX on POWER Client 64bit OOB:18694229
If the issue is still not resolved, contact client support.