Tuesday, 24 September 2024

ora - 24247 : network access denied by access control list (ACL) / ORA-06512: at SYS.DBMS_DEBUG_JDWP

ISSUE - After upgrading from 12.2 to 19.10 upgrade.
As per error, Missing ACL privileges after upgrade.
        ORA-24247: network access denied by access control list (ACL)
        ORA-06512: at "SYS.DBMS_DEBUG_JDWP", line 68
This behavior was only  happening when execute PACKAGE DEBUGGING  FROM SQL DEVELOPER


SOLUTION - Add ACL host where SQLDEVELOPER is installed.

Add  ACL host  where SQLDEVELOPER is installed.

begin
       dbms_network_acl_admin.append_host_ace
       (host=>'*',
        ace=> sys.xs$ace_type(privilege_list=>sys.XS$NAME_LIST('JDWP') ,
                       principal_name=>'SCOTT',
                       principal_type=>sys.XS_ACL.PTYPE_DB) );
 end;
/
or
begin
DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE(
 host => 'www.example.com',                    ****You can change host to  " * " or add the remote connection host.
 ace  =>  xs$ace_type(privilege_list => xs$name_list('connect', 'resolve'),
                      principal_name => 'SCOTT',
                      principal_type => xs_acl.ptype_db));
 end;
/



No comments:

Post a Comment