为什么会出现此Oracle连接错误? ORA-12519，TNS:找不到合适的服务处理程序 [英] Why do I get this Oracle connections error? ORA-12519, TNS:no appropriate service handler found

问题描述

我正在使用GlassFish，Hibernate，Spring(用于事务mgmt)和Oracle 11g构建JSF2应用程序.

I'm building a JSF2 app with GlassFish, Hibernate, Spring (for transaction mgmt), and Oracle 11g.

应用程序运行了一段时间后，该应用程序无法查询数据库，并且我在GlassFish日志中收到以下错误:

After the application has been running for a while, the app fails to query the db and I get the following error in the GlassFish log:

由以下原因引起:java.sql.SQLException:侦听器拒绝连接，并出现以下错误: ORA-12519，TNS:找不到合适的服务处理程序

Caused by: java.sql.SQLException: Listener refused the connection with the following error: ORA-12519, TNS:no appropriate service handler found

这听起来好像Oracle的连接用完了，但是Oracle中的进程设置为150(我认为这意味着它将接受150个连接)，这似乎足够了.

This sounds like Oracle is running out of connections, but the processes in Oracle are set to 150 (which I think means it will accept 150 connections) which seems like plenty.

我的Hibernate配置似乎设置为使用1个连接(如下所示).为什么应用程序会打开150个以上的连接?

My Hibernate config appears to be set to use 1 connection (as follows). Why would the application be opening more than 150 connections?

您如何建议我解决这个问题?任何建议都将不胜感激.

And how would you suggest I address this? Any suggestions are greatly appreciated.

<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="hibernate.connection.url">jdbc:oracle:thin:@1.2.3.4:1521:orcl</property>
<property name="hibernate.connection.username">username</property>
<property name="hibernate.connection.password">password</property>
<property name="hibernate.connection.pool_size">1</property>

推荐答案

这是Oracle服务器上的问题:

This is a problem on the Oracle server:

http://ora-12519.ora-code.com/

该侦听器找不到适合该客户端连接的任何可用服务处理程序.

The listener could not find any available service handlers that are appropriate for the client connection.

换句话说，尽管JDBC URL中可能有错误，但与Hibernate，Java或Spring无关.

In other words, nothing to do with Hibernate, Java or Spring, although possibly an error in the JDBC URL.

与您的DBA对话，找出正在发生的事情.

Talk to your DBA and find out what's going on.

这篇关于为什么会出现此Oracle连接错误? ORA-12519，TNS:找不到合适的服务处理程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！