ODI Load Plan Execution Fails With The Error 'ORA-12516 - tns:listener could not find available handler with mathing protocol stack' As The Database Server Has Run Out Of Sessions/ Processes (Doc ID 1928671.1)

Last updated on MARCH 08, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 and later
Information in this document applies to any platform.

Symptoms

ODI Load Plan Execution error

ODI-1519: Serial step "Start Load Plan (InternalID:1193500)" failed because child step "Global Variable Refresh (InternalID:1194500)" is in error.
ODI-1519: Serial step "Load Target Table (InternalID:1264500)" failed because child step "EBS_12_1_3 - DSN 1000 (InternalID:1265500)" is in error.
ODI-1519: Serial step "EBS_12_1_3 - DSN 1000 (InternalID:1265500)" failed because child step "DOMAIN (InternalID:1266500)" is in error.
ODI-1519: Serial step "DOMAIN (InternalID:1266500)" failed because child step "Parallel (InternalID:1267500)" is in error.
ODI-1518: Parallel step "Parallel (InternalID:1267500)" failed; 6 child step(s) in error, which is more than the maximum number of allowed errors (0) defined for the parallel step. Failed child steps: PROJECTS (InternalID:1341500), COST (InternalID:1395500), PROC (InternalID:1365500), FINANCIALS (InternalID:1318500), SOURCING (InternalID:1384500), COMMON (InternalID:1268500)
Error Code = ODI-1519
ORA-12516: TNSListener could not find available handler with matching protocol used

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms