OraFAQ Forum: Networking and Gateways » TNS-12519 (merged)

Home » RDBMS Server » Networking and Gateways » TNS-12519 (merged)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TNS-12519 (merged) [message #342805]

Mon, 25 August 2008 03:10

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 1794 times)

Report message to a moderator

Re: TNS-12519 [message #342813 is a reply to message #342805]

Mon, 25 August 2008 03:53

ThomasG
Messages: 3212
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.

Report message to a moderator

Re: TNS-12519 [message #342815 is a reply to message #342805]

Mon, 25 August 2008 04:00

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: TNS-12519 [message #342836 is a reply to message #342813]

Mon, 25 August 2008 05:07

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 2156 times)

Report message to a moderator

Re: TNS-12519 [message #342837 is a reply to message #342815]

Mon, 25 August 2008 05:09

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

Report message to a moderator

Re: TNS-12519 [message #342838 is a reply to message #342837]

Mon, 25 August 2008 05:11

gavaskardotcom
Messages: 9
Registered: August 2008
Location: Chennai

Junior Member

sorry for the typo.. Razz

Razz

Report message to a moderator

Listener State blocked [message #343427 is a reply to message #342805]

Wed, 27 August 2008 04:56

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.

Report message to a moderator

Re: TNS-12519 (merged) [message #343614 is a reply to message #342805]

Wed, 27 August 2008 11:33

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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?

Report message to a moderator

Re: TNS-12519 (merged) [message #343951 is a reply to message #343614]

Thu, 28 August 2008 08:54

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 2245 times)

Report message to a moderator

Re: TNS-12519 (merged) [message #343967 is a reply to message #342805]

Thu, 28 August 2008 09:10

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

Re: TNS-12519 (merged) [message #344087 is a reply to message #343967]

Thu, 28 August 2008 14:04

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.

Report message to a moderator

Re: TNS-12519 (merged) [message #344090 is a reply to message #342805]

Thu, 28 August 2008 14:18

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

Re: TNS-12519 (merged) [message #346142 is a reply to message #344090]

Sat, 06 September 2008 08:50

gavaskardotcom
Messages: 9
Registered: August 2008
Location: Chennai

Junior Member

How to use connection pooling. Please help me with this.

Report message to a moderator

Re: TNS-12519 (merged) [message #346143 is a reply to message #346142]

Sat, 06 September 2008 09:03

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

Re: TNS-12519 (merged) [message #346147 is a reply to message #346142]

Sat, 06 September 2008 09:10

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 08:12:52 CST 2024