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.

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:

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:

Quickly create and implement a self signed cert for Tomcat...

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

Verify

Golden Gate abends due to zeroed out records in trail file...

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.

Connection encryption is killing my performance! Help!

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.

Where can encryption be enabled when working with an Oracle database?

For Oracle there are two places to introduce encryption:

Algorithm preference in SQLNET.ENCRYPTION_TYPES_SERVER

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, a SQLNet client side trace shows the following possibilities, the choices are listed from most secure to least secure:
(3775811968) [04-OCT-2018 19:47:44:284] nam_gic: Counting # of items in "SQLNET.ENCRYPTION_TYPES_CLIENT" parameter
(3775811968) [04-O

emcli, python, jython, and module not found (ImportError No Module Named n)

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 gets done. You feed a Python script to emcli and magic happens right?

Adeesh Fulay has a great intro article here.

Pages

Subscribe to ba6.us RSS