SQL Developer New Direction - Installing in a secure environment...

I'm a fan of SQL Developer, have been for years. I especially like User Defined Reports.
Time for some shameless self promotion!


  • Here is a presentation I gave to East Coast OUG on 2014 - SQL Developer Reporting. It covers general SQL Developer reporting features and a deep dive into User Defined Reports.

The dreaded ORA-29024: Certificate validation failure... how to approach...

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

Recording query output in a self contained shell script...

General form

#!/bin/bash
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1
export ORACLE_SID=orclcdb1
export PATH=$ORACLE_HOME/bin:$PATH

while [ true ]
do
  sqlplus -s / as sysdba  >> output.txt << EOF
SELECT * FROM DUAL;
EXIT
EOF
  sleep 10
done

Session Serialization Example

Quick and dirty query timing script...

A script to check the query execution time as well as the time to retrieve all records via a FOR cur IN construct:

ERR_TOO_MANY_REDIRECTS with Synology Application Portal

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.

Helpful Oracle Feature Matrix by RDBMS Version

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

Fauxtary.1 Progress...

Have been making decent progress on the Fauxtary.1 MIDI controller.

I decided to have v1 be a supplement to my Traktor S8 DJ controller, not a replacement. This will allow me to flesh out all the basics first via a simpler prototype.

I have a case, cables, aluminum knobs, and some beefy ALPS Potentiometers on order. Once they get here I'll have some more content to post.

Fauxtary DJ Mixer v1 - MIDI Enabled

Purpose:

  • Build a MIDI enabled mixer controller to replicate the controls of a rotary mixer.
  • Intended use is for DJ programs that accept Midi input (like Native Instruments Traktor).
  • This will not replace a full fledged DJ controller, just provide rotary controls for controlling the mixes.

Description:
I always liked playing gigs on old school rotary mixers, Bozak AR-6, Urei 1620, Rane MP2016, ARS 6700 - the battle hardened workhorses of the club world.
While working with modern DJ controllers I was missing the feel of these mixers.

Apex 20.2 Upgrade experience...

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

impdp too smart for its own good - ORA-2000 and missing indexes on target...

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:

Pages

Subscribe to ba6.us RSS