`

all appropriate instances are blocking new connections

阅读更多

服务器异常信息如下:
[2011-02-09 08:49:41,609] ERROR [sweep] (?:?) - Prototype
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12528, TNS:listener: all appropriate instances are blocking new connections
The Connection descriptor used by the client was:
192.168.10.22:1521:air
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:261)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:439)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at org.logicalcobwebs.proxool.DefaultConnectionBuilder.buildConnection(Unknown Source)
at org.logicalcobwebs.proxool.Prototyper.buildConnection(Unknown Source)
at org.logicalcobwebs.proxool.Prototyper.sweep(Unknown Source)
at org.logicalcobwebs.proxool.PrototyperThread.run(Unknown Source)
[2011-02-09 09:36:21,898] ERROR [invoke] (ServiceLocatorPhaser.java:242) - java.lang.NullPointerException
[2011-02-09 09:36:26,367] ERROR [invoke] (ServiceLocatorPhaser.java:242) - java.lang.NullPointerException
[2011-02-09 09:36:42,413] ERROR [invoke] (ServiceLocatorPhaser.java:242) - java.lang.NullPointerException
[2011-02-09 09:36:45,945] ERROR [invoke] (ServiceLocatorPhaser.java:242) - java.lang.NullPointerException
[2011-02-09 09:37:28,304] ERROR [invoke] (ServiceLocatorPhaser.java:242) - java.lang.NullPointerException
[2011-02-09 09:37:36,117] ERROR [invoke] (ServiceLocatorPhaser.java:242) - java.lang.NullPointerException
[2011-02-09 09:37:39,773] ERROR [invoke] (ServiceLocatorPhaser.java:242) - java.lang.NullPointerException
[2011-02-09 09:37:49,757] ERROR [invoke] (ServiceLocatorPhaser.java:242) - java.lang.NullPointerException
[2011-02-09 14:23:14,007] ERROR [invoke] (ServiceLocatorPhaser.java:242) - java.lang.NullPointerException
[2011-02-09 16:36:44,489] ERROR [invoke] (ServiceLocatorPhaser.java:242) - java.lang.NullPointerException



在网上找了很多解决方案,但是大部分是说超出数据库最大连接数,但实际上数据库设计的最大连接是300个,当时的总连接数是27,不是这个问题引起的。

经过其他人员的查看,是因为oracle数据库服务后启动造成的,也就是说tomcat应用服务器早于oracle服务启动,造成无法连接数据库。一般这种问题出现在机器重新启动时。

解决方案就是把tomcat重新启动下就好了。
分享到:
评论

相关推荐

    Recover4all Professional

    If You are purchasing an additional license for an individual, You may register the name of each such individual by sending an email requesting registration to support@recover4all....

    Rogets II - The New Thesaurus

    All special usages, such as slang terms, are labeled and grouped together at the end of each synonym list. Following each list is a cross-reference to a related entry in the thesaurus’s unique ...

    Statistical Shape Analysis I. L. DRYDEN and K. V. MARDIA

    Statistical Shape Analysis I. L. DRYDEN and K.... Definitions and important results are highlighted throughout to assist the reader in learning about this new, exciting and important area.

    First Course in Algorithms Through Puzzles

    This book is appropriate for undergraduate students in computer science, mathematics, and engineering as a textbook, and is also appropriate for self-study by beginners who are interested in the ...

    matlab homework1

    You will find that complicated operations can often be done with one or two lines of code if you use appropriate functions and have the data stored in an appropriate structure. The other purpose of ...

    生物信息学好文章 new fast and versatile tools for detection of consensus matches in nucleotide sequence data

    The identification of potential regulatory motifs in new sequence data is increasingly important for experimental design. Those motifs are commonly located by matches to IUPAC strings derived from ...

    建模工具2.zip

    + Only appropriate toolbars to current diagram are displayed + Asking before closing the window with unsaved project + Selecting element using CTRL key + Check for new version of application + Section...

    Scrum管理模式-scrumandxpfromthetrenches

    In all instances where C4Media Inc. is aware of a claim, the product names appear in initial Capital or ALL CAPITAL LETTERS. Readers, however, should contact the appropriate companies for more ...

    Microsoft SQL 2007年认证试题(英文PDF版)

    **Scenario:** You have configured a new SQL Server 2005 computer to use TCP/IP with all default settings. Corporate policy requires that each server use a firewall. You find that you can connect to ...

    ssd5 ex4 给需要帮助的人。这是ssd5 ex4

    This is a new method. This method returns a copy of the invoking Listing object sorted by the field name given in the parameter. Use an appropriate STL sorting function to sort the advertisements. To ...

    Data Fusion- Concepts and Ideas

    The main changes in the new book are: New Material: Apart from one new chapter there are approximately 30 new sections, 50 new examples and 100 new references. At the same time, material which is out...

    Statistical Shape Analysis

    Statistical Shape Analysis By I. L. Dryden, Kanti V.... Definitions and important results are highlighted throughout to assist the reader in learning about this new, exciting and important area.

    mlx90632-library-master.zip

    This is 90632 example driver with virtual... They are dependent on mathlib and errno so appropriate flags are required. For ease of development and unit-testing Makefile was added with following targets:

    微软内部资料-SQL性能优化3

    If it aborts, all of its effects are undone. It is an “all or nothing” operation. Consistency An application should maintain the consistency of a database. For example, if you defer constraint ...

    ????_appropriate_zip_

    _appropriate_zip_”可能是指一个关于“适当技术”(Appropriate Technology)的压缩文件,这种技术主要关注在资源有限或发展水平较低的环境中应用的技术解决方案。描述中的“appropriate technology lecture ...

    嵌入式实时系统开发基于WINDOWS CE

    In all instances where CMP Books is aware of a trademark claim, the product name appears in initial capital letters, in all capital letters, or in accordance with the vendor's capitalization ...

    Odoo.10.Development.Essentials.epub

    With announcement of Odoo 10, there are many new features added to Odoo and the face of business applications developed with Odoo has changed. This book will not only teach you how to build and ...

Global site tag (gtag.js) - Google Analytics