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.
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.
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.
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…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime? I'm talking things like:
* Dropping columns
* Shrinking allocated space
* Removing chained blocks and restoring the PCTFREE
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines