bug: ORA-1031 ORA-600[17285] ORA-600[KGANTC_1] Debugging PL/SQL

环境: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.0
This 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-600
Note 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/