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: fill missing values
Next Topic: SQL taking more time when selecting column which has length of Varchar2(4000)
Goto Forum:

Current Time: Sun Aug 20 05:02:24 CDT 2017

Total time taken to generate the page: 0.01012 seconds