报错: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: An attempt by a client to checkout a Connection has timed out. 数据库连接超时

报错: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: An attempt by a client to checkout a Connection has timed out. 数据库连接超时

解决方法一:

[oracle@data ~]$ sqlplus / as sysdba——连接到数据库

SQL*Plus: Release 11.2.0.4.0 Production on Mon May 8 16:37:56 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select count(*) from v$process;——当前连接数

  COUNT(*)

----------

       128

SQL> select value from v$parameter where name = 'processes';——最大连接数

VALUE

--------------------------------------------------------------------------------

1000

如果最大连接数小鱼当前连接数的话,那么修改最大连接数。

alter system set processes = 300 scope = spfile;

修改后重启数据库

shutdown immediate;

startup;

exit退出

方法二:

修改配置文件中checkoutTime

报错: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: An attempt by a client to checkout a Connection has timed out. 数据库连接超时