12c: Specified ACL/ACE cannot resolve Clientname
To allow Debugging from SQL Developer we define ACL/ACE as described in MOS-Doc 1627194.1
„SQL Developer Debugger raises ACL against 12 database“
Using clientname as host
begin
dbms_network_acl_admin.append_host_ace(
host=>'pcname',
ace=>xs$ace_type(
privilege_list=>xs$name_list('jdwp'),
principal_name=>'DB_SCHEMA',
principal_type=>xs_acl.ptype_db
)
);
end;
/
results in
PL/SQL wird ausgeführt: ALTER SESSION SET PLSQL_DEBUG=TRUE
PL/SQL wird ausgeführt: CALL DBMS_DEBUG_JDWP.CONNECT_TCP( '111.22.33.111', '55555' )
ORA-24247: Netzwerkzugriff von Access Control-Liste (ACL) abgelehnt
ORA-06512: in "SYS.DBMS_DEBUG_JDWP", Zeile 68