Home » SQL & PL/SQL » SQL & PL/SQL » "ORA-12519: TNS:no appropriate service handler found" (10g)
"ORA-12519: TNS:no appropriate service handler found" [message #354274] Fri, 17 October 2008 05:33 Go to next message
Messages: 1
Registered: October 2008
Location: hyd
Junior Member
Hi ,

when i am trying to run the datastage job of inserting the data from a flat file to oracle database tables the jobs are getting aborted due to the below reason
"ORA-12519: TNS:no appropriate service handler found"
and when observed the count of process
select count(*) V$PROCESSES the proces are not getting released very soon

Can any one help me to solve this issue

Thank you
Re: "ORA-12519: TNS:no appropriate service handler found" [message #354279 is a reply to message #354274] Fri, 17 October 2008 05:48 Go to previous message
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Error: ORA-12519
Cause: the listener could not find any available service handlers that are appropriate for the client connection.

Action: run "lsnrctl services" to ensure that the instance(s) have registered with the listener, and are accepting connections.

To resolve ORA-12519, register the listener manually if you still wish to use non-default ports.

[Updated on: Fri, 17 October 2008 06:30] by Moderator

Report message to a moderator

Previous Topic: update multiple rows
Next Topic: Oracle to Access file without using any utility Tool
Goto Forum:

Current Time: Wed Oct 26 11:15:12 CDT 2016

Total time taken to generate the page: 0.07826 seconds