I have checked mentioned three points. Followings are my observations:
I can create self signed certificate of url
https://drive.google.com/file/d/1nmYo8a5It613poK7bPGXnmRhfRVWarAQ/view through chrome browser, but in real scenario i will have trusted CA certified certificate. so i download trusted certificate through internet
link :
https://cacert.omniroot.com/bc2025.crt and add it in oracle wallet
through following query:
C:\Users\dataguise>orapki wallet add -wallet d:\orawallet -trusted_cert -cert "C:\Users\dataguise\Downloads\bc2025.crt" -pwd WalletPasswd789
Oracle PKI Tool : Version 11.2.0.3.0 - Production
Copyright (c) 2004, 2011, Oracle and/or its affiliates. All rights reserved.
I have added ACl also
BEGIN
DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(acl => 'www.xml',
description => 'WWW ACL',
principal => 'TEST1_SHUBHAM',
is_grant => true,
privilege => 'connect');
DBMS_NETWORK_ACL_ADMIN.ADD_PRIVILEGE(acl => 'www.xml',
principal => 'TEST1_SHUBHAM',
is_grant => true,
privilege => 'resolve');
DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(acl => 'www.xml',
host => 'http://cacert.omniroot.com/bc2025.crt');
END;
and execute following query
SELECT utl_http.request('http://cacert.omniroot.com/bc2025.crt') from dual;
same is visible on dba_network_acls
SELECT host, lower_port, upper_port, acl FROM dba_network_acls;
So i came to point that i have already taken care of all three points mentioned in your thread.
Please suggest me the way forward.
February 27, 2020 - 11:16 am UTC
You'll need an ACL in place to talk to drive.google.com too, won't you?
What happens if you try a http request to drive.google.com instead of loadjava - does this work?
If you can read files from Drive in some other way, but not through loadjava I'm not sure what the issue is. Take it up with support.