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

问题描述

我正在使用 GlassFish、Hibernate、Spring(用于事务管理)和 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:

Caused by: java.sql.SQLException: Listener denied the connection with the following error: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.

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

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屋！