| 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 ;
ReferencesBUG: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
| 
