My Learning

  Sending email with UTL_MAIL fails(ORA-24247) when call is made from a procedure. 24247. 00000 -    "network access denied by access control list (ACL)" SHOW parameter smtp NAME             TYPE    VALUE                                         --------------- ------ -------------------------------------------- smtp_out_server string ficticious.com   sending emails with UTL_MAIL.send_attach_varchar2 is working perfectly fine, but wrapping UTL_MAIL.send_attach_varchar2 in a procedure compiles successfully but executing the procedure ends up in ORA-24247 error. Wrapper procedure for UTL_MAIL.send_attach_varchar2 create or replace procedure        snd_email_atch is begin     UTL_MAIL.send_attach_varchar2 (     sender        => 'sendemail@ficticious.com',     recipients    => 'sendemail@ficticious.com',     cc            => 'scandata@ficticious.com',     bcc           => 'sendemail@ficticious.com',     subjec

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          CAUSE: ERROR at Line 8 in [Buffer]          REASON: ORA-38760: This database in

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