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:
Which two steps should you perform before executing this command?
A. Ensure that the initialization parameter AUDITTRAIL is set toDB.
B. Drop any existing fine-grained audit (FGA) policies.
C. Stop the listener,
D. Shit down the database instance.
E. Disable auditing by setting the initialization parameter AUDIT_TRAIL to NONE,
|
Download Printable PDF. VALID exam to help you PASS. |
 |
CORRECT ANSWERS: CD
Reference: https://docs.oracle.com/database/121/TDPSG/GUID-BF747771-01D1-4BFB-8489-08988E1181F6.htm#GUID-9F687165-559C-4C7E-9B3F-41BAEFB2DE32
1. Log in to SQL*Plus as user SYS with the SYSDBA administrative privilege.
2. Find out if your database has been migrated to use unified auditing. (if not, complete the remaining steps)
3. Stop the database
4. Stop the listener. (Stopping the listener is not necessary for Oracle RAC and Grid Infrastructure listeners.)
5. Go to the $ORACLE_HOME/rdbms/lib directory
6. Enable the unified auditing executable (make -f ins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME)
7. Restart the listener
8. Restart the database
The below reference:
https://docs.oracle.com/database/121/REFRN/GUID-BD86F593-B606-4367-9FB6-8DAB2E47E7FA.htm#REFRN10006
AUDIT_TRAIL -> Note: In an Oracle database that has migrated to unified auditing, the setting of this parameter has no effect