I had heard from a fellow DBA colleague that a known problem with Oracle Databases on AWS was that, in certain cases, the SYS user was not available to the DBA. Curious (and slightly alarmed), I did a little research online and discovered more than a few forum posts asking what to do about the apparent inability to execute common DBA tasks as SYS running Oracle Database on AWS. DBAs who were accustomed to being able to run DBMS_CRYPTO or install APEX from the command line were wondering how to get their work done in the cloud. In response, AWS had … Read More
Between a rock and a hard place: How does Oracle bug 28793062 affect Banner schools’ plans to upgrade to 18c?
12.2.0.2 was renamed 18c following Oracle’s new naming convention. “18” for its 2018 release (cloud: 18.1.0 in 2/18 and on-premises: 18.3.0 on 7/18). In October of 2018, Ellucian rescinded support for 12.2.0.2, AKA 18c due to a severe defect. Some PL/SQL procedures in Banner including arguments based on table%rowtypes would no longer compile, complaining that a “PL/SQL package with user-defined type is throwing PLS-00801: [Unexpected Fragile External Reference.])”… and there was no workaround. Ellucian’s rescission of support for 18c with Banner came at a tricky time for schools. IT departments were already feeling pressure to stay on top of upgrades … Read More