nerdexam
Oracle

1Z0-062 · Question #204

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: $…

The correct answer is C. Shutdown the database instance E. Stop the listener. Enabling unified auditing requires relinking the Oracle binary, which means both the database instance and the listener must be stopped before running the make command.

Implementing Oracle Database Auditing

Question

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?

Options

  • AEnsure that the initialization parameter AUDIT_TRAIL is set to DB.
  • BDisable auditing by setting the initialization parameter AUDIT_TRAIL to NONE.
  • CShutdown the database instance
  • DDrop any existing fine-grained audit (FGA. policies
  • EStop the listener.

How the community answered

(51 responses)
  • A
    6% (3)
  • B
    4% (2)
  • C
    80% (41)
  • D
    10% (5)

Why each option

Enabling unified auditing requires relinking the Oracle binary, which means both the database instance and the listener must be stopped before running the make command.

AEnsure that the initialization parameter AUDIT_TRAIL is set to DB.

AUDIT_TRAIL=DB is a conventional auditing initialization parameter and is not a prerequisite for the make relinking command that enables unified auditing.

BDisable auditing by setting the initialization parameter AUDIT_TRAIL to NONE.

Setting AUDIT_TRAIL to NONE before relinking is not required; the relinking process handles the auditing mode transition independently of the current AUDIT_TRAIL value.

CShutdown the database instanceCorrect

The Oracle binary must be relinked to switch to unified auditing mode, and you cannot relink an executable that is actively in use by a running database instance; the instance must be shut down first.

DDrop any existing fine-grained audit (FGA. policies

Existing fine-grained audit policies do not need to be dropped before relinking; they are preserved and can coexist after unified auditing is enabled.

EStop the listener.Correct

The Oracle Net listener also references the Oracle binary, so it must be stopped before relinking; attempting to relink while the listener is active can cause errors or leave the listener in an inconsistent state.

Concept tested: Enabling unified auditing via Oracle binary relinking

Source: https://docs.oracle.com/database/121/DBSEG/uniaud.htm

Topics

#unified auditing#database shutdown#listener stop#auditing configuration

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice