TNS-12519 (merged) [message #342805] |
Mon, 25 August 2008 03:10 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 1681 times)
|
|
|
Re: TNS-12519 [message #342813 is a reply to message #342805] |
Mon, 25 August 2008 03:53 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ThomasG
Messages: 3211 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 #342837 is a reply to message #342815] |
Mon, 25 August 2008 05:09 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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
|
|
|
|
Listener State blocked [message #343427 is a reply to message #342805] |
Wed, 27 August 2008 04:56 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #344087 is a reply to message #343967] |
Thu, 28 August 2008 14:04 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #346147 is a reply to message #346142] |
Sat, 06 September 2008 09:10 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68666 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
|
|
|