Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

utl_dbws and https certificate locations

Posted on 2011-02-10
1
1,482 Views
Last Modified: 2012-05-11
I recently completed coding and unit testing calling out to asecure site using utl_dbws; however, instructions from Oracle note to store the webservice certificates in 3 locations when usint utl_dbws to callout to external webservices.  Our systems team has concerns with maintaining so many certificates in so many homes (7).  

They are worried about upgrades and maintenance patches affecting them and having to check and reload these certificates with each upgrade and patch.

We are going to test out removing these certificates to confirm if they're truly needed in all three places, but the systems team would prefer certificate management was centralized as with the Oracle Wallet manager.

It looks like I'll be starting over with this project using utl_http instead of utl_dbws because of this certificate maintenance.

I was wondering if anyone had any experience or feedback on this drawback of using utl_dbws.
0
Comment
Question by:Melodi Roberts
1 Comment
 

Accepted Solution

by:
Melodi Roberts earned 0 total points
ID: 34871286
I will close this. We found that the certificates are only needed in one place. While the Oracle documentaiton notes to load them into three location, they are only needed in the javavm directory.
$ORACLE_HOME/javavm/lib/security/cacerts
$ORACLE_HOME/jdk/jre/lib/security/cacerts
$ORACLE_HOME/jre/1.4.2/lib/security/cacerts
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
PL/SQL Two changes 7 34
Oracle DBLINKS From 11g to 8i 3 47
ORA-02288: invalid OPEN mode 2 56
DECLARATION OF CURSOR IS INCOMPLETE OR MALFORMED 5 18
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
SSL stands for “Secure Sockets Layer” and an SSL certificate is a critical component to keeping your website safe, secured, and compliant. Any ecommerce website must have an SSL certificate to ensure the safe handling of sensitive information like…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question