ORA-12519, TNS:no appropriate service handler found

One Star

ORA-12519, TNS:no appropriate service handler found

Hello,
While working with Talend, I encounter the following error:
Exception in component tOracleRow_9
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
What is weird that I don't get the error constantly. In addition, the error appears on different components randomly..
I couldn't figure out What the problems is..
Here some screenshots..
Anyone who has encountered and knows solution?
Thanks.
One Star

Re: ORA-12519, TNS:no appropriate service handler found

Hi
The error ORA-12519 may be caused by that the current connection amount is beyond the max amount of Oracle.
Have you used "using an existing connection" option for each connection to reduce the connection number?
Or increase the Oracle connection amount at DB side.
Regards,
Pedro

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download