[Oracle] ORA-29273 HTTP request failed

If you are trying to use oracle to invoke a web service and facing the errors ORA-24247 or ORA-29273, here is an article giving you some solutions.

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

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

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

ORA-06512: at "XXXX.YYYY_PKG_TOOLS", line 379

ORA-06512: at "XXXX.YYYY_PKG", line 66

Solution :

You need to create the ACL, assign it and add privilege.

For this error :

ORA-29273: HTTP request failed

ORA-29024: Certificate validation failure

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

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

ORA-06512: at "SERCA.WEBSERVICE_PKG_TOOLS", line 379

ORA-06512: at "SERCA.WEBSERVICE_PKG", line 66

Solution :

The first step is to retrieve the certificate from the site.

Clic on export on the root certificat and import it to the database server.

You must then create the path to the wallet :

> mkdir -p <dir_wallet>

You must then create the wallet

> orapki wallet create -wallet <dir_wallet> -pwd xxxxx -auto_login

ps : orapki is located in this directory $ORACLE_HOME/oracle_common/bin

Add the certificate to the wallet

> orapki wallet add -wallet <dir_wallet> -trusted_cert -cert "Root CA.crt" -pwd xxxxx