Submitted by dave on Wed, 02/14/2024 - 16:10
Certificates can be a pain.
So if you're trying to use UTL_HTTP or APEX_WEB_SERVICE to reach https destinations you'll be on the hook for obtaining certificates for the target server.
I had access to all the certificates separately and loaded them into a nice fresh new wallet. Unfortunately I couldn't get this to work. I'm working an SR with Oracle now but there doesn't seem to be much expertise on troubleshooting issues, even with
Submitted by dave on Fri, 12/22/2023 - 11:59
if [ -f ~/.bashrc ]; then
while [ true ]
sqlplus -s / as sysdba >> output.txt << EOF
SELECT * FROM DUAL;
Session Serialization Example
Submitted by dave on Mon, 06/19/2023 - 12:43
A script to check the query execution time as well as the time to retrieve all records via a FOR cur IN construct:
Submitted by dave on Wed, 04/27/2022 - 10:16
I run a few websites from a VM on my Synology NAS. The VM has the typical LAMP setup for running Wordpress and Drupal sites. As it is not exposed directly to the internet, Apache serves up all sites on port 80 and I configured the Synology "Application Portal" to forward both port 80/443 requests to it. Application Portal (nginx behind the curtain) also provides handling of SSL Certs on port 443.
So I created 2 Synology Application Portal entries - one to for serving up incoming 80 to ApacheHost:80, and one for serving up incoming 443 to ApacheHost:80.
Submitted by dave on Wed, 11/10/2021 - 11:35
I opened an SR recently while I was trying to get a feature to work in 19c... was politely directed to this resource... A listing of Oracle features and what version they're available in...
Not sure when this was made available but I hope they keep it up - I much prefer this to trying to find this info in My Oracle Support docs.
Apex App - Features and Licensing Lookup
Submitted by dave on Mon, 11/02/2020 - 17:11
There are some impressive new features in 20.2. unfortunately my latest upgrades are not going so well.
I see we've got a bundle patch already! Patch 32006852: PSE BUNDLE FOR APEX 20.2 (PSES ON TOP OF 20.2.0.00.20)... But I don't see any of the issues I encountered being addressed.
From most to least severe:
1) ORDS 19.1 munged 3 times over 3 installs
Submitted by dave on Mon, 05/18/2020 - 12:50
As we move on to 12.2 and 19c we're seeing more instances where simple schema export/import migrations are missing objects on the target database.
If you do object counts after a simple schema migration... Or see something like this pop up in your impdp logs:
Submitted by dave on Fri, 02/14/2020 - 13:24
Create keystore with a self signed cert
keytool -genkey -keystore /path/keystore.jks -alias selfsigned -keyalg RSA -keysize 4096 -validity 720
Enter details for cert and enter password = password123
Update Tomcat server.xml
Should return this:
Submitted by dave on Wed, 02/06/2019 - 16:10
If you are getting odd abends on your Golden Gate replicats due to trail file corruption, make sure you visit your filesystem options for the filesystem where the manager process writes the trail files.
Long story short is that we were finding large swaths of Zeroes appearing in our trail files. Using logdump I could see the header of the trail file was OK, but somewhere down the line a valid record would be followed by straight up zeroes. Lots of them. I verified this using logdump and a hex editor.
Submitted by dave on Mon, 10/22/2018 - 23:11
I find Encryption is blamed for a lot of performance issues so wanted to find out for myself how much of a performance hit we might be taking for common operations. There ain't no free lunch. Adding any extra processing or manipulation to an operation is going to add time to that operation.