Home » RDBMS Server » Networking and Gateways » TNS-12519 (merged)
TNS-12519 (merged) [message #342805] Mon, 25 August 2008 03:10 Go to next message
gavaskardotcom
Messages: 9
Registered: August 2008
Location: Chennai
Junior Member
Hi,

Can anybody give me the solution for the error TNS-12519 (Oracle10g)
I googled and read the documetation. From some solutions I got, increasing number of processes in the SPFILE worked for few days and it is back again. Currently number of proceeses are 250 we have 50 database users. I think 250 processes are more than enough. I have attached results of "lsnrctl services" in the atttachment

Please give me some idea ASAP.


Thanks
snl.
  • Attachment: TNS.txt
    (Size: 0.97KB, Downloaded 223 times)
Re: TNS-12519 [message #342813 is a reply to message #342805] Mon, 25 August 2008 03:53 Go to previous messageGo to next message
ThomasG
Messages: 3089
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Please post the relevant information, like an excerpt form the alert.log of the instance in question ASAP.
Re: TNS-12519 [message #342815 is a reply to message #342805] Mon, 25 August 2008 04:00 Go to previous messageGo to next message
Michel Cadot
Messages: 58577
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12519: TNS:no appropriate service handler found
 *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

Regards
Michel
Re: TNS-12519 [message #342836 is a reply to message #342813] Mon, 25 August 2008 05:07 Go to previous messageGo to next message
gavaskardotcom
Messages: 9
Registered: August 2008
Location: Chennai
Junior Member
Hi,

Please find the attachement in which I have given results of "lsntctl services" and some lines in the "listener.log"
also the listener.ora details.

I have increased the number of processes in spfile to 200 first it worked for a week. after that same error repeated. Again I had to increased it to 250 and now it is repeating again.


Thank you,
snl.
  • Attachment: UPLOAD.txt
    (Size: 2.30KB, Downloaded 209 times)
Re: TNS-12519 [message #342837 is a reply to message #342815] Mon, 25 August 2008 05:09 Go to previous messageGo to next message
gavaskardotcom
Messages: 9
Registered: August 2008
Location: Chennai
Junior Member
Thaks for you are reply but from the details given below, I hope all the instances are registered.

Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:19894 refused:0 state:ready
LOCAL SERVER
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1002 state:ready
DISPATCHER <machine: SYSORA10GDEV1, pid: 1976>
(ADDRESS=(PROTOCOL=tcp)(HOST=SysOra10gDev.sns.org)(PORT=1050))
Service "orcl_XPT" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:1951 refused:0 state:Blocked
LOCAL SERVER
The command completed successfully

Re: TNS-12519 [message #342838 is a reply to message #342837] Mon, 25 August 2008 05:11 Go to previous messageGo to next message
gavaskardotcom
Messages: 9
Registered: August 2008
Location: Chennai
Junior Member
sorry for the typo.. Razz
Listener State blocked [message #343427 is a reply to message #342805] Wed, 27 August 2008 04:56 Go to previous messageGo to next message
gavaskardotcom
Messages: 9
Registered: August 2008
Location: Chennai
Junior Member

Listener state shows "Blocked" from "lsnrctl services". I have verified listener log it says "TNS-12519 TNS:no appropriate service handler found." I have set number of processes to 250 from some of the solutions given when i googled. But still error comes.



Regards
snl.
Re: TNS-12519 (merged) [message #343614 is a reply to message #342805] Wed, 27 August 2008 11:33 Go to previous messageGo to next message
BlackSwan
Messages: 22506
Registered: January 2009
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

Please post the last 100 or so lines from listener.log

In what language is the application written?

What, if any, is the middle tier s/w between users & database?
Re: TNS-12519 (merged) [message #343951 is a reply to message #343614] Thu, 28 August 2008 08:54 Go to previous messageGo to next message
gavaskardotcom
Messages: 9
Registered: August 2008
Location: Chennai
Junior Member
Hi,


I am posting the listener.log details. Please check the attachment.

Our users will conenct to the database with the JDBC driver and the applications they use are Netbeans and Myeclipse and I am not sure on which language the application written.

Please ask for anymore details required.

Thaks
snl.
  • Attachment: Listener.log
    (Size: 7.38KB, Downloaded 399 times)
Re: TNS-12519 (merged) [message #343967 is a reply to message #342805] Thu, 28 August 2008 09:10 Go to previous messageGo to next message
BlackSwan
Messages: 22506
Registered: January 2009
Senior Member
No connection pooling is being used.

Please note in listener.log that immediate after "service_update" that new connection requests succeed.
After a bit TNS-12519 errors occur until next "service_update".


Increasing PROCESSES in initSID.ora masks the problem.
The real solution is to employ connection pooling.
Re: TNS-12519 (merged) [message #344087 is a reply to message #343967] Thu, 28 August 2008 14:04 Go to previous messageGo to next message
gavaskardotcom
Messages: 9
Registered: August 2008
Location: Chennai
Junior Member
Thank you for the reply anacedent,

Like you told, after the service Update again the conenction is being established. I think PMON is the one which responsible for service Update. In the service Update all the diconnected session should be Counted and updated to the listener(If I am correct).

So the listener will know how many available connections.after the service update correct?

We have maximum of 50 oracle databse users but whenever I check for the number of processes in use it shows in the range od 230.

Thanks
snl.
Re: TNS-12519 (merged) [message #344090 is a reply to message #342805] Thu, 28 August 2008 14:18 Go to previous messageGo to next message
BlackSwan
Messages: 22506
Registered: January 2009
Senior Member
> So the listener will know how many available connections.after the service update correct?
You are correct.

The real solution is to employ connection pooling.
Re: TNS-12519 (merged) [message #346142 is a reply to message #344090] Sat, 06 September 2008 08:50 Go to previous messageGo to next message
gavaskardotcom
Messages: 9
Registered: August 2008
Location: Chennai
Junior Member
How to use connection pooling. Please help me with this.
Re: TNS-12519 (merged) [message #346143 is a reply to message #346142] Sat, 06 September 2008 09:03 Go to previous messageGo to next message
BlackSwan
Messages: 22506
Registered: January 2009
Senior Member
gavaskardotcom wrote on Sat, 06 September 2008 06:50
How to use connection pooling. Please help me with this.


Connection pooling is an application issue & not an Oracle DB issue.

Typically the application which runs in/on the middle tier, opens a fixed & finite number of connections/sessions into the DB when the apllication server s/w is first started. The application then manages this pool internally.

So this solution involves rewriting a portion of the application.
Re: TNS-12519 (merged) [message #346147 is a reply to message #346142] Sat, 06 September 2008 09:10 Go to previous message
Michel Cadot
Messages: 58577
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
gavaskardotcom wrote on Sat, 06 September 2008 15:50
How to use connection pooling. Please help me with this.

This is another question than "TNS-12519", create a new topic but I recommend you to search in documentation and web BEFORE.

Regards
Michel

Previous Topic: ERROR:ORA-12541: TNS:no listener
Next Topic: Check concurrent connection limit
Goto Forum:
  


Current Time: Sat Jul 26 00:19:43 CDT 2014

Total time taken to generate the page: 0.10493 seconds