You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » ORA-12519, TNS:no appropriate service handler found
#1 2012-06-08 09:44:50
- cinar
- Member
- Company: OBASE
- Registered: 2011-11-14
- Posts: 58
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.
Last edited by cinar (2012-06-08 09:46:01)
Offline
#2 2012-06-08 10:24:25
- pedro
- Member
- Registered: 2011-11-17
- Posts: 3682
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
Only Paranoid Survive.
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » ORA-12519, TNS:no appropriate service handler found