ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ora-07445

ora-07445

原创 Linux操作系统 作者:zhu618 时间:2011-05-05 09:51:37 0 删除 编辑
Wed May  4 18:18:08 2011
Errors in file /home/oracle/admin/xxdb/udump/xxdb2_ora_1925476.trc:
ORA-07445: 出现异常错误: 核心转储 [psdghi+1cf0] [SIGSEGV] [Invalid permissions for mapped object] [0x000000028] [] []

ORA-1031 ORA-600[17285] ORA-600[KGANTC_1] Debugging PL/SQL [ID 335954.1]

修改时间 18-DEC-2009 类型 PROBLEM 状态 PUBLISHED

In this Document
Symptoms
Cause
Solution
References


Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.3
Information in this document applies to any platform.
***Checked for relevance on 18-DEC-2009***

Symptoms

Debugging PL/SQL using a 3rd party debugger (ie Oraedit) or the DBMS_DEBUG package fails with the
following error sequence reported in the alert log:

Tue Sep 6 11:58:25 2005
Errors in file /ora/RADBAD/admin/udump/radbad_ora_25947.trc:
ORA-00600: internal error code, arguments: [17285], [0xFFFFFFFF7B97B038], [18446744073709551615],
[0x3AD4A9688], [], [], [], []
ORA-00604: error occurred at recursive SQL level 1
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.PBREAK", line 1052
ORA-06512: at "SYS.PBSDE", line 201
ORA-01031: insufficient privileges
ORA-06512: at line 1
ORA-00604: error occurred at recursive SQL level 1
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "SYS.PBREAK", line 1052
ORA-06512: at "SYS.PBSDE", line 201
ORA-01031: insufficient privileges
ORA-06512: at line 1

Trace file also shows the following errors

Probe:S:debug_loop: exception 1: ORA-01031: insufficient privileges


Other internal errors that may accompany the ora-1031 and ora-6512 are:

ORA-07445: exception encountered: core dump [pfrdmp()+4] [SIGSEGV] [Address not mapped to object] [0x0000000B0] [] []
ORA-07445: exception encountered: core dump [kkxtcs()+216] [SIGBUS] [Invalid address alignment] [0x657273696F6E202D] [] []
ORA-00600: internal error code, arguments: [kgantc_1], [0], [1], [], [], [], [], []

Cause

User does not have sufficient privileges for debugging PL/SQL
Bug:4640115 was filed to address the internal errors exposed when the accurate error is the ora-1031

Bug:4640115 was still in progress at the time this note was written

Solution

1. Connect in SQL*Plus as a DBA/SYSDBA

2. grant the privilege DEBUG CONNECT SESSION to your user:

SQL> GRANT DEBUG CONNECT SESSION to ;

References

BUG:4640115 - [9/6] GETTING ORA 600 WHEN DEBUGGING PL/SQL ORA-600
NOTE:257940.1 - Debugging PL/SQL From Oracle JDeveloper Fails With Errors ORA-1031 ORA-6512

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10648374/viewspace-694474/,如需转载,请注明出处,否则将追究法律责任。

上一篇: gxdb2_lms4_4546928.trc
下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2009-09-29

  • 博文量
    7
  • 访问量
    27335