Logger - Oracle Database

Oracle Database

1. Edit the Oracle initialization parameter file:

   ALTER SYSTEM SET log_checkpoints_to_alert = TRUE;
   ALTER SYSTEM SET log_archive_trace = 1;
   ALTER SYSTEM SET audit_trail = DB,EXTENDED SCOPE=SPFILE;
   -- Note: audit_trail applies to legacy (non-unified) auditing mode only and is desupported in Oracle 23c.
   -- For Oracle 12c+ with Unified Auditing enabled, use:
   --   CREATE AUDIT POLICY all_actions ACTIONS ALL;
   --   AUDIT POLICY all_actions;
   

2. Restart the Oracle Database:

   SHUTDOWN IMMEDIATE;
   STARTUP;