[et_pb_section fb_built=”1″ _builder_version=”4.24.2″ _module_preset=”default” custom_padding=”11px|||||” global_colors_info=”{}”][et_pb_row _builder_version=”4.24.2″ _module_preset=”default” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.24.2″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.24.2″ _module_preset=”default” global_colors_info=”{}”]
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.
[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section]