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:
ace=> sys.xs$ace_type(privilege_list=>sys.XS$NAME_LIST('JDWP') ,
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?
I think you can wildcard it such that any machine on the subnet is allowed in...