Steps to open Debug in Oracle

 https://asktom.oracle.com/ords/f?p=100:11:0::::P11_QUESTION_ID:9528615800346614204

select * from dba_network_acls;

grant execute on DBMS_DEBUG_JDWP to  <User>

grant   DEBUG CONNECT SESSION , DEBUG ANY PROCEDURE to  <USER>;

 begin

         dbms_network_acl_admin.append_host_ace

          (host=>'127.0.0.1',

           ace=> sys.xs$ace_type(privilege_list=>sys.XS$NAME_LIST('JDWP') ,

                         principal_name=>'<USER>',

                           principal_type=>sys.XS_ACL.PTYPE_DB) );

       end;

    /

exec dbms_network_acl_admin.drop_acl( ACL_NAME);