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 MAY 04, 2023
Applies to:
Business Intelligence Applications Consumer - Version 11.1.1.8.1 and laterInformation 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |