ACL

Posted by big on Sep 14, 2021; 2:57pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/ACL-tp10265.html

Hi,
on R12.2.4 DB 11.2.0.4, on AIX
I want  to run PL/SQL code making calls to the following Oracle Supplied Packages without error.
UTL_HTTP.
I follow: ORA-24247 Using UTL_TCP, UTL_HTTP, UTL_SMTP And UTL_MAIL With 11gR1 Or Later (Doc ID 1209644.1)
IT suggests to run:
BEGIN
  DBMS_NETWORK_ACL_ADMIN.create_acl (
    acl          => 'local_sx_acl_file.xml',
    description  => 'A test of the ACL functionality',
    principal    => 'WC',
    is_grant     => TRUE,
    privilege    => 'connect',
    start_date   => SYSTIMESTAMP,
    end_date     => NULL);
end;

begin
  DBMS_NETWORK_ACL_ADMIN.assign_acl (
    acl         => 'local_sx_acl_file.xml',
    host        => 'localhost',
    lower_port  => 9002,
    upper_port  => NULL);    
end;

My questions are:
Which server is host? EBS application server? DB server or others?
Which port ?
Do we need also  "resolve" privilege?
Thanks.