Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Database 23c Free - Developing and Debugging PL/SQL using Oracle SQL Developer -ORA-01031 insufficient priv

user-hmibgMay 19 2023

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

This is the console message:

Connecting to the HR database.
Running PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '192.168.0.66', '49872' )
ORA-01031: insufficient privileges
ORA-06512: in "SYS.DBMS_DEBUG_JDWP", line 68
ORA-06512: online 1
This session needs DEBUG CONNECT SESSION and DEBUG ANY PROCEDURE user privileges.
The process is over.
Disconnecting from the HR database.

Could someone please guide me with this error?

Thanks

Added on May 19 2023

1 comment

468 views