Oracle Database Discussions

Dear All,

Need your help please.

Am facing ora 24247 network access denied (ACL) even after following the below procedure. It was working fine until today when i just dropped and recreate again.

BANNER

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

PL/SQL Release 11.2.0.1.0 - Production

CORE 11.2.0.1.0 Production

TNS for 64-bit Windows: Version 11.2.0.1.0 - Production

NLSRTL Version 11.2.0.1.0 - Production

Steps:

Created an ACL with one database user and granted connect, resolve privilege.

begin

  dbms_network_acl_admin.create_acl ( 

    acl         => 'utl_http.xml',

    description => 'HTTP Access',

    principal   => 'TPAUSER',

    is_grant    => TRUE,

    privilege   => 'connect',

    start_date  => null,

    end_date    => null);

  dbms_network_acl_admin.add_privilege (

  acl => 'utl_http.xml',

  principal  => 'TPAUSER',

  is_grant   => TRUE,

  privilege  => 'connect',

  start_date => null,

  end_date   => null); 

   dbms_network_acl_admin.add_privilege (

  acl => 'utl_http.xml',

  principal  => 'TPAUSER',

  is_grant   => TRUE,

  privilege  => 'resolve' );

  dbms_network_acl_admin.assign_acl (

  acl => 'utl_http.xml',

  host=> '*',

  lower_port => 80,

  upper_port => 80); 

  commit; 

end;

Confirmed the ACL setup.

select * from dba_network_acls;

select host, lower_port, upper_port, acl from dba_network_acls where ACL='/sys/acls/utl_http.xml';

HOST      LOWER_PORT  UPPER_PORT  ACL

*               80                         80               /sys/acls/utl_http.xml

SELECT ACL,PRINCIPAL,PRIVILEGE,IS_GRANT FROM dba_network_acl_privileges where principal='TPAUSER'

--grant execute on utp_http to TPAUSER;

On executing the procedure i faced the below error message. Not sure which step i missed here.

ORA-29261: bad argument

ORA-06512: at "SYS.UTL_HTTP", line 1525

ORA-06512: at "TPAUSER.SEND_SMS_NEW", line 70

ORA-24247: network access denied by access control list (ACL)

ORA-06512: at line 18

Yours valuable support and assistance to get this issue resolved will be highly appreciated.

Regards,

Syed