Database Security Products (MOSC)

MOSC Banner

12c: Specified ACL/ACE cannot resolve Clientname

edited Oct 20, 2015 10:49AM in Database Security Products (MOSC) 4 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center