环境:AIX5.3+10.2.0.2 RAC
[@more@]ORA-1031 ORA-600[17285] ORA-600[KGANTC_1] Debugging PL/SQL | ||||
文档 ID: | 注释:335954.1 | 类型: | PROBLEM | |
上次修订日期: | 07-DEC-2005 | 状态: | PUBLISHED |
In this Document
Symptoms
Cause
Solution
References
Applies to:
Oracle Server - Enterprise Edition - Version: 10.1.0.3.0This problem can occur on any platform.
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-600Note 257940.1 - Debugging PL/SQL From Oracle JDeveloper Fails With Errors ORA-1031 ORA-6512
Errors
ORA-600[KGANTC_1]ORA-600 [17285]
ORA-7445:PFRDMP
ORA-7445:KKXTCS
ORA-7445 "exception encountered: core dump [%s] [%s]"
ORA-604 error occurred at recursive SQL level
ORA-6510 PL/SQL: unhandled user-defined exception
ORA-6512 "at %sline %s"
ORA-1031 "insufficient privileges"
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7318139/viewspace-906336/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7318139/viewspace-906336/