1 Reply Latest reply on Nov 11, 2014 6:53 PM by thatJeffSmith-Oracle

    Using SQL Developer for debugging identified by machine in dba_network_acls

    87474508-39a8-46cf-ba92-bf051cb4f339

      Hi,

      All of team members has got SQL Developer installed. While enabling debugging by adding entry to dba_network_acls, debugger works fine if each developer machine's IP added in dba_network_acls. But our IPs are not static every day and some time we connect from home. We tried adding host name (ie. fully qualified name) but we get always following error message

       

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

      ORA-24247: network access denied by access control list (ACL)

       

      We used following scripts which works fine:

       

      dbms_network_acl_admin.append_host_ace

        (host=>'xxx.xxx.xxx.xxx',

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

        principal_name=>'schema name',

        principal_type=>sys.XS_ACL.PTYPE_DB) );

       

      In host if I give machine like mymachine.comp.com, I am getting ACL issue. Is it like we can always debug only if ip added to acls table?

       

      Can some one help?

       

      Thanks,

      Raj