Stack Overflow
Stack Overflow

Questions tagged [ora-24247]

network access denied by access control list (ACL)

23 questions
4
votes
1 answer

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

I am using soap_api as in the link http://www.oracle-base.com/articles/9i/ConsumingWebServices9i.php. I was able to call a web service in Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod PL/SQL Release 10.2.0.1.0 - Production "CORE…
paramupk
  • 626
  • 1
  • 11
  • 32
4
votes
1 answer

Network access denied by access control list (ACL) in Oracle Database 11g

Recently we have switched from Oracle 10g to 11g, and only now I noticed that my mailing function does not work, I now get an error: ORA-24247: network access denied by access control list (ACL) So I did a bit of googling and was able to figure out…
K.I
  • 568
  • 1
  • 6
  • 19
4
votes
5 answers

Get IP addresses of established connections to Oracle 11

During development I found that database have large number of lived connections by: SELECT username, COUNT(*) FROM v$session GROUP BY username; In order to find who actually hold connection I want to get a list of IP addresses. During general web…
gavenkoa
  • 45,285
  • 19
  • 251
  • 303
3
votes
1 answer

ORA-24247: Access denied by ACL from within PL/SQL function but NOT from SQL

I've successfully set up the ACL for my user and URL. I confirm this by running: select utl_http.request(*my URL*) from dual; which returns the corresponding HTML code. However, when I place this code inside a PL/SQL function, as follows: create…
João Lovegrove
  • 33
  • 6
3
votes
1 answer

Oracle 12c Apex 4.2 ORA-24247 network access denied by access control list (ACL)

hope you can help me too. I'm developing an APEX-Application. Oracle 12c APEX 4.2. I'm using the workspace wrk_projects in pdborcl. I need some information about the client. The client will act in the same domain. So I'm building a report: …
oradev2015
  • 51
  • 1
  • 6
2
votes
2 answers

ORA-24247: network access denied by access control list (ACL) while sending email oracle

i have done all the activity i.e mention below, please tell which step / activity i am missing. BEGIN DBMS_NETWORK_ACL_ADMIN.CREATE_ACL( acl => 'apex_user.xml', …
AbdulRaheem
  • 115
  • 2
  • 15
2
votes
2 answers

Access denied by ACL in Oracle APEX 5.0

May be this is a common problems,but I have googled it and post it in some forums but I still didn't get the answer.. I have a problem with my ACL. I was following this tutorial http://dbtricks.com/?p=159 and everything works fine. But when I made…
twindicated70
  • 109
  • 1
  • 2
  • 10
2
votes
0 answers

ORA-24247 ACL access denied in oracle 11g even after configuring ACL

I have a case where a user should access a specific url inside a local network of the form 192.168.19.*. Although he has the appropriate grants on EXECUTE for UTL_HTTP and priviledges in acl list, still he can't access the urls allowed in the…
JazzBass
  • 21
  • 1
  • 3
2
votes
1 answer

ORA-24247 when using utl_http.read_text. Only appear after a delay of about 60 seconds

I am using the following code to read the response of an http request: FUNCTION readClob (ww_reponse IN OUT NOCOPY UTL_HTTP.resp) RETURN CLOB IS l_clob CLOB; l_text VARCHAR2 (32767); BEGIN …
Stéphane Gerber
  • 1,388
  • 1
  • 17
  • 30
1
vote
0 answers

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

BEGIN DBMS_NETWORK_ACL_ADMIN.APPEND_HOST_ACE ( host => '127.0.0.1', lower_port => null, upper_port => null, ace => xs$ace_type(privilege_list => xs$name_list('jdwp'), principal_name => 'SYSTEM', principal_type => xs_acl.ptype_db) …
AlbertAlex
  • 57
  • 8
1
vote
1 answer

How to solve ORA-24247: network access denied by access control list (ACL) in Oracle stored procedure

I have an Oracle 11g stored procedure that takes a text address and returns latitude and longitude using a Google API. This procedure uses oracle's utl_http feature. Reading the Oracle documentation on using this feature, I saw that it is necessary…
Gustavo de Freitas
  • 99
  • 2
  • 15
1
vote
2 answers

ACL error when trying to send mail via Oracle UTL_SMTP

I was trying to send an email via oracle utl_smtp, but every time i execute the apex_mail_p.mail procedure i get an ACL error, to be more precise it's the error ORA-24247. But i've created the acl, added the right previliege and also added the host…
João Abrantes
  • 25
  • 1
  • 7
1
vote
1 answer

ORA-24247 Oracle ACLs on UTL_HTTP on Linux

I have created an ACL to access a web server from a Oracle XE 11GR2 user on Windows, and using UTL_HTTP.request() works fine. I have created the same ACL in an Oracle Enterprise 11GR2 DB user on a Linux Redhat server, but the command…
odeleon
  • 11
  • 1
1
vote
1 answer

invoking webservice from inside pl/sql

I have the user name under ACl and acl has been assigned to host. but I am getting error http_req filed on trying to connact ACL has been assigned to host SELECT * FROM dba_network_acls; 1 *.mer.com /sys/acls/fine_grain_access_http.xml …
Prashant Mishra
  • 619
  • 9
  • 25
1
vote
0 answers

Calling HTTP pages from Plsql

I am trying to call a page from PLSQL declare httprequest UTL_HTTP.req; httpresp UTL_HTTP.resp; v_http_url VARCHAR2 (200) := 'http://localhost:38801/BatchMvcDriver/Index?ID=161'; begin httprequest :=…
MKN
  • 497
  • 3
  • 8
  • 24
1
2