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

[Anonymous]

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)

[_AnonymousUser]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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;

[_AnonymousUser]

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

[_AnonymousUser]

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.