In this scenario, we’ll explore how to leverage mix mode auditing in Oracle Unified Auditing. Follow along as we guide you through the process step by step.

1. Verifying Unified Auditing

First, let’s verify that unified auditing is not enabled by default. Open your SQL*Plus session as a privileged user:

sqlplus / as sysdba

Then, execute the following SQL query to check the status of unified auditing:

SQL> SELECT parameter, value FROM v$option WHERE parameter = ‘Unified Auditing’;

If the output displays a ‘FALSE’ value, it indicates that unified auditing is available but not enabled by default. In this scenario, ‘FALSE’ value will not make any problem.

2. Checking Predefined Audit Policy

Next, let’s check the existence of the predefined ORA_SECURECONFIG audit policy

SQL> SELECT policy_name, audit_option FROM audit_unified_policies
WHERE policy_name = ‘ORA_SECURECONFIG’ ORDER BY audit_option;

This output will confirm whether the ORA_SECURECONFIG audit policy exists in your database.

3. Verifying Policy Status

Now, verify that the predefined ORA_SECURECONFIG audit policy is enabled by default

SQL> SELECT policy_name FROM audit_unified_enabled_policies WHERE policy_name = ‘ORA_SECURECONFIG’;

Ensure that the policy is listed, indicating that it’s enabled.

4. Verifying Audit Parameters

Finally, let’s verify all audit parameters at the instance level:

SQL> SHOW PARAMETER AUDIT;

This command will display all audit-related parameters configured for your database instance.

By following these steps, you can ensure that Oracle Unified Auditing is configured and available for use in mix mode within your database environment.