Oracle Database 12c: Installation and Administration — Question 12

Your single-instance Oracle 12c database home currently supports conventional auditing and uses Automatic Storage Management (ASM). You want to enable unified auditing by executing the command:
$ make fins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME
Which two steps should you perform before executing this command? (Choose two.)

Answer options

• A. Ensure that the initialization parameter AUDIT_TRAIL is set to DB.
• B. Drop any existing fine-grained audit (FGA) policies.
• C. Stop the listener.
• D. Shut down the database instance.
• E. Disable auditing by setting the initialization parameter AUDIT_TRAIL to NONE.

Correct answer: C, D

Explanation

The correct actions are to stop the listener and shut down the database instance before enabling unified auditing. The listener must be stopped to ensure no connections are active, and the database instance needs to be shut down to apply the changes safely. The other options are either irrelevant or not required to enable unified auditing.