最近给客户做Oracle数据库巡检，发现alert日志出现ORA-700报错，经排查分析，是由BUG 10285394造成，该BUG需在11.2.0.3以后修复，
该BUG对数据库运行无太大影响，只是记录调用程序的异常，但并不会把进程挂起，以下为这个ORA-700和该BUG的官方描述：
What are ORA-700 errors? ORA-700 errors are referred to as soft asserts in 11g. Basically these are internal errors that do not cause anything fatal to occur in the process, and so the process can continue. Soft asserts are triggered when the caller wants to make a note of the fact that something unexpected has happened, but would like to continue on because the failure is not fatal to the process or the instance. In such cases, the process just records the error, takes the corresponding dumps and moves on as though nothing happened. Are ORA-700 errors similar to ORA-600 in 10g? Yes, ORA-700 errors separate less harmful ORA-600 errors from the ones that cause huge impact like instance failures. For example, if the code finds that a hint in a query is corrupt, it can just raise a soft-assert since the query can be run without the hint being used, and so doesn't need to crash the process. So in 11g, for such a condition an ORA-700 error would be raised. General Format of ORA-700 error is: |
ORA-00700: soft internal error, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s] |
Example: ORA-700: soft internal error, arguments: [kgeade_is_0], [], [], [], [], [], [], [] |
Bug 10285394 ORA-700[kfnReleaseASM1] when using ASM
This note gives a brief overview of bug 10285394.
The content was last updated on: 28-JUN-2013
Click here for details of each of the sections below. Affects:
Product (Component) | Oracle Server (Rdbms) |
Range of versions believed to be affected | Versions BELOW 12.1 |
Versions confirmed as being affected | |
Platforms affected | Generic (all / most platforms affected) |
Fixed:
Description
Soft assert ORA-700 [kfnReleaseASM1] can occur in the DB instance
when using ASM
Rediscovery Notes:
ORA-700 [kfnReleaseASM1]
发表评论 取消回复