ORA-12519

[dejambo]

Good morning to all, I am randomly receiving the error this "ORA-12519, TNS: in the Appropriate Service Handler Found". Can anyone tell me why this mistake and how to solve it?

Thanks.

[dr_gori]

This error, when generated randomly, may be because your application is leaving open connections.
(for example, generated an error and left the class without closing the connection).
This can be an explanation, then this program is consuming many connections.

[dejambo]

Good morning DR_GORI

Thank you very much for the answer, I will check this issue with the developers here. Hug.

[dejambo]

DR_GORI

I checked the application, and I think the problem is not it, because the same application on the approval server is working smoothly.

[adrianoturbo]

Brother, checks the status of your listener, it may be that it is down if you are trying to give up on it.

Select all

 
$ lsnrctl status 

Select all

 
$ lsnrctl start 

Select all

 
$ lsnrctl stop 

Select all

 
lsnrctl reload 

If possible post your listener status here so we can analyze.

[dejambo]

And Adrianoturbo.

I did what you suggested, but Listener was not down. And I just saw the Enterprise here, the bentid alert appeared again: Failed to connect to the database instance: ORA-12519: TNS: In the Appropriate Service Handler Found (DBD Error: OCISERVERATTACH).

[adrianoturbo]

Try to restart Listener and if it does not work put the status of the listener here to see.

[dejambo]

He gave a stop after a start. The status log follows:

Select all

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-SEP-2014 14:35:50 
 
Copyright (c) 1991, 2005, Oracle.  All rights reserved. 
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle10g)(PORT=1521))) 
STATUS of the LISTENER 
------------------------ 
Alias                     LISTENER 
Version                   TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production 
Start Date                17-SEP-2014 14:31:21 
Uptime                    0 days 0 hr. 4 min. 31 sec 
Trace Level               off 
Security                  ON: Local OS Authentication 
SNMP                      OFF 
Listener Parameter File   D:\oracle\product\10.2.0\db_1\network\admin\listener.ora 
Listener Log File         D:\oracle\product\10.2.0\db_1\network\log\listener.log 
Listening Endpoints Summary... 
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle10g)(PORT=1521))) 
Services Summary... 
Service "DESENVOLXDB" has 1 instance(s). 
  Instance "desenvol", status READY, has 1 handler(s) for this service... 
Service "DESENVOL_XPT" has 1 instance(s). 
  Instance "desenvol", status READY, has 1 handler(s) for this service... 
Service "MIGRACAOXDB" has 1 instance(s). 
  Instance "migracao", status READY, has 1 handler(s) for this service... 
Service "MIGRACAO_XPT" has 1 instance(s). 
  Instance "migracao", status READY, has 1 handler(s) for this service... 
Service "PLSExtProc" has 1 instance(s). 
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... 
Service "SISEMANETXDB" has 1 instance(s). 
  Instance "sisemanet", status READY, has 1 handler(s) for this service... 
Service "SISEMANET_XPT" has 1 instance(s). 
  Instance "sisemanet", status READY, has 1 handler(s) for this service... 
Service "desenvol" has 1 instance(s). 
  Instance "desenvol", status READY, has 1 handler(s) for this service... 
Service "migracao" has 1 instance(s). 
  Instance "migracao", status READY, has 1 handler(s) for this service... 
Service "sisemanet" has 1 instance(s). 
  Instance "sisemanet", status READY, has 1 handler(s) for this service... 
The command completed successfully

[dr_gori]

DR_GORI

I checked in the application, and I think the problem is not it, because the same application on the approval server is working smoothly.

For then, I think the error exists in both. It just does not appear on the type-approval server because it does not have many people using. This is the only explanation for this error to happen sporadically.

Here in this link has an explanation that may be occurring there: http://stackoverflow.com/questions/1472 ... nto-oracle
Is your application in Java?

[dejambo]

Galera, I'm trying to follow the following solution:

Select all

cmd>sqlplus / as sysdba 
sqlplus>alter system set processes=300 scope=spfile; 
sqlplus>shut immediate; 
sqlplus>startup 

But when I soon as a system and I do the Select:

Select all

select * from v$resource_limit 
WHERE RESOURCE_NAME IN ('processes','sessions','transactions');

]

.. The LIMIT_VALUE column continues with the value 150.

[dejambo]

Linguaguem used is .NET

[dejambo]

Sorry, it's C #