[resolved] error: ORA-12519, TNS:no appropriate service handler found

Hi,I have designed a job as given below in image#1 ..When i try to run my job am getting below error ..Image #2 :- tOracleOutput_1 Image #3 :- tOracleOutput_4Let me know if you need any more details...Error Details:- Exception in component tOracleOutput_4java.sql.SQLException: Listener refused the connection with the following error:ORA-12519, TNS:no appropriate service handler found at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:389) at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:454) at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:165) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:802) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at talendproject.odii_xml_src_job_0_1.ODII_XML_SRC_JOB.tFileList_1Process(ODII_XML_SRC_JOB.java:6510) at talendproject.odii_xml_src_job_0_1.ODII_XML_SRC_JOB.runJobInTOS(ODII_XML_SRC_JOB.java:14267) at talendproject.odii_xml_src_job_0_1.ODII_XML_SRC_JOB.main(ODII_XML_SRC_JOB.java:14128)

Hi, The error ORA-12519 may be caused by that the current connection amount is beyond the max amount of Oracle.Why don't you check out "using an existing connection" option in tOracleOutput by using TalendHelpCenter:tOracleConnection for each connection to reduce the connection number?Or increase the Oracle connection amount at DB side.Best regardsSabrina

--Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

I tried to select all the tOracleOutputs(i.e 6) components to the option "Use an existing connection" but it is throwing NullPointerException as given below..Exception in component tOracleOutput_1java.lang.NullPointerException at talendproject.odii_xml_src_job_0_1.ODII_XML_SRC_JOB.tFileList_1Process(ODII_XML_SRC_JOB.java:6221) at talendproject.odii_xml_src_job_0_1.ODII_XML_SRC_JOB.runJobInTOS(ODII_XML_SRC_JOB.java:14123) at talendproject.odii_xml_src_job_0_1.ODII_XML_SRC_JOB.main(ODII_XML_SRC_JOB.java:13984)

I will try to increase the number of coonections at db side and let you know..

Hi, The error ORA-12519 may be caused by that the current connection amount is beyond the max amount of Oracle.Why don't you check out "using an existing connection" option in tOracleOutput by using TalendHelpCenter:tOracleConnection for each connection to reduce the connection number?Or increase the Oracle connection amount at DB side.Best regardsSabrina