ORA-0131 :insufficient privileges DEBUG CONNECT SESSION

11
votes

I got this error message "ORA-0131 :insufficient privileges DEBUG CONNECT SESSION" trying to start debug PL/SQL script using PL/SQL Developer.

Oracle Database 11g Release 11.1.0.7.0

I'm a part of admin group. Is this privileges necessary?

grant DEBUG CONNECT SESSION to =<bobens_83-here_goes_your_db-username>
1
oracledebuggingplsql
This is off-topic and belongs on Database Administrators – Jim Garrison
@JimGarrison I disagree - IMHO this is a question about debugging and therefore on-topic on SO. – Frank Schmitt

1 Answers

16
votes

As you mentioned , its problem of privileges.

Quoted from this site

ORA-01031: insufficient privileges

Cause: An attempt was made to change the current username or password without the appropriate privilege. This error also occurs if attempting to install a database without the necessary operating system privileges. When Trusted Oracle is configure in DBMS MAC, this error may occur if the user was granted the necessary privilege at a higher label than the
current login.

Action: Ask the database administrator to perform the operation or grant the required privileges. For Trusted Oracle users getting this error although granted the appropriate privilege at a higher label, ask the database administrator to re-grant the privilege at the appropriate label.

If you working on debug it should work

grant DEBUG CONNECT SESSION to <bobens_83-here_goes_your_db-username>