ora-07445

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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10648374/viewspace-694474/