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.
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