1

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 UTL_HTTP.request() gives the classical error 24247 - network access denied by ACL.
I have checked and rechecked the ACLs definitions and are identical in boths machines. All the Windows, Linux and remote host computers are on the same network. I tested curl from the Linux machine to the remote server and worked OK. Running utl_http.request() in Linux with sys user and worked OK. No proxys.

So 2 questions:

Is the sys user not affected by the ACL rules?

Is something to be done in Linux server not documented, to make this work?.

I read the post where the OID was the problem, but no idea how to check that.

Any tip what to do would be appreciated.

Thanks in advance.

Barbaros Özhan
  • 59,113
  • 10
  • 31
  • 55
odeleon
  • 11
  • 1

1 Answers1

0

Please see "How to configure Access Control List" at:

http://www.oracleflash.com/36/Oracle-11g-Access-Control-List-for-External-Network-Services.html

Above the "How to configure Access Control List", provides an explanation of why you could be receiving the error. It also may be because Oracle is installed on the Windows machine as SYSTEM or similar, either way, creating the ACL via that method should do the job.

Jeff McGettigan
  • 16
  • 1
  • Hi Jeff, I have configured correctly the ACL in both Linux and Windows. I do not understand what you mean by SYSTEM. It is supposed that you should indicate the user or role to give permissions. I think the problem is not in the DB side, but in some Linux variable that the UTL_HTTP looks for before failing, like http_proxy and something like this I read in many of the articles in internet related with this error. – odeleon Mar 29 '16 at 18:26
  • Are you using https - anything involving site certificates? – Jeff McGettigan Mar 29 '16 at 20:51
  • No, just http. The remote server then connects to an external web service using https. – odeleon Mar 30 '16 at 01:20