I try to debug my procedure on oracle 19c inside docker container.
Before start debugger i was exposed port in docker 14000:4000 (1521 of course too) and configure in SQLDeveloper to use port range for debug 14000-14000 and prompt for host.
First i've got error:
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '0.0.0.0', '0' )
ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68
ORA-06512: at line 1
Fix it with script:
begin
for x in(select '0.0.0.0' as ip from dual union all select 'localhost' as ip from dual union all select '127.0.0.1' from dual) loop
dbms_network_acl_admin.append_host_ace(
host=>x.ip,
ace=> sys.xs$ace_type(privilege_list=>sys.xs$name_list('JDWP'),
principal_name=> 'app',
principal_type=>sys.xs_acl.ptype_db)
);
end loop;
end;
I've got this error and now i don't know what to do:
Executing PL/SQL: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '0.0.0.0', '0' )
ORA-30683: failure establishing connection to debugger
ORA-12533: TNS:illegal ADDRESS parameters
ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68
ORA-06512: at line 1
N.B. : error message says that developer try to connect at port = 0 but if i change port in settings to different range, for example 14001-14001 then message will contain port 140001, I don't know why.
DBMS_DEBUG (not jdwp) works normally, but I want full functionality of debugger.