I have an open SR with support, but it seems to be going nowhere.
I'm trying to connect to an office 365 API in order to read emails.
I saved all the certs from here in a wallet
https://login.microsoftonline.com/en C:\>orapki wallet display -wallet D:\Oracle\Wallets
Oracle PKI Tool : Version 12.2.0.1.0
Copyright (c) 2004, 2016, Oracle and/or its affiliates. All rights reserved.
Enter wallet password:
Requested Certificates:
User Certificates:
Trusted Certificates:
Subject: CN=stamp2.login.microsoftonline.com
Subject: CN=Baltimore CyberTrust Root,OU=CyberTrust,O=Baltimore,C=IE
Subject: CN=Microsoft IT TLS CA 4,OU=Microsoft IT,O=Microsoft Corporation,L=Redmond,ST=Washington,C=US
I cannot connect.. I've tried all DNS in alternate names
DECLARE
req varchar2(5000);
wallet_loc varchar2(100) := 'file:D:\Oracle\Wallets';
begin
utl_http.set_wallet(wallet_loc,'xxxxxx');
req := UTL_HTTP.REQUEST(url=>'
https://login.microsoftonline.com/en', https_host=>'stamp2.login.microsoftonline.com');
end;
Error report -
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1501
ORA-24263: Certificate of the remote server does not match the target address.
ORA-06512: at "SYS.UTL_HTTP", line 380
ORA-06512: at "SYS.UTL_HTTP", line 1441
ORA-06512: at line 6
29273. 00000 - "HTTP request failed"
*Cause: The UTL_HTTP package failed to execute the HTTP request.
*Action: Use get_detailed_sqlerrm to check the detailed error message.
Fix the error and retry the HTTP request.
Any help would be great. I'm starting to consider using java to call the web service as I'm losing faith in utl_http
Thanks,
Scott