Enable or disable Unified audit in Oracle 12c

Enable or disable Unified audit in Oracle

Enable the Unified Audit in Oracle Database

1. Check the unified audit is disable.

select parameter,value from v$option where parameter = 'Unified Auditing';

PARAMETER            VALUE
-------------------- ----------
Unified Auditing     FALSE

2. Shutdown and stop all the services related to Oracle Binaries.


sqlplus / as sysdba
shutdown immediate
exit

lsnrctl stop


cd /u01/app/oracle/product/middleware/oms
export OMS_HOME=/u01/app/oracle/product/middleware/oms
$OMS_HOME/bin/emctl stop oms

3. Enable the Unified auditing from Oracle Binaries.

cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk uniaud_on ioracle

4. Start the database

Startup

lsnrctl start


emctl start oms

5. Check the auditing is enabled

select parameter,value from v$option where parameter = 'Unified Auditing';


PARAMETER VALUE
-------------------- ----------
Unified Auditing TRUE

Disable the Unified audit in Oracle 12c

1. Check Unified auditing is enabled.

select parameter,value from v$option where parameter = 'Unified Auditing';


PARAMETER            VALUE
-------------------- ----------
Unified Auditing     TRUE


2. Checked the enabled policies present in Oracle Database.

select user_name,policy_name,enabled_opt,success,failure from audit_unified_enabled_policies;

3. Disable that enabled policies by running output of the following query.

select 'noaudit policy '||policy_name||';' from audit_unified_enabled_policies;

4. Shutdown and stop all related oracle Services.

-- Shutdown the database
sqlplus / as sysdba
shutdown immediate
exit
--Stop the listener
lsnrctl stop
--- stop the OMS service
cd /u01/app/oracle/product/middleware/oms
export OMS_HOME=/u01/app/oracle/product/middleware/oms
$OMS_HOME/bin/emctl stop oms

5. Disable the unified audit with libraries from Oracle Binaries.

cd $ORACLE_HOME/rdbms/lib
make -f ins_rdbms.mk uniaud_off ioracle

6. Start the database

--Start the database
Startup
--Start the listener
lsnrctl start
--Start the OMS service
emctl start oms

7. Verify the unified audit is disabled

select parameter,value from v$option where parameter = 'Unified Auditing';

PARAMETER            VALUE
-------------------- ----------
Unified Auditing     FALSE

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.