Solved

utl_dbws and https certificate locations

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

863 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

24 Experts available now in Live!

Get 1:1 Help Now