EVENT: 10500 "turn on traces for SMON"

解决ORA-10500错误

转载于 2013-03-19 00:32:00 发布 · 67 阅读

文章标签：

#数据库

本文介绍了解决Oracle数据库中ORA-10500错误的方法，包括关闭数据库、修改初始化参数文件并重启数据库，以及如何通过oradbx或oradebug设置SMON进程跟踪。

Error:  ORA 10500
Text:   turn on traces for SMON
-------------------------------------------------------------------------------
Cause:
Action:
        Level:  <=5  trace instance recovery
        > 5  trace posting of SMON

To set event 10500:

For the instance:
a.  Shutdown database
b.  Edit the initialisation parameter file and add:
    event="10500 trace name context forever, level <value>"
c.  restart the database

For the SMON session:
Post the SMON process using oradbx (Oracle 7) or oradebug (Oracle 8).
For oradebug from server manager issue:

oradebug setospid <OS PID>
oradebug event 10500 trace name context forever, level <value>

For further information about oradebug Note 29786.1
                              oradbx   Note 28863.1

<value> is 'Level' as per above