{"id":13806,"date":"2019-12-09T06:46:41","date_gmt":"2019-12-09T06:46:41","guid":{"rendered":"https:\/\/dbtut.com\/?p=13806"},"modified":"2019-12-09T06:46:42","modified_gmt":"2019-12-09T06:46:42","slug":"how-to-enable-and-disable-unified-auditing-feature-in-oracle","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/","title":{"rendered":"How To Enable and Disable Unified Auditing Feature in Oracle"},"content":{"rendered":"<h1>Enable Unified Auditing<\/h1>\n<p>Relink is required to enable the new audit mechanism announced with Oracle database 12c (12.1). You can do this as follows.<\/p>\n<p>First, if there is a database running from the relevant Oracle Home directory, the listener services must be shut down.<\/p>\n<p>You can then enable it as follows.<\/p>\n<pre class=\"lang:default decode:true \">[oracle@orcldb01 ~]$ cd $ORACLE_HOME\/rdbms\/lib\n[oracle@orcldb01 lib]$ pwd\n\/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/lib\n[oracle@orcldb01 lib]$ \n[oracle@orcldb01 lib]$ \n[oracle@orcldb01 lib]$ make -f ins_rdbms.mk uniaud_on ioracle\n\/usr\/bin\/ar d \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/lib\/libknlopt.a kzanang.o\n\/usr\/bin\/ar cr \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/lib\/libknlopt.a \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/lib\/kzaiang.o \nchmod 755 \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/bin\n\n - Linking Oracle \nrm -f \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/lib\/oracle\n\/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/bin\/orald  -o \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/lib\/oracle -m64 -z noexecstack -Wl,--disable-new-dtags -L\/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/lib\/ -L\/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib\/ -L\/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib\/stubs\/   -Wl,-E \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/lib\/opimai.o \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/lib\/ssoraed.o \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/lib\/ttcsoi.o -Wl,--whole-archive -lperfsrv12 -Wl,--no-whole-archive \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib\/nautab.o \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib\/naeet.o \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib\/naect.o \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib\/naedhs.o \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/lib\/config.o  -ldmext -lserver12 -lodm12 -lofs -lcell12 -lnnet12 -lskgxp12 -lsnls12 -lnls12  -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lclient12  -lvsn12 -lcommon12 -lgeneric12 -lknlopt `if \/usr\/bin\/ar tv \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/lib\/libknlopt.a | grep xsyeolap.o &gt; \/dev\/null 2&gt;&amp;amp;1 ; then echo \"-loraolap12\" ; fi` -lskjcx12 -lslax12 -lpls12  -lrt -lplp12 -ldmext -lserver12 -lclient12  -lvsn12 -lcommon12 -lgeneric12 `if [ -f \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib\/libavserver12.a ] ; then echo \"-lavserver12\" ; else echo \"-lavstub12\"; fi` `if [ -f \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib\/libavclient12.a ] ; then echo \"-lavclient12\" ; fi` -lknlopt -lslax12 -lpls12  -lrt -lplp12 -ljavavm12 -lserver12  -lwwg  `cat \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib\/ldflags`    -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lngsmshd12 -lnro12 `cat \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib\/ldflags`    -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lngsmshd12 -lnnzst12 -lzt12 -lztkg12 -lmm -lsnls12 -lnls12  -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lztkg12 `cat \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib\/ldflags`    -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lngsmshd12 -lnro12 `cat \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib\/ldflags`    -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lngsmshd12 -lnnzst12 -lzt12 -lztkg12   -lsnls12 -lnls12  -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 `if \/usr\/bin\/ar tv \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/lib\/libknlopt.a | grep \"kxmnsd.o\" &gt; \/dev\/null 2&gt;&amp;amp;1 ; then echo \" \" ; else echo \"-lordsdo12 -lserver12\"; fi` -L\/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/ctx\/lib\/ -lctxc12 -lctx12 -lzx12 -lgx12 -lctx12 -lzx12 -lgx12 -lordimt12 -lclsra12 -ldbcfg12 -lhasgen12 -lskgxn2 -lnnzst12 -lzt12 -lxml12 -lgeneric12 -locr12 -locrb12 -locrutl12 -lhasgen12 -lskgxn2 -lnnzst12 -lzt12 -lxml12 -lgeneric12  -lgeneric12 -lorazip -loraz -llzopro5 -lorabz2 -lipp_z -lipp_bz2 -lippdcemerged -lippsemerged -lippdcmerged  -lippsmerged -lippcore  -lippcpemerged -lippcpmerged  -lsnls12 -lnls12  -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lsnls12 -lunls12  -lsnls12 -lnls12  -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lasmclnt12 -lcommon12 -lcore12  -laio -lons  -lfthread12   `cat \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib\/sysliblist` -Wl,-rpath,\/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib -lm    `cat \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib\/sysliblist` -ldl -lm   -L\/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib `test -x \/usr\/bin\/hugeedit -a -r \/usr\/lib64\/libhugetlbfs.so &amp;amp;&amp;amp; test -r \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/lib\/shugetlbfs.o &amp;amp;&amp;amp; echo -Wl,-zcommon-page-size=2097152 -Wl,-zmax-page-size=2097152 -lhugetlbfs`\ntest ! -f \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/bin\/oracle || (\\\n\t   mv -f \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/bin\/oracle \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/bin\/oracleO &amp;amp;&amp;amp;\\\n\t   chmod 600 \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/bin\/oracleO )\nmv \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/lib\/oracle \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/bin\/oracle\nchmod 6751 \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/bin\/oracle<\/pre>\n<p>Then, you can start all the services running from the related Oracle home.<\/p>\n<h1>Check Unified Auditing is Enabled<\/h1>\n<p>You can see that it is enabled with the following query.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; SELECT VALUE FROM V$OPTION WHERE PARAMETER = 'Unified Auditing';\n\nVALUE\n----------------------------------------------------------------\nTRUE<\/pre>\n<h1>Disable Unified Auditing<\/h1>\n<p>Relink is required to disable Unified Auditing. You can do this as follows.<\/p>\n<p>First, if there is a database running from the relevant Oracle Home directory, the listener services must be shut down.<\/p>\n<p>You can then disable it as follows.<\/p>\n<pre class=\"lang:default decode:true \">[oracle@orcldb01 ~]$ cd $ORACLE_HOME\/rdbms\/lib\n[oracle@orcldb01 lib]$ pwd\n\/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/lib\n[oracle@orcldb01 lib]$ make -f ins_rdbms.mk uniaud_off ioracle\n\/usr\/bin\/ar d \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/lib\/libknlopt.a kzaiang.o\n\/usr\/bin\/ar cr \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/lib\/libknlopt.a \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/lib\/kzanang.o \nchmod 755 \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/bin\n\n - Linking Oracle \nrm -f \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/lib\/oracle\n\/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/bin\/orald  -o \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/lib\/oracle -m64 -z noexecstack -Wl,--disable-new-dtags -L\/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/lib\/ -L\/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib\/ -L\/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib\/stubs\/   -Wl,-E \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/lib\/opimai.o \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/lib\/ssoraed.o \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/lib\/ttcsoi.o -Wl,--whole-archive -lperfsrv12 -Wl,--no-whole-archive \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib\/nautab.o \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib\/naeet.o \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib\/naect.o \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib\/naedhs.o \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/lib\/config.o  -ldmext -lserver12 -lodm12 -lofs -lcell12 -lnnet12 -lskgxp12 -lsnls12 -lnls12  -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lclient12  -lvsn12 -lcommon12 -lgeneric12 -lknlopt `if \/usr\/bin\/ar tv \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/lib\/libknlopt.a | grep xsyeolap.o &gt; \/dev\/null 2&gt;&amp;amp;1 ; then echo \"-loraolap12\" ; fi` -lskjcx12 -lslax12 -lpls12  -lrt -lplp12 -ldmext -lserver12 -lclient12  -lvsn12 -lcommon12 -lgeneric12 `if [ -f \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib\/libavserver12.a ] ; then echo \"-lavserver12\" ; else echo \"-lavstub12\"; fi` `if [ -f \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib\/libavclient12.a ] ; then echo \"-lavclient12\" ; fi` -lknlopt -lslax12 -lpls12  -lrt -lplp12 -ljavavm12 -lserver12  -lwwg  `cat \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib\/ldflags`    -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lngsmshd12 -lnro12 `cat \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib\/ldflags`    -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lngsmshd12 -lnnzst12 -lzt12 -lztkg12 -lmm -lsnls12 -lnls12  -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lztkg12 `cat \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib\/ldflags`    -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lngsmshd12 -lnro12 `cat \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib\/ldflags`    -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lngsmshd12 -lnnzst12 -lzt12 -lztkg12   -lsnls12 -lnls12  -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 `if \/usr\/bin\/ar tv \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/lib\/libknlopt.a | grep \"kxmnsd.o\" &gt; \/dev\/null 2&gt;&amp;amp;1 ; then echo \" \" ; else echo \"-lordsdo12 -lserver12\"; fi` -L\/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/ctx\/lib\/ -lctxc12 -lctx12 -lzx12 -lgx12 -lctx12 -lzx12 -lgx12 -lordimt12 -lclsra12 -ldbcfg12 -lhasgen12 -lskgxn2 -lnnzst12 -lzt12 -lxml12 -lgeneric12 -locr12 -locrb12 -locrutl12 -lhasgen12 -lskgxn2 -lnnzst12 -lzt12 -lxml12 -lgeneric12  -lgeneric12 -lorazip -loraz -llzopro5 -lorabz2 -lipp_z -lipp_bz2 -lippdcemerged -lippsemerged -lippdcmerged  -lippsmerged -lippcore  -lippcpemerged -lippcpmerged  -lsnls12 -lnls12  -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lsnls12 -lunls12  -lsnls12 -lnls12  -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lasmclnt12 -lcommon12 -lcore12  -laio -lons  -lfthread12   `cat \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib\/sysliblist` -Wl,-rpath,\/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib -lm    `cat \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib\/sysliblist` -ldl -lm   -L\/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/lib `test -x \/usr\/bin\/hugeedit -a -r \/usr\/lib64\/libhugetlbfs.so &amp;amp;&amp;amp; test -r \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/lib\/shugetlbfs.o &amp;amp;&amp;amp; echo -Wl,-zcommon-page-size=2097152 -Wl,-zmax-page-size=2097152 -lhugetlbfs`\ntest ! -f \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/bin\/oracle || (\\\n\t   mv -f \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/bin\/oracle \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/bin\/oracleO &amp;amp;&amp;amp;\\\n\t   chmod 600 \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/bin\/oracleO )\nmv \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/lib\/oracle \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/bin\/oracle\nchmod 6751 \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/bin\/oracle<\/pre>\n<h1>Check Unified Auditing is Disabled<\/h1>\n<p>You can see that it is disabled with the following query.<\/p>\n<pre class=\"lang:default decode:true \">SQL&gt; SELECT VALUE FROM V$OPTION WHERE PARAMETER = 'Unified Auditing';\n\nVALUE\n----------------------------------------------------------------\nFALSE\n<\/pre>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_13806\" class=\"pvc_stats all  \" data-element-id=\"13806\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Enable Unified Auditing Relink is required to enable the new audit mechanism announced with Oracle database 12c (12.1). You can do this as follows. First, if there is a database running from the relevant Oracle Home directory, the listener services must be shut down. You can then enable it as follows. [oracle@orcldb01 ~]$ cd $ORACLE_HOME\/rdbms\/lib &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_13806\" class=\"pvc_stats all  \" data-element-id=\"13806\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":13807,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[5777,5781,5771,5779,5778,5780,5772,5773,5774,5776,5775],"class_list":["post-13806","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-check-unified-auditing","tag-check-unified-auditing-is-disabled","tag-check-unified-auditing-is-enabled","tag-disable-unified-audit","tag-disable-unified-auditing","tag-enable-unified-audit","tag-enable-unified-auditing","tag-enable-unified-auditing-in-oracle","tag-enable-unified-auditing-in-oracle-12c","tag-how-to-disable-unified-auditing","tag-how-to-enable-unified-auditing"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Enable and Disable Unified Auditing Feature in Oracle - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Enable and Disable Unified Auditing Feature in Oracle\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Enable and Disable Unified Auditing Feature in Oracle - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Enable and Disable Unified Auditing Feature in Oracle\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-12-09T06:46:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-12-09T06:46:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-43.png\" \/>\n\t<meta property=\"og:image:width\" content=\"595\" \/>\n\t<meta property=\"og:image:height\" content=\"357\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Enable and Disable Unified Auditing Feature in Oracle\",\"datePublished\":\"2019-12-09T06:46:41+00:00\",\"dateModified\":\"2019-12-09T06:46:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/\"},\"wordCount\":151,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-43.png\",\"keywords\":[\"check Unified Auditing\",\"Check Unified Auditing is Disabled\",\"Check Unified Auditing is Enabled\",\"Disable Unified Audit\",\"Disable Unified Auditing\",\"Enable Unified Audit\",\"Enable Unified Auditing\",\"Enable Unified Auditing in oracle\",\"Enable Unified Auditing in oracle 12c\",\"how to disable Unified Auditing\",\"how to Enable Unified Auditing\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/\",\"name\":\"How To Enable and Disable Unified Auditing Feature in Oracle - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-43.png\",\"datePublished\":\"2019-12-09T06:46:41+00:00\",\"dateModified\":\"2019-12-09T06:46:42+00:00\",\"description\":\"How To Enable and Disable Unified Auditing Feature in Oracle\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-43.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-43.png\",\"width\":595,\"height\":357},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Enable and Disable Unified Auditing Feature in Oracle\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Enable and Disable Unified Auditing Feature in Oracle - Database Tutorials","description":"How To Enable and Disable Unified Auditing Feature in Oracle","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/","og_locale":"en_US","og_type":"article","og_title":"How To Enable and Disable Unified Auditing Feature in Oracle - Database Tutorials","og_description":"How To Enable and Disable Unified Auditing Feature in Oracle","og_url":"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/","og_site_name":"Database Tutorials","article_published_time":"2019-12-09T06:46:41+00:00","article_modified_time":"2019-12-09T06:46:42+00:00","og_image":[{"width":595,"height":357,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-43.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Enable and Disable Unified Auditing Feature in Oracle","datePublished":"2019-12-09T06:46:41+00:00","dateModified":"2019-12-09T06:46:42+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/"},"wordCount":151,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-43.png","keywords":["check Unified Auditing","Check Unified Auditing is Disabled","Check Unified Auditing is Enabled","Disable Unified Audit","Disable Unified Auditing","Enable Unified Audit","Enable Unified Auditing","Enable Unified Auditing in oracle","Enable Unified Auditing in oracle 12c","how to disable Unified Auditing","how to Enable Unified Auditing"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/","url":"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/","name":"How To Enable and Disable Unified Auditing Feature in Oracle - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-43.png","datePublished":"2019-12-09T06:46:41+00:00","dateModified":"2019-12-09T06:46:42+00:00","description":"How To Enable and Disable Unified Auditing Feature in Oracle","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-43.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/11\/Ads\u0131z-43.png","width":595,"height":357},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/12\/09\/how-to-enable-and-disable-unified-auditing-feature-in-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Enable and Disable Unified Auditing Feature in Oracle"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/13806","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=13806"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/13806\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/13807"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=13806"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=13806"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=13806"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}