Adding and Verifying Root Certificates in Oracle Wallet

The Oracle wallet is already set up on all our servers with the most known root certificates, and the wallet path is already updated in the instance settings. If an additional root certificate needs to be added, you can provide us with the URL, and our team will download the root certificate from the provided URL.

Step 1: Add Root Certificate to Oracle Wallet

  1. Download the Root Certificate:

    • Provide the URL of the root certificate to our team.
    • Our team will download the root certificate from the provided URL and add it to Wallet.
  2. Oracle Wallet Path:

    • /home/oracle/wallet.
    • You can open a ticket for Wallet password.

Step 2: Verify the Root Certificate

You can use the following SQL command to make a REST request and verify that the root certificate has been correctly added to the Oracle Wallet:

SELECT apex_web_service.make_rest_request(
p_url => 'https://partners.betvictor.mobi/en/sports',
p_http_method => 'GET'
) rest_ret
FROM dual;

If the root certificate is correctly added, the request should succeed and return a result.


This command makes a GET request to the specified URL using the apex_web_service.make_rest_request function and returns the result. If the root certificate is correctly added, the request should succeed.

You can call a web service like the following:

DECLARE
l_clob CLOB;
BEGIN
l_clob := APEX_WEB_SERVICE.make_rest_request(
p_url => 'https://partners.betvictor.mobi/en/sports',
p_http_method => 'GET'
);
-- Display the whole document returned.
DBMS_OUTPUT.put_line('l_clob=' || l_clob);
End;

To see the output, ensure that server output is enabled using the following command:

SET SERVEROUTPUT ON;

Additional Resources

For more details and examples, you can refer to the following blog post: APEX_WEB_SERVICE Usage.

  • 1 Users Found This Useful
Was this answer helpful?

Related Articles

ACL

All our servers already have ACLs configured to allow all outgoing traffic, so there’s no need to...