Enabling Unified Auditing mode

In Oracle Database 12c, unified auditing is not enabled by default. The process of enabling it is simple and equivalent to enabling of other database options.

Getting ready

To complete this recipe, you'll need to shut down the database.

How to do it...

The process of enabling unified auditing is depicted in Figure 3.

How to do it...

Figure 3

  1. In our case, there is only one database instance. Connect to the instance as sysoper and shut it down. Also, stop the listener:
    $ sqlplus / as sysoper
    
    SQL> shutdown immediate
    SQL> exit
    $ lsnrctl stop
    
  2. Relink Oracle binaries with the uniaud_on option:
    $ cd $ORACLE_HOME/rdbms/lib $ make -f ins_rdbms.mk ...

Get Oracle Database 12c Security Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.