Hello Everyone,
an Oracle newbie needs your help.
I have a CAS-Server (Central Authentication Service) running on my domain „sub.mydomain.com" and an Oracle 11g Database. On the CAS-Server I generated and use a keystore for HTTPS access. (keytool -genkeypair -alias sub.mydomain.com -keyalg RSA -keysize 1024 -dname "CN= sub.mydomain.com, OU=Organization, O=Company Name, L=City, S=State, C=US" -validity 365 -keystore .keystore)
By entering https://sub.mydomain.com:8443/cas/ in the web browser I can access the page after downloading and adding the certificate (saved as sub.mydomain.com.crt with Firefox).
Now I'd like to obtain XML-Code of this HTTPS Site with PL/SQL. Therefor I used the function utl_http.request(). The Oracle documentation says when fetching data from a Website using HTTPS, wallets are required. So I imported the recently downloaded certificate as a trusted certificate to the wallet manager and saved the wallet. Since I am using Oracle 11g I had also to create a new ACL-list. I followed this description: http://oraclepoint.com/oralife/2010/10/08/configuring-wallet-manager-to-enable-https-connect-with-oracle-11g-database/
The PL/SQL command I used obtaining XML from the HTTPS-Server: returndata := utl_http.request('https://sub.mydomain.com:8443/', null, [path/to/oracle/wallet], [wallet_password]);
Running this code I get the error:
ORA-29273: HTTP request failed
ORA-06512: at „SYS.UTL_HTTP“, line 1130
ORA-29024: Certificate validation failure
ORA-06512: at line 12
Does anyone have an idea why it is not working?
I hope I mentioned all relevant information and configuration steps. If not, please let me know and I'll add them.
I'd be very grateful for any help.
Thanks and best regards
Melolo