One Star

[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_4
Let me know if you need any more details...
Error Details:-
Exception in component tOracleOutput_4
java.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)

  • Data Integration
7 REPLIES
One Star

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

Pls see if you can run "lsnrctl services". Either the listener is not registered or there is a version mismatch between your client and DB server.
_Ben
Moderator

Re: [resolved] error: 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.
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 regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

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

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_1
java.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..
One Star

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

If it have only three tOracleOutputs then it works fine..No error and no issue..
If i try to add more tOracleOutputs then am getting this error ..
One Star

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

After running below two queries in oracle DB my job worked fine ..
Thanks for your help..

ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE;
ALTER SYSTEM SET OPEN_CURSORS=500;
One Star

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

After running below two queries in oracle DB my job worked fine ..
Thanks for your help..

ALTER SYSTEM SET PROCESSES=150 SCOPE=SPFILE;
ALTER SYSTEM SET OPEN_CURSORS=500;

thank u soo much sir
One Star

Re: [resolved] error: 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.
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 regards
Sabrina

Thank you Saved my day. Smiley Happy