I make unpleasing sequences of 0s and 1s into pleasing sequences of 0s and 1s.
After 20 years this blog has progressed from HTML to Wordpress to Drupal and now to a Static Site Generator (https://getpublii.com). I'll be working on migrating blog content and recreating the Notebook references. In the meantime the archived site is available at https://old.ba6.us temporarily. I…
For troubleshooting it can be helpful to verify the version of code committed to a system. Once we know the version of code we can check for any bug fixes in newer versions - or determine if this is new exciting bug that needs to…
I’ve seen it done on Oracle before like replicating 11 -> 10 or 11->9. The intermediate format for GoldenGate has been standard forever, so as long as you have GG binaries certified to connect to each database then theoretically it should be possible to get…
I'm a fan of SQL Developer, have been for years. I especially like User Defined Reports. It looks like SQL Developer is moving away from the current Java Standalone App towards a Microsoft VS Code Plugin model. Jeff Smith has a Blog Post from Jan…
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…
A script to check the query execution time as well as the time to retrieve all records via a FOR cur IN construct: SET FEEDBACK OFF SET HEADING OFF SET LINESIZE 32000 SET PAGESIZE 0 SET TERMOUT OFF SET TRIMSPOOL ON SET SERVEROUTPUT ON ALTER…
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…
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…
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…
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:…
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 <Connector port="8443" protocol="org.apache.coyote.http11.Http11NioProtocol" maxThreads="150" SSLEnabled="true" scheme="https" secure="true" clientAuth="false" sslProtocol="TLS" keyAlias="selfsigned" keystoreFile="/path/keystore.jks" keystorePass="password123" /> Verify https://192.168.1.10:8443/ Should return…
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…
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…
If you have clients connecting to a server and the clients don't specify a specific encryption algorithm in SQLNET.ENCRYPTION_TYPES_CLIENT, be aware that the order of the algorithms listed in SQLNET.ORA on the server side matters... If you don't specify SQLNET.ENCRYPTION_TYPES_CLIENT from a 12.2 client configuration,…
I've been diving into more OEM Automation and collecting information here. While the Oracle example scripts are a great way to find out how to interact with OEM via the emcli and python/jython interface, there doesn't seem to be much info about how this all…