Solved

utl_dbws and https certificate locations

Posted on 2011-02-10
1
1,456 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

747 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now