ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68

Connecting to the database DEV775@dev11gdb_server231.

Executing PL/SQL: ALTER SESSION SET PLSQL_DEBUG=TRUE

Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '10.17.275.5', '4000' )

ORA-01031: insufficient privileges

ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68

ORA-06512: at line 1

This session requires DEBUG CONNECT SESSION and DEBUG ANY PROCEDURE user privileges.

Process exited.

Disconnecting from the database DEV775@dev11gdb_server231.

The debugger is unable to connect.

Grant the below privileges.

SQL> grant DEBUG CONNECT SESSION to DEV775;

Grant succeeded.

SQL> grant DEBUG ANY PROCEDURE to DEV775;

Grant succeeded.

Now try to debug again. If there is still issue then execute below using DBA user.

BEGIN

DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE (

     host => '10.17.275.5',

     lower_port => null,

     upper_port => null,

     ace => xs$ace_type(

           privilege_list => xs$name_list('jdwp'),

           principal_name => 'DEV775',

           principal_type => xs_acl.ptype_db

     )

);

END;

/

Try the debug again. If you see still issue then set the allowed port numbers in the SQL DEVELOPER.

SQL Developer  >> Tools >> Preferences >> Debugger >> set Debugging Port Range