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

Product Feature: DataFlow Server
Operating System: Oracle 11g

Issue

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

Cause

This is a known defect in Oracle patch 11.2.0.4.

Resolution

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

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