Does anyone have insights on why one would work and the other would error out? Firewall port has been opened, but the same error is being received as was received before the error.
SQL> connect …
Enter password:
- Connected.
SQL> BEGIN
2 DBMS_NETWORK_ACL_ADMIN.append_host_ace
3 (host =>
'x.y.com',
4 lower_port => 10036,
5 upper_port => 10036,
6 ace => xs$ace_type
7 (privilege_list => xs$name_list('CONNECT','RESOLVE'),
8 principal_name => 'CVC',
9 principal_type => xs_acl.ptype_db));
10 END;
11 /
BEGIN
*
ERROR
at line 1:
ORA-24244:
invalid host or port for access control list (ACL) assignment
ORA-06512:
at "SYS.DBMS_NETWORK_ACL_ADMIN", line 1072
ORA-06512:
at line 2
SQL> BEGIN
2 DBMS_NETWORK_ACL_ADMIN.append_host_ace
3 (host =>
'x.y.com',
4 lower_port => 10036,
5 upper_port => 10036,
6 ace => xs$ace_type
7 (privilege_list => xs$name_list('CONNECT'),
8 principal_name => 'CVC',
9 principal_type => xs_acl.ptype_db));
10 END;
11 /
PL/SQL
procedure successfully completed.
SQL> BEGIN
2 DBMS_NETWORK_ACL_ADMIN.append_host_ace
3 (host =>
'x.y.com',
4 lower_port => 10036,
5 upper_port => 10036,
6 ace => xs$ace_type
7 (privilege_list => xs$name_list('resolve'),
8 principal_name => 'CVC',
9 principal_type => xs_acl.ptype_db));
10 END;
11 /
BEGIN
*
ERROR
at line 1:
ORA-24244:
invalid host or port for access control list (ACL) assignment
ORA-06512:
at "SYS.DBMS_NETWORK_ACL_ADMIN", line 1072
ORA-06512:
at line 2