重启程序解决问题
OALL8 is in an inconsistent stateIo exception: Broken pipeClosed ConnectionNo more data to read from socket问题处理一、产生原因数据库扩容重启,程序非正常断开连接出现的问题二、排查过程通过错误提示百度搜索相关信息,大多关键词都有数据库重启、驱动版本和Oracle不兼容,和DBA确认了一下Oracle数据库情况,确实再几天前有过扩容重启措施但版本没有变过一直是11.2.0.3,而当时程序
Enhancements
Note: downloading an update through Check Online Updates in version 14.0.1 did not always work. Version 14.0.1 users can download 14.0.6 here.
Querying a table with LOBs or Objects on
Oracle
21c would raise an error
Queries on
Oracle
21c could raise an “ORA-24444: TTC RPC (OALL) not allowed” exception
PL/SQL Beautifier could add empty lines after “OPEN cursor”
state
ment
Opening the “Roles” folder in the Object Browser could display a popup message with the current username
因为你运行的是
oracle
10g,就可能面临这个
问题
,因为10g存在一个已知的bug,bug在
oracle
的编号为:Bug:5851267
oracle
已经推出补丁,解决这个
问题
。
或者不应用补丁,以下面这种方式解决
Enhancements
Note: downloading an update through Check Online Updates in version 14.0.1 did not always work. Version 14.0.1 users can download 14.0.6 here.
Querying a table with LOBs or Objects on
Oracle
21c would raise an error
Queries on
Oracle
21c could raise an “ORA-24444: TTC RPC (OALL) not allowed” exception
PL/SQL Beautifier could add empty lines after “OPEN cursor”
state
ment
Opening the “Roles” folder in the Object Browser could display a popup message with the current username
ERROR: Closed Connection
ERROR: No more data to read from socket
ERROR: Io exception: Broken pipe
应用是Tomcat用JDBC驱动连
数据库
。
网上查看了一下,