Oracle Logon Trigger ReCompile
After having all of this typed up... I had an epiphany. I've seen it mentioned in slightly different context around the web put didn't put it together until now. You need to execute the following grant:

grant administer database trigger to mydba;


This is provided via the DBA role, but I believe a direct grant is necessary to compile the trigger on the fly.