{"id":16725,"date":"2021-10-05T14:39:59","date_gmt":"2021-10-05T12:39:59","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/"},"modified":"2021-10-05T14:39:59","modified_gmt":"2021-10-05T12:39:59","slug":"from-oracle-standard-auditing-to-oracle-unified-auditing","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/","title":{"rendered":"From Oracle Standard Auditing to Oracle Unified Auditing"},"content":{"rendered":"<p>In this post, I will not show you all advantages related to Oracle Unified Auditing. For that, read the <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/dbseg\/introduction-to-auditing.html#GUID-8D96829C-9151-4FA4-BED9-831D088F12FF\">oracle documentation.<\/a><\/p>\n<p>You can also read the blogs written by my colleagues :<\/p>\n<ul>\n<li><a href=\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-unified-auditing-feature-in-a-multitenant-environment\/\">Oracle 12c Unified Auditing Feature in a multitenant environment<\/a><\/li>\n<li><a href=\"https:\/\/www.dbi-services.com\/blog\/oracle-12c-rman-and-unified-auditing-does-it-really-work\/\">Oracle 12c &#8211; RMAN and Unified Auditing &#8211; Does it really work ?<\/a><\/li>\n<li><a href=\"https:\/\/www.dbi-services.com\/blog\/purging-unified-audit-trail-in-12cr2\/\">Purging Unified Audit Trail in 12cR2<\/a><\/li>\n<\/ul>\n<p>I just want to share with you the steps needed to move from Standard Auditing to Unified Auditing in a mutlitenant environment.<\/p>\n<p>Steps 1 : Check if Unified Auditing is disabled<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">oracle@*****:\/u01\/app\/oracle\/product\/rdbms19_1\/rdbms\/lib\/ [MYCDB] sqh\nSQL*Plus: Release 19.0.0.0.0 - Production on Tue Oct 4 10:45:35 2021\nVersion 19.9.0.0.0\n\nCopyright (c) 1982, 2020, Oracle. All rights reserved.\n\nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.9.0.0.0\n\nSQL&gt; SELECT value FROM v$option WHERE parameter = 'Unified Auditing';\n\nVALUE\n----------------------------------------------------------------\nFALSE\n<\/pre>\n<p>&nbsp;<\/p>\n<p><em>FALSE<\/em> means unified audit trail and audit policy functionality is enabled in mixed mode<\/p>\n<p>Step 2 : As we want to disabled Standard Auditing and enabled Unifed Auditing, let&#8217;s check the <em>audit_file_dest<\/em> parameter<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; sho parameter audit_file_dest\nNAME TYPE VALUE\n------------------------------------ ----------- ------------------------------\naudit_file_dest string \/u01\/app\/oracle\/admin\/xxxx\/adump\n<\/pre>\n<p>Step 4 : Let&#8217;s check the folder <em>\/u01\/app\/oracle\/admin\/xxxx\/adump<\/em><\/p>\n<pre class=\"brush: shell; gutter: true; first-line: 1\">ls -ltr \/u01\/app\/oracle\/admin\/CSYR01I\/adump\n...\n-rw-r-----. 1 oracle dba     1090 Oct  4 10:55 MYCDB_m001_19948_202105041945FHDFJDHF888912.aud\n-rw-r-----. 1 oracle dba     1090 Oct  4 10:55 MYCDB_m001_19948_202F\u00e0D\u00e9F\u00e0D\u00e9DF\u00e9\u00e0D0527767763.aud\n-rw-r-----. 1 oracle dba     1090 oct  4 10:55 MYCDB_m001_19948_20210504FHDJFHDJHFD9851253.aud\n-rw-r-----. 1 oracle dba     1090 Oct  4 10:55 MYCDB_m001_19948_202105041FLDKFLDKDL4960612.aud\n-rw-r-----. 1 oracle dba    40985 Oct  4 10:56 MYCDB_m003_20296_2021050FDJFDKJD54384117793.aud\n-rw-r-----. 1 oracle dba     2504 Oct  4 10:59 MYCDB_ora_32211_202105041FKDJFDDKJFD9350382.aud\n<\/pre>\n<p>&nbsp;<\/p>\n<p>Step 5 : Stop all listeners and databases sharing the ORACLE_HOME<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">oracle@xxxxxxxxx:\/u01\/app\/oracle\/product\/rdbms19_1\/rdbms\/lib\/ [MYCDB] lsnrctl stop LISTENER\noracle@xxxxxxxxx:\/u01\/app\/oracle\/product\/rdbms19_1\/rdbms\/lib\/ [MYCDB] sqh\nSQL*Plus: Release 19.0.0.0.0 - Production on Tue Oct 04 14:11:37 2021\nVersion 19.9.0.0.0\n\nCopyright (c) 1982, 2020, Oracle. All rights reserved.\n\nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.9.0.0.0\n\nSQL&gt; shutdown immediate\nDatabase closed.\nDatabase dismounted.\nORACLE instance shut down.\n<\/pre>\n<p>&nbsp;<\/p>\n<p>Step 6 : To enable the Unified Auditng, we have to relink the file $ORACLE_HOME\/rdbms\/lib\/ins_rdbms.mk<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">oracle@xxxxxx:\/u01\/app\/oracle\/product\/rdbms19_1\/rdbms\/lib\/ [MYCDB] make -f ins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME\n\/usr\/bin\/ar d \/u01\/app\/oracle\/product\/rdbms19_1\/rdbms\/lib\/libknlopt.a kzanang.o\n\/usr\/bin\/ar cr \/u01\/app\/oracle\/product\/rdbms19_1\/rdbms\/lib\/libknlopt.a \/u01\/app\/oracle\/product\/rdbms19_1\/rdbms\/lib\/kzaiang.o\nchmod 755 \/u01\/app\/oracle\/product\/rdbms19_1\/bin\n- Linking Oracle\nrm -f \/u01\/app\/oracle\/product\/rdbms19_1\/rdbms\/lib\/oracle\n\/u01\/app\/oracle\/product\/rdbms19_1\/bin\/orald -o \/u01\/app\/oracle\/product\/rdbms19_1\/rdbms\/lib\/oracle -m64 -z noexecstack -Wl,--disable-new-dtags -L\/u01\/app\/oracle\/product\/rdbms19_1\/rdbms\/lib\/ -L\/u01\/app\/oracle\/product\/rdbms19_1\/lib\/ -L\/u01\/app\/oracle\/product\/rdbms19_1\/lib\/stubs\/ -Wl,-E \/u01\/app\/oracle\/product\/rdbms19_1\/rdbms\/lib\/opimai.o \/u01\/app\/oracle\/product\/rdbms19_1\/rdbms\/lib\/ssoraed.o \/u01\/app\/oracle\/product\/rdbms19_1\/rdbms\/lib\/ttcsoi.o -Wl,--whole-archive -lperfsrv19 -Wl,--no-whole-archive \/u01\/app\/oracle\/product\/rdbms19_1\/lib\/nautab.o \/u01\/app\/oracle\/product\/rdbms19_1\/lib\/naeet.o \/u01\/app\/oracle\/product\/rdbms19_1\/lib\/naect.o \/u01\/app\/oracle\/product\/rdbms19_1\/lib\/naedhs.o \/u01\/app\/oracle\/product\/rdbms19_1\/rdbms\/lib\/config.o -ldmext -lserver19 -lodm19 -lofs -lcell19 -lnnet19 -lskgxp19 -lsnls19 -lnls19 -lcore19 -lsnls19 -lnls19 -lcore19 -lsnls19 -lnls19 -lxml19 -lcore19 -lunls19 -lsnls19 -lnls19 -lcore19 -lnls19 -lclient19 -lvsnst19 -lcommon19 -lgeneric19 -lknlopt -loraolap19 -lskjcx19 -lslax19 -lpls19 -lrt -lplp19 -ldmext -lserver19 -lclient19 -lvsnst19 -lcommon19 -lgeneric19 `if [ -f \/u01\/app\/oracle\/product\/rdbms19_1\/lib\/libavserver19.a ] ; then echo \"-lavserver19\" ; else echo \"-lavstub19\"; fi` `if [ -f \/u01\/app\/oracle\/product\/rdbms19_1\/lib\/libavclient19.a ] ; then echo \"-lavclient19\" ; fi` -lknlopt -lslax19 -lpls19 -lrt -lplp19 -ljavavm19 -lserver19 -lwwg `cat \/u01\/app\/oracle\/product\/rdbms19_1\/lib\/ldflags` -lncrypt19 -lnsgr19 -lnzjs19 -ln19 -lnl19 -lngsmshd19 -lnro19 `cat \/u01\/app\/oracle\/product\/rdbms19_1\/lib\/ldflags` -lncrypt19 -lnsgr19 -lnzjs19 -ln19 -lnl19 -lngsmshd19 -lnnzst19 -lzt19 -lztkg19 -lmm -lsnls19 -lnls19 -lcore19 -lsnls19 -lnls19 -lcore19 -lsnls19 -lnls19 -lxml19 -lcore19 -lunls19 -lsnls19 -lnls19 -lcore19 -lnls19 -lztkg19 `cat \/u01\/app\/oracle\/product\/rdbms19_1\/lib\/ldflags` -lncrypt19 -lnsgr19 -lnzjs19 -ln19 -lnl19 -lngsmshd19 -lnro19 `cat \/u01\/app\/oracle\/product\/rdbms19_1\/lib\/ldflags` -lncrypt19 -lnsgr19 -lnzjs19 -ln19 -lnl19 -lngsmshd19 -lnnzst19 -lzt19 -lztkg19 -lsnls19 -lnls19 -lcore19 -lsnls19 -lnls19 -lcore19 -lsnls19 -lnls19 -lxml19 -lcore19 -lunls19 -lsnls19 -lnls19 -lcore19 -lnls19 `if \/usr\/bin\/ar tv \/u01\/app\/oracle\/product\/rdbms19_1\/rdbms\/lib\/libknlopt.a | grep \"kxmnsd.o\" &gt; \/dev\/null 2&gt;&amp;1 ; then echo \" \" ; else echo \"-lordsdo19 -lserver19\"; fi` -L\/u01\/app\/oracle\/product\/rdbms19_1\/ctx\/lib\/ -lctxc19 -lctx19 -lzx19 -lgx19 -lctx19 -lzx19 -lgx19 -lclscest19 -loevm -lclsra19 -ldbcfg19 -lhasgen19 -lskgxn2 -lnnzst19 -lzt19 -lxml19 -lgeneric19 -locr19 -locrb19 -locrutl19 -lhasgen19 -lskgxn2 -lnnzst19 -lzt19 -lxml19 -lgeneric19 -lgeneric19 -lorazip -loraz -llzopro5 -lorabz2 -lorazstd -loralz4 -lipp_z -lipp_bz2 -lippdc -lipps -lippcore -lippcp -lsnls19 -lnls19 -lcore19 -lsnls19 -lnls19 -lcore19 -lsnls19 -lnls19 -lxml19 -lcore19 -lunls19 -lsnls19 -lnls19 -lcore19 -lnls19 -lsnls19 -lunls19 -lsnls19 -lnls19 -lcore19 -lsnls19 -lnls19 -lcore19 -lsnls19 -lnls19 -lxml19 -lcore19 -lunls19 -lsnls19 -lnls19 -lcore19 -lnls19 -lasmclnt19 -lcommon19 -lcore19 -ledtn19 -laio -lons -lmql1 -lipc1 -lfthread19 `cat \/u01\/app\/oracle\/product\/rdbms19_1\/lib\/sysliblist` -Wl,-rpath,\/u01\/app\/oracle\/product\/rdbms19_1\/lib -lm `cat \/u01\/app\/oracle\/product\/rdbms19_1\/lib\/sysliblist` -ldl -lm -L\/u01\/app\/oracle\/product\/rdbms19_1\/lib `test -x \/usr\/bin\/hugeedit -a -r \/usr\/lib64\/libhugetlbfs.so &amp;&amp; test -r \/u01\/app\/oracle\/product\/rdbms19_1\/rdbms\/lib\/shugetlbfs.o &amp;&amp; echo -Wl,-zcommon-page-size=2097152 -Wl,-zmax-page-size=2097152 -lhugetlbfs`\nrm -f \/u01\/app\/oracle\/product\/rdbms19_1\/bin\/oracle\nmv \/u01\/app\/oracle\/product\/rdbms19_1\/rdbms\/lib\/oracle \/u01\/app\/oracle\/product\/rdbms19_1\/bin\/oracle\nchmod 6751 \/u01\/app\/oracle\/product\/rdbms19_1\/bin\/oracle\n(if [ ! -f \/u01\/app\/oracle\/product\/rdbms19_1\/bin\/crsd.bin ]; then \\\ngetcrshome=\"\/u01\/app\/oracle\/product\/rdbms19_1\/srvm\/admin\/getcrshome\" ; \\\nif [ -f \"$getcrshome\" ]; then \\\ncrshome=\"`$getcrshome`\"; \\\nif [ -n \"$crshome\" ]; then \\\nif [ $crshome != \/u01\/app\/oracle\/product\/rdbms19_1 ]; then \\\noracle=\"\/u01\/app\/oracle\/product\/rdbms19_1\/bin\/oracle\"; \\\n$crshome\/bin\/setasmgidwrap oracle_binary_path=$oracle; \\\nfi \\\nfi \\\nfi \\\nfi\\\n);\n<\/pre>\n<p>&nbsp;<\/p>\n<p>Step 7 : Restart the listener and the databases and check if Unified Auditing is enabled from the container database (CDB) and from the pluggable databases (PDB)<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.9.0.0.0\noracle@xxxxxx:\/u01\/app\/oracle\/product\/rdbms19_1\/rdbms\/lib\/ [MYCDB] sqh\nSQL*Plus: Release 19.0.0.0.0 - Production on Tue Oct 04 14:26:04 2021\nVersion 19.9.0.0.0\n\nCopyright (c) 1982, 2020, Oracle. All rights reserved.\n\nConnected to:\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\nVersion 19.9.0.0.0\n\nSQL&gt; select value from v$option where lower(parameter)='unified auditing';\n\nVALUE\n----------------------------------------------------------------\nTRUE\n\nSQL&gt; alter session set container=MYPDB;\n\nSession altered.\n\nSQL&gt; select value from v$option where lower(parameter)='unified auditing';\n\nVALUE\n----------------------------------------------------------------\nTRUE\n<\/pre>\n<p>Now we have Unified Pure Auditing without traditional auditing, than means that AUDIT* spfile parameters are no more taking account and the *.aud files are no more generated.<\/p>\n<p>&nbsp;<\/p>\n<p>Step 8 :\u00a0Set the last archive timestamp for audit records stored into the table unified_audit_trail (below we remove all rows with timestamp &gt; 5 days)<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">BEGIN\n     DBMS_AUDIT_MGMT.set_last_archive_timestamp(\n    audit_trail_type     =&gt; DBMS_AUDIT_MGMT.audit_trail_unified,\n    last_archive_time    =&gt; SYSTIMESTAMP-5,\n    --rac_instance_number  =&gt;  1,\n    container            =&gt; DBMS_AUDIT_MGMT.container_current\n  );\n END;\n\/\n\nPL\/SQL procedure successfully completed.\n\nCOLUMN audit_trail FORMAT A20\nCOLUMN last_archive_ts FORMAT A40\nSELECT audit_trail,\n       last_archive_ts\n  FROM   dba_audit_mgmt_last_arch_ts;\n\nAUDIT_TRAIL          LAST_ARCHIVE_TS\n-------------------- ----------------------------------------\nUNIFIED AUDIT TRAIL  04-OCT-21 15.24.32.000000 PM +00:00<\/pre>\n<p>Step 9 : Create and schedule the purge jobs <em>PURGE_ALL_AUDIT_TRAILS<\/em><\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">BEGIN\n  DBMS_AUDIT_MGMT.create_purge_job(\n    audit_trail_type           =&gt; DBMS_AUDIT_MGMT.AUDIT_TRAIL_ALL,\n    audit_trail_purge_interval =&gt; 24 \/* hours *\/,\n    audit_trail_purge_name     =&gt; 'PURGE_ALL_AUDIT_TRAILS',\n    use_last_arch_timestamp    =&gt; TRUE );\nEND;\n\/\n\nPL\/SQL procedure successfully completed.\n\nSELECT job_action\nFROM   dba_scheduler_jobs\nWHERE  job_name = 'PURGE_ALL_AUDIT_TRAILS';\n\nJOB_ACTION\n--------------------------------------------------------------------------------\nBEGIN AUDSYS.DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(15, TRUE, 1);  END;\n\nSQL&gt;<\/pre>\n<p>My customer wanted to audit all LOGON (even FAILS LOGIN) and LOGOFF for all users including proxy users.<\/p>\n<p>Create the audit policy LOG_ON_OFF for actions LOGON and LOGOFF and enable it :<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">conn \/as sysdba\nCREATE AUDIT POLICY LOG_ON_OFF ACTIONS LOGON,LOGOFF;\nAUDIT POLICY LOG_ON_OFF;\nSQL&gt; alter session set container=MYPDB;\n\nSession altered.\n\ncol user_name format A10\ncol policy_name format A18\nselect POLICY_NAME, ENABLED_OPTION, ENTITY_NAME, SUCCESS, FAILURE\nfrom AUDIT_UNIFIED_ENABLED_POLICIES\n  3  where POLICY_NAME ='LOG_ON_OFF';\n\nPOLICY_NAME\t\tENABLED_OPTION\t\tENTITY_NAME\t\tSUCCESS FAILURE\n--- ------ ------ ------ ------ ------ ------ ------ ------ ---\nLOG_ON_OFF\t\tBY USER\t\t\t\tALL USERS\t\tYES \tYES\n<\/pre>\n<p>&nbsp;<\/p>\n<p>Let&#8217;s simulate a fails connection through a proxy users :<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">oracle@server:\/home\/oracle\/ [MYCDB (CDB$ROOT)] sqlplus xfelahi[xxxxx]\/\"******\"@server.domain.name\/pdb.domain.name\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Tue Oct 5 16:07:37 2021\nVersion 19.9.0.0.0\n\nCopyright (c) 1982, 2020, Oracle.  All rights reserved.\n\nERROR:\nORA-01017: invalid username\/password; logon denied\n\n<\/pre>\n<p>Let&#8217;s check the Unified Auditing records into the table unified_audit_trail<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-51874 size-full\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-4.png\" alt=\"\" width=\"752\" height=\"182\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this post, I will not show you all advantages related to Oracle Unified Auditing. For that, read the oracle documentation. You can also read the blogs written by my colleagues : Oracle 12c Unified Auditing Feature in a multitenant environment Oracle 12c &#8211; RMAN and Unified Auditing &#8211; Does it really work ? Purging [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":16726,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198,59],"tags":[1042,635,1384,2233],"type_dbi":[],"class_list":["post-16725","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-database-management","category-oracle","tag-auditing","tag-dbdoracle","tag-oracle-security","tag-unified-auditing"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>From Oracle Standard Auditing to Oracle Unified Auditing - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"From Oracle Standard Auditing to Oracle Unified Auditing\" \/>\n<meta property=\"og:description\" content=\"In this post, I will not show you all advantages related to Oracle Unified Auditing. For that, read the oracle documentation. You can also read the blogs written by my colleagues : Oracle 12c Unified Auditing Feature in a multitenant environment Oracle 12c &#8211; RMAN and Unified Auditing &#8211; Does it really work ? Purging [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-10-05T12:39:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-4.png\" \/>\n\t<meta property=\"og:image:width\" content=\"752\" \/>\n\t<meta property=\"og:image:height\" content=\"182\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"From Oracle Standard Auditing to Oracle Unified Auditing\",\"datePublished\":\"2021-10-05T12:39:59+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/\"},\"wordCount\":322,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-4.png\",\"keywords\":[\"Auditing\",\"DBD::Oracle\",\"oracle security\",\"Unified Auditing\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Database management\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/\",\"name\":\"From Oracle Standard Auditing to Oracle Unified Auditing - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-4.png\",\"datePublished\":\"2021-10-05T12:39:59+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-4.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-4.png\",\"width\":752,\"height\":182},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"From Oracle Standard Auditing to Oracle Unified Auditing\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"From Oracle Standard Auditing to Oracle Unified Auditing - dbi Blog","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:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/","og_locale":"en_US","og_type":"article","og_title":"From Oracle Standard Auditing to Oracle Unified Auditing","og_description":"In this post, I will not show you all advantages related to Oracle Unified Auditing. For that, read the oracle documentation. You can also read the blogs written by my colleagues : Oracle 12c Unified Auditing Feature in a multitenant environment Oracle 12c &#8211; RMAN and Unified Auditing &#8211; Does it really work ? Purging [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/","og_site_name":"dbi Blog","article_published_time":"2021-10-05T12:39:59+00:00","og_image":[{"width":752,"height":182,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-4.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"From Oracle Standard Auditing to Oracle Unified Auditing","datePublished":"2021-10-05T12:39:59+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/"},"wordCount":322,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-4.png","keywords":["Auditing","DBD::Oracle","oracle security","Unified Auditing"],"articleSection":["Database Administration &amp; Monitoring","Database management","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/","url":"https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/","name":"From Oracle Standard Auditing to Oracle Unified Auditing - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-4.png","datePublished":"2021-10-05T12:39:59+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-4.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture-4.png","width":752,"height":182},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/from-oracle-standard-auditing-to-oracle-unified-auditing\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"From Oracle Standard Auditing to Oracle Unified Auditing"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16725","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=16725"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16725\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/16726"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=16725"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=16725"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=16725"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=16725"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}