My Learning

In the middle of 11.2.0.4 upgrade to 19c with auto upgrade i deleted flash back log files due to space constraints. Forgot to include parameter ( apx .restoration=no )  to instruct autoupgrade utility not to do a guaranteed restore point. Autoupgrade had following error upg>  ------------------------------------------------- Errors in database [APX] Stage     [DBUPGRADE] Operation [STOPPED] Status    [ERROR] Info    [ Error: UPG-1401 Opening Database APX in upgrade mode failed Cause: Opening database for upgrade in the target home failed. For further details, see the log file located at /home/oracle/APX/APX/101/autoupgrade_20200614_user.log] ------------------------------------------------- Logs: [/home/oracle/APX/APX/101/autoupgrade_20200614_user.log] autoupgrade_20200614_user.log had this detailed error 2020-06-14 21:02:52.419 ERROR  DATABASE NAME: APX       ...

After upgrading 11.2.0.4 to 19c with apex 20.1 accessing apex_admin/apex pages was throwing “Error processing request” Contact your application administrator. There were three invalid objects for APEX_200100 WWV_FLOW_SESSION_RAS WWV_FLOW_WIZARD_API WWV_FLOW_DATA_LOADER Tried compiling these objects but compile was completing with PL/SQL: ORA-00942: table or view does not exist To resolve the issue following rant needs to be given then compile (ran both grant and compile as sysdba) grant select on SYS.DBA_XS_DYNAMIC_ROLES to APEX_200100; grant select on SYS.DBA_TAB_IDENTITY_COLS to APEX_200100; alter package APEX_200100.WWV_FLOW_SESSION_RAS compile body; alter package APEX_200100.WWV_FLOW_WIZARD_API compile body; alter package APEX_200100.WWV_FLOW_DATA_LOADER compile body; Returned 0 invalid object for APEX_200100  select * from dba_objects where status = 'INVALID' and owner = 'APEX_200100' ; Now both admin and apex pages ar...