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