{"id":1514,"date":"2023-01-07T12:07:04","date_gmt":"2023-01-07T12:07:04","guid":{"rendered":"https:\/\/dbanextstep.com\/?page_id=1514"},"modified":"2023-01-10T23:13:03","modified_gmt":"2023-01-10T23:13:03","slug":"transparent-data-encryption","status":"publish","type":"page","link":"https:\/\/dbanextstep.com\/index.php\/transparent-data-encryption\/","title":{"rendered":"READ DataFile with OS CMD"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"1514\" class=\"elementor elementor-1514\">\n\t\t\t\t\t\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-3c18c1d9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3c18c1d9\" data-element_type=\"section\">\n\t\t\t\t\t\t\t<div class=\"elementor-background-overlay\"><\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-127eac57\" data-id=\"127eac57\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2fd25ff3 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"2fd25ff3\" data-element_type=\"widget\" data-settings=\"{&quot;exclude_headings_by_selector&quot;:[],&quot;headings_by_tags&quot;:[&quot;h2&quot;,&quot;h3&quot;,&quot;h4&quot;,&quot;h5&quot;,&quot;h6&quot;],&quot;marker_view&quot;:&quot;numbers&quot;,&quot;minimize_box&quot;:&quot;yes&quot;,&quot;minimized_on&quot;:&quot;tablet&quot;,&quot;hierarchical_view&quot;:&quot;yes&quot;,&quot;min_height&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"table-of-contents.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor-pro - v3.8.0 - 30-10-2022 *\/\n.elementor-widget-table-of-contents .elementor-toc__header-title{color:var(--header-color)}.elementor-widget-table-of-contents.elementor-toc--collapsed .elementor-toc__toggle-button--collapse,.elementor-widget-table-of-contents:not(.elementor-toc--collapsed) .elementor-toc__toggle-button--expand{display:none}.elementor-widget-table-of-contents .elementor-widget-container{min-height:var(--box-min-height);border:var(--box-border-width,1px) solid var(--box-border-color,#a4afb7);border-radius:var(--box-border-radius,3px);background-color:var(--box-background-color);-webkit-transition:min-height .4s;-o-transition:min-height .4s;transition:min-height .4s;overflow:hidden}.elementor-toc__header{display:-webkit-box;display:-ms-flexbox;display:flex;-webkit-box-align:center;-ms-flex-align:center;align-items:center;-webkit-box-pack:justify;-ms-flex-pack:justify;justify-content:space-between;padding:var(--box-padding,20px);background-color:var(--header-background-color);border-bottom:var(--separator-width,1px) solid var(--box-border-color,#a4afb7)}.elementor-toc__header-title{font-size:18px;margin:0;color:var(--header-color)}.elementor-toc__toggle-button{cursor:pointer;display:-webkit-inline-box;display:-ms-inline-flexbox;display:inline-flex}.elementor-toc__toggle-button i{color:var(--toggle-button-color)}.elementor-toc__toggle-button svg{height:1em;width:1em;fill:var(--toggle-button-color)}.elementor-toc__spinner-container{text-align:center}.elementor-toc__spinner{font-size:2em}.elementor-toc__spinner.e-font-icon-svg{height:1em;width:1em}.elementor-toc__body{padding:var(--box-padding,20px);max-height:var(--toc-body-max-height);overflow-y:auto}.elementor-toc__body::-webkit-scrollbar{width:7px}.elementor-toc__body::-webkit-scrollbar-thumb{background-color:#c2cbd2;border-radius:10px}.elementor-toc__list-wrapper{list-style:none;padding:0}.elementor-toc__list-item{margin-bottom:.5em}.elementor-toc__list-item.elementor-item-active{font-weight:700}.elementor-toc__list-item .elementor-toc__list-wrapper{margin-top:.5em;margin-left:var(--nested-list-indent,1em)}.elementor-toc__list-item-text:hover{color:var(--item-text-hover-color);-webkit-text-decoration:var(--item-text-hover-decoration);text-decoration:var(--item-text-hover-decoration)}.elementor-toc__list-item-text.elementor-item-active{color:var(--item-text-active-color);-webkit-text-decoration:var(--item-text-active-decoration);text-decoration:var(--item-text-active-decoration)}.elementor-toc__list-item-text-wrapper{display:-webkit-box;display:-ms-flexbox;display:flex;-webkit-box-align:center;-ms-flex-align:center;align-items:center}.elementor-toc__list-item-text-wrapper:before,.elementor-toc__list-item-text-wrapper i{margin-right:8px;color:var(--marker-color)}.elementor-toc__list-item-text-wrapper svg{margin-right:8px;fill:var(--marker-color);height:var(--marker-size,.5em);width:var(--marker-size,.5em)}.elementor-toc__list-item-text-wrapper i{font-size:var(--marker-size,.5em)}.elementor-toc__list-item-text-wrapper:before{font-size:var(--marker-size,1em)}.elementor-toc--content-ellipsis .elementor-toc__list-item-text{white-space:nowrap;overflow:hidden;-o-text-overflow:ellipsis;text-overflow:ellipsis}.elementor-toc__list-items--collapsible>.elementor-toc__list-wrapper>.elementor-toc__list-item>.elementor-toc__list-wrapper{display:none}.elementor-toc__heading-anchor{position:absolute}.elementor-toc__body .elementor-toc__list-item-text{color:var(--item-text-color);-webkit-text-decoration:var(--item-text-decoration);text-decoration:var(--item-text-decoration)}.elementor-toc__body .elementor-toc__list-item-text:hover{color:var(--item-text-hover-color);-webkit-text-decoration:var(--item-text-hover-decoration);text-decoration:var(--item-text-hover-decoration)}.elementor-toc__body .elementor-toc__list-item-text.elementor-item-active{color:var(--item-text-active-color);-webkit-text-decoration:var(--item-text-active-decoration);text-decoration:var(--item-text-active-decoration)}ol.elementor-toc__list-wrapper{counter-reset:item}ol.elementor-toc__list-wrapper .elementor-toc__list-item{counter-increment:item}ol.elementor-toc__list-wrapper .elementor-toc__list-item-text-wrapper:before{content:counters(item,\".\") \". \"}<\/style>\t\t<div class=\"elementor-toc__header\">\n\t\t\t<h4 class=\"elementor-toc__header-title\">\n\t\t\t\tTable of Contents\t\t\t<\/h4>\n\t\t\t\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--expand\"><i class=\"fas fa-chevron-down\"><\/i><\/div>\n\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--collapse\"><i class=\"fas fa-chevron-up\"><\/i><\/div>\n\t\t\t\t\t<\/div>\n\t\t<div class=\"elementor-toc__body\">\n\t\t\t<div class=\"elementor-toc__spinner-container\">\n\t\t\t\t<i class=\"elementor-toc__spinner eicon-animation-spin eicon-loading\" aria-hidden=\"true\"><\/i>\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-247cc60 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"247cc60\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b04fab0\" data-id=\"b04fab0\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e157bb5 elementor-widget elementor-widget-heading\" data-id=\"e157bb5\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.8.1 - 13-11-2022 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">RND &amp; TESTING to read data \/ Contents from oracle datafiles which are not encrypted and Prove, why encryption is important for oracle databases.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-72013eb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"72013eb\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c7305d9\" data-id=\"c7305d9\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-dfe4876 elementor-widget elementor-widget-heading\" data-id=\"dfe4876\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">To achieve the above task, I have installed oracle 21c rpm on Linux oracle 8.<br><br>Database Version: Oracle Database 21c Express Edition Release 21.0.0.0.0 <br>Database name : XE <\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-bb2efd0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bb2efd0\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-848a1c7\" data-id=\"848a1c7\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b08c111 elementor-widget elementor-widget-text-editor\" data-id=\"b08c111\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.8.1 - 13-11-2022 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#818a91;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#818a91;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<pre style=\"background-color: rgba(0, 0, 0, 0.1); margin-bottom: 2.4rem; padding: 10px 20px; margin-top: 0px; overflow-wrap: normal; border-radius: 3px;\"><span style=\"color: #000000; font-family: SFMono-Regular, Menlo, Monaco, Consolas, 'Liberation Mono', 'Courier New', monospace;\"><span style=\"font-size: 14px; font-weight: bolder; white-space: pre-wrap;\">Microsoft Windows [Version 10.0.19044.2251]<\/span><span style=\"font-size: 14px; white-space: pre-wrap;\"><b>[oracle@localhost ~]$ . oraenv\nORACLE_SID = [oracle] ? XE\nThe Oracle base has been set to \/opt\/oracle\n[oracle@localhost ~]$\n[oracle@localhost ~]$ sqlplus \/ as sysdba\n<span style=\"color: #0000ff;\">SQL*Plus: Release 21.0.0.0.0 - Production on Sat Jan 7 08:58:51 2023\nVersion 21.3.0.0.0<\/span>\n\nCopyright (c) 1982, 2021, Oracle.  All rights reserved.\n\nConnected to:\nOracle Database 21c Express Edition Release 21.0.0.0.0 - Production\nVersion 21.3.0.0.0\n\nSQL&gt; COLUMN NAME FORMAT A8\nSQL&gt; set colsep | pagesize 2000 trims on\nSQL&gt; set linesize 200\nSQL&gt; SELECT NAME, CDB, CON_ID FROM V$DATABASE;\n\nNAME    |CDB|    CON_ID\n--------|---|----------\nXE      |YES|         0\n\t  \n\nSQL&gt; col cname format a10\nSQL&gt; select name cname,dbid, OPEN_MODE,OPEN_TIME from V$CONTAINERS C\n\nCNAME     |      DBID|OPEN_MODE |OPEN_TIME\n----------|----------|----------|---------------------------------------------------------------------------\nCDB$ROOT  |3006541124|READ WRITE|07-JAN-23 04.10.04.739 AM +00:00\nPDB$SEED  |3937184287|READ ONLY |07-JAN-23 04.10.04.789 AM +00:00\n<\/b><strong><span style=\"color: #0000ff;\">XEPDB1    | 671033675|READ WRITE|07-JAN-23 04.10.09.346 AM +00:00<\/span> <\/strong><b> \n\nSQL&gt; col WRL_PARAMETER format a10\nSQL&gt; col WRL_TYPE format a10\nSQL&gt; col wallet_type format a10\nSQL&gt; col STATUS format a20\nSQL&gt; col KEYSTORE_MODE format a50\nSQL&gt; set linesize 300 trims on colsep |\n\nSQL&gt; select con_id,WRL_TYPE,wallet_type,STATUS,KEYSTORE_MODE from V$encryption_wallet;\n\n    CON_ID|WRL_TYPE  |WALLET_TYP|STATUS              |KEYSTORE_MODE\n----------|----------|----------|--------------------|--------------------------------------------------\n         1|FILE      |UNKNOWN   |NOT_AVAILABLE       |NONE\n         2|FILE      |UNKNOWN   |NOT_AVAILABLE       |UNITED\n       <span style=\"color: #0000ff;\">  3|FILE      |UNKNOWN   |NOT_AVAILABLE       |UNITED<\/span>\n\nSQL&gt; select name cname,dbid,E.con_id,wrl_type,wallet_type,status,keystore_mode\nfrom V$ENCRYPTION_WALLET E , V$CONTAINERS C\nwhere E.con_id=C.con_id ORDER BY CON_ID; \n\nCNAME     |      DBID|    CON_ID|WRL_TYPE  |WALLET_TYP|STATUS              |KEYSTORE_MODE\n----------|----------|----------|----------|----------|--------------------|--------------------------------\nCDB$ROOT  |3006541124|         1|FILE      |UNKNOWN   |NOT_AVAILABLE       |NONE\nPDB$SEED  |3937184287|         2|FILE      |UNKNOWN   |NOT_AVAILABLE       |UNITED\n<span style=\"color: #0000ff;\">XEPDB1    | 671033675|         3|FILE      |UNKNOWN   |NOT_AVAILABLE       |UNITED\n\n<\/span><\/b><\/span><\/span><\/pre><p style=\"color: #0000ff; font-family: SFMono-Regular, Menlo, Monaco, Consolas, 'Liberation Mono', 'Courier New', monospace; font-size: 14px; font-weight: bolder; white-space: pre-wrap;\">\u00a0<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-f8d2081 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f8d2081\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7cb312c\" data-id=\"7cb312c\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-201e634 elementor-widget elementor-widget-text-editor\" data-id=\"201e634\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<pre style=\"background-color: rgba(0, 0, 0, 0.1); margin-bottom: 2.4rem; padding: 10px 20px; margin-top: 0px; overflow-wrap: normal; border-radius: 3px;\"><span style=\"color: #0000ff; font-family: SFMono-Regular, Menlo, Monaco, Consolas, Liberation Mono, Courier New, monospace;\"><span style=\"font-size: 14px; white-space: pre-wrap; color: #000000;\"><b style=\"color: #000000; font-family: SFMono-Regular, Menlo, Monaco, Consolas, 'Liberation Mono', 'Courier New', monospace; font-size: 14px; white-space: pre-wrap;\"><span style=\"color: #0000ff;\">Steps to prove, We can read contents from oracle datafiles if it is not encrypted:<\/span>\n1.) Connect to container XEPDB1\n2.) Now, I will create a TABLESPACE (<\/b><strong style=\"color: #000000; font-family: SFMono-Regular, Menlo, Monaco, Consolas, 'Liberation Mono', 'Courier New', monospace; font-size: 14px; white-space: pre-wrap;\"><span style=\"color: #0000ff;\">HACK_TEST<\/span><\/strong><b style=\"color: #000000; font-family: SFMono-Regular, Menlo, Monaco, Consolas, 'Liberation Mono', 'Courier New', monospace; font-size: 14px; white-space: pre-wrap;\">) with single DATAFILE (<\/b><strong><span style=\"color: #0000ff;\">'hack_test_datafile_01.dbf'<\/span><\/strong><b style=\"color: #000000; font-family: SFMono-Regular, Menlo, Monaco, Consolas, 'Liberation Mono', 'Courier New', monospace; font-size: 14px; white-space: pre-wrap;\">) in container <\/b><strong><span style=\"color: #0000ff;\">XEPDB1<\/span><\/strong><b style=\"color: #000000; font-family: SFMono-Regular, Menlo, Monaco, Consolas, 'Liberation Mono', 'Courier New', monospace; font-size: 14px; white-space: pre-wrap;\">\n3.) Create a user <\/b><span style=\"color: #0000ff;\">PREY_USER<\/span><b style=\"color: #000000; font-family: SFMono-Regular, Menlo, Monaco, Consolas, 'Liberation Mono', 'Courier New', monospace; font-size: 14px; white-space: pre-wrap;\"> with table <\/b><span style=\"color: #0000ff;\">EMP<\/span><b style=\"color: #000000; font-family: SFMono-Regular, Menlo, Monaco, Consolas, 'Liberation Mono', 'Courier New', monospace; font-size: 14px; white-space: pre-wrap;\"> with few records.\n4.) Execute command with <\/b><strong><span style=\"color: #0000ff;\">sys \"ALTER SYSTEM CHECKPOINT;\"<\/span><\/strong><b style=\"color: #000000; font-family: SFMono-Regular, Menlo, Monaco, Consolas, 'Liberation Mono', 'Courier New', monospace; font-size: 14px; white-space: pre-wrap;\"> and <\/b><strong><span style=\"color: #0000ff;\">\"ALTER SYSTEM SWITCH LOGFILE;\"<\/span><\/strong><b style=\"color: #000000; font-family: SFMono-Regular, Menlo, Monaco, Consolas, 'Liberation Mono', 'Courier New', monospace; font-size: 14px; white-space: pre-wrap;\"> to write data from buffer\/cache to datafiles.\n\t<\/b><span style=\"color: #0000ff;\"><strong>Note: Repeat commands from <span style=\"font-family: SFMono-Regular, Menlo, Monaco, Consolas, 'Liberation Mono', 'Courier New', monospace;\"><span style=\"font-size: 14px; white-space: pre-wrap;\">privileged<\/span><\/span> account 3 to 4 time. <\/strong><\/span><b style=\"color: #000000; font-family: SFMono-Regular, Menlo, Monaco, Consolas, 'Liberation Mono', 'Courier New', monospace; font-size: 14px; white-space: pre-wrap;\">\n5.) Read datafile with LINUX command and will Prove data is readable of unencrypted file (.DBF) with OS command.<\/b><\/span><span style=\"font-size: 14px; font-weight: bolder; white-space: pre-wrap;\"><br \/><\/span><\/span><br \/><span style=\"font-family: SFMono-Regular, Menlo, Monaco, Consolas, Liberation Mono, Courier New, monospace;\"><span style=\"font-size: 14px; white-space: pre-wrap;\"><b>SQL&gt; select name cname,dbid,E.con_id,wrl_type,wallet_type,status,keystore_mode\nfrom V$ENCRYPTION_WALLET E , V$CONTAINERS C\nwhere E.con_id=C.con_id ORDER BY CON_ID; \n\nCNAME     |      DBID|    CON_ID|WRL_TYPE  |WALLET_TYP|STATUS              |KEYSTORE_MODE\n----------|----------|----------|----------|----------|--------------------|--------------------------------\nCDB$ROOT  |3006541124|         1|FILE      |UNKNOWN   |NOT_AVAILABLE       |NONE\nPDB$SEED  |3937184287|         2|FILE      |UNKNOWN   |NOT_AVAILABLE       |UNITED\n<span style=\"color: #0000ff;\">XEPDB1    | 671033675|         3|FILE      |UNKNOWN   |NOT_AVAILABLE       |UNITED<\/span><\/b><\/span><\/span><b style=\"color: #000000; font-family: SFMono-Regular, Menlo, Monaco, Consolas, 'Liberation Mono', 'Courier New', monospace; font-size: 14px; white-space: pre-wrap;\"><br \/><\/b><br \/><span style=\"font-family: SFMono-Regular, Menlo, Monaco, Consolas, Liberation Mono, Courier New, monospace;\"><span style=\"font-size: 14px; white-space: pre-wrap;\"><b>1.) Connect to container <span style=\"color: #0000ff;\">XEPDB1<\/span>\nSQL&gt; alter session set container =XEPDB1;\nSQL&gt; alter session set container =XEPDB1;\n<\/b>Session altered.<\/span><b style=\"font-size: 14px; white-space: pre-wrap;\"><br \/><\/b><\/span><br \/><span style=\"font-family: SFMono-Regular, Menlo, Monaco, Consolas, Liberation Mono, Courier New, monospace;\"><span style=\"font-size: 14px; white-space: pre-wrap;\"><b>SQL&gt; col FILE_NAME format a70\nselect T.TABLESPACE_NAME,d.FILE_NAME,T.STATUS,T.LOGGING,T.FORCE_LOGGING,T.ENCRYPTED\nfrom dba_tablespaces T ,\ndba_data_files d\nwhere T.TABLESPACE_NAME=D.TABLESPACE_NAME order by 1;\n\nTABLESPACE_NAME |FILE_NAME                                      |STATUS   |LOGGING  |FOR|ENC\n----------------|-----------------------------------------------|---------|---------|---|---\nSYSAUX          |\/opt\/oracle\/oradata\/XE\/XEPDB1\/sysaux01.dbf     |ONLINE   |LOGGING  |YES|NO\nSYSTEM          |\/opt\/oracle\/oradata\/XE\/XEPDB1\/system01.dbf     |ONLINE   |LOGGING  |YES|NO\nUNDOTBS1        |\/opt\/oracle\/oradata\/XE\/XEPDB1\/undotbs01.dbf    |ONLINE   |LOGGING  |NO |NO\nUSERS           |\/opt\/oracle\/oradata\/XE\/XEPDB1\/users01.dbf      |ONLINE   |LOGGING  |NO |NO<\/b><\/span><b style=\"font-size: 14px; white-space: pre-wrap;\"><br \/><\/b><\/span><br \/><span style=\"font-family: SFMono-Regular, Menlo, Monaco, Consolas, Liberation Mono, Courier New, monospace;\"><span style=\"font-size: 14px; white-space: pre-wrap;\"><b>2.)Now, I will create a TABLESPACE (<span style=\"color: #0000ff;\">HACK_TEST<\/span>) with single DATAFILE in container XEPDB1   \n\nSQL&gt;CREATE TABLESPACE <span style=\"color: #0000ff;\">\"HACK_TEST\"<\/span> DATAFILE\n'\/opt\/oracle\/oradata\/XE\/XEPDB1\/<span style=\"color: #0000ff;\">hack_test_datafile_01.dbf<\/span>' SIZE 5242880\nAUTOEXTEND ON MAXSIZE 1G;\n\n<\/b>Tablespace created.<b>\n\nSQL&gt; select T.TABLESPACE_NAME,d.FILE_NAME,T.STATUS,T.LOGGING,T.FORCE_LOGGING,T.ENCRYPTED\nfrom dba_tablespaces T ,\ndba_data_files d\nwhere T.TABLESPACE_NAME=D.TABLESPACE_NAME order by 1;  2    3    4\n\nTABLESPACE_NAME   |FILE_NAME                                                 |STATUS              |LOGGING  |FOR|ENC\n------------------|----------------------------------------------------------|--------------------|---------|---|---\nHACK_TEST         |\/opt\/oracle\/oradata\/XE\/XEPDB1\/hack_test_datafile_01.dbf   |ONLINE              |LOGGING  |NO |NO   <span style=\"color: #0000ff;\">&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt; Newly created data file<\/span>\nSYSAUX            |\/opt\/oracle\/oradata\/XE\/XEPDB1\/sysaux01.dbf                |ONLINE              |LOGGING  |YES|NO\nSYSTEM            |\/opt\/oracle\/oradata\/XE\/XEPDB1\/system01.dbf                |ONLINE              |LOGGING  |YES|NO\nUNDOTBS1          |\/opt\/oracle\/oradata\/XE\/XEPDB1\/undotbs01.dbf               |ONLINE              |LOGGING  |NO |NO\nUSERS             |\/opt\/oracle\/oradata\/XE\/XEPDB1\/users01.dbf                 |ONLINE              |LOGGING  |NO |NO\n\n3.) Create a user <span style=\"color: #0000ff;\">PREY_USER<\/span> with table EMP with few records.\n\n<\/b><b>\nSQL&gt; CREATE USER PREY_USER IDENTIFIED BY prey123 DEFAULT TABLESPACE HACK_TEST TEMPORARY TABLESPACE TEMP;\nUser created.\n\nSQL&gt; GRANT CONNECT, RESOURCE TO PREY_USER;\nGrant succeeded.\nSQL&gt; ALTER USER PREY_USER QUOTA UNLIMITED ON HACK_TEST;\nUser altered.\n<br \/><span style=\"color: #0000ff;\">Note :<\/span><br \/>SQL&gt;connect PREY_USER\/prey123@XEPDB1\n\nCREATE TABLE EMP \n       (EMPNO NUMBER(4),\n\tENAME VARCHAR2(10),\n        MOBILE_NUMBER VARCHAR2(20),\n        DEPTNO NUMBER(2));\n\nINSERT INTO EMP VALUES\n        (7566, \t'JONES','+91-7448236762', 10);\n\nINSERT INTO EMP VALUES\n        (7156, \t'RSAINI','+91-7448236444', 20);\t<\/b><\/span><\/span><br \/><b style=\"font-size: 14px; white-space: pre-wrap;\">SQL&gt; commit;\nCommit complete.\n<\/b><span style=\"font-size: 14px; white-space: pre-wrap;\"><b style=\"font-family: SFMono-Regular, Menlo, Monaco, Consolas, 'Liberation Mono', 'Courier New', monospace; font-size: 14px; white-space: pre-wrap;\">SQL&gt; exit<br \/>Disconnected from Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production Version 21.3.0.0.0<\/b><\/span><\/pre><pre style=\"background-color: rgba(0, 0, 0, 0.1); margin-bottom: 2.4rem; padding: 10px 20px; margin-top: 0px; overflow-wrap: normal; border-radius: 3px;\"><span style=\"font-size: 14px; white-space: pre-wrap;\"><b style=\"font-family: SFMono-Regular, Menlo, Monaco, Consolas, 'Liberation Mono', 'Courier New', monospace; font-size: 14px; white-space: pre-wrap;\"><\/b><span style=\"color: #0000ff;\"><strong>Most Important Step:<\/strong><br \/><\/span><span style=\"color: #0000ff; font-family: SFMono-Regular, Menlo, Monaco, Consolas, Liberation Mono, Courier New, monospace;\"><span style=\"font-size: 14px; white-space: pre-wrap; color: #000000;\"><b style=\"color: #000000; font-family: SFMono-Regular, Menlo, Monaco, Consolas, 'Liberation Mono', 'Courier New', monospace; font-size: 14px; white-space: pre-wrap;\">4.) Execute command with <\/b><strong><span style=\"color: #0000ff;\">sys \"ALTER SYSTEM CHECKPOINT;\"<\/span><\/strong><b style=\"color: #000000; font-family: SFMono-Regular, Menlo, Monaco, Consolas, 'Liberation Mono', 'Courier New', monospace; font-size: 14px; white-space: pre-wrap;\"> and <\/b><span style=\"color: #0000ff;\">\"A<strong>LTER SYSTEM SWITCH LOGFILE;\"<\/strong><\/span><span style=\"color: #000000; font-family: SFMono-Regular, Menlo, Monaco, Consolas, 'Liberation Mono', 'Courier New', monospace; font-size: 14px; white-space: pre-wrap;\"><span style=\"color: #000000; font-family: SFMono-Regular, Menlo, Monaco, Consolas, Liberation Mono, Courier New, monospace;\"><span style=\"font-size: 14px; white-space: pre-wrap;\"><b> to write data from buffer\/cache to datafiles. Note: repeat commands from <\/b><\/span><\/span><\/span><span style=\"color: #000000; font-family: SFMono-Regular, Menlo, Monaco, Consolas, Liberation Mono, Courier New, monospace;\">privileged<\/span><b style=\"color: #000000; font-family: SFMono-Regular, Menlo, Monaco, Consolas, 'Liberation Mono', 'Courier New', monospace; font-size: 14px; white-space: pre-wrap;\"> account 3 to 4 time. <\/b><\/span><\/span><b style=\"font-family: SFMono-Regular, Menlo, Monaco, Consolas, 'Liberation Mono', 'Courier New', monospace; font-size: 14px; white-space: pre-wrap;\">\n\n[oracle@localhost ~]$ sqlplus \/ as sysdba\n\nSQL*Plus: Release 21.0.0.0.0 - Production on Sat Jan 7 09:44:19 2023\nVersion 21.3.0.0.0\nCopyright (c) 1982, 2021, Oracle.  All rights reserved.\n\nConnected to:\nOracle Database 21c Express Edition Release 21.0.0.0.0 - Production\nVersion 21.3.0.0.0\n<\/b><\/span><b style=\"font-size: 14px; white-space: pre-wrap;\">\nALTER SYSTEM CHECKPOINT;\nALTER SYSTEM SWITCH LOGFILE;\n<br \/><\/b><span style=\"color: #000000;\"><strong>SQL&gt;\nSystem altered.\n\nSQL&gt;\nSystem altered.<\/strong><\/span>\n<span style=\"font-family: SFMono-Regular, Menlo, Monaco, Consolas, Liberation Mono, Courier New, monospace;\"><b style=\"font-size: 14px; white-space: pre-wrap;\">\n[oracle@localhost ~]$ <span style=\"color: #993366;\">strings<\/span> <span style=\"color: #0000ff;\">\/opt\/oracle\/oradata\/XE\/XEPDB1\/hack_test_datafile_01.dbf<\/span>\n}|{z\nHACK_TEST\nRL,w\nAAAAAAAA\n        &amp;       :       N       b       v\nQplsql_compiler_flagsINTERPRETED,NON_DEBUG\nQplscope_settingsIDENTIFIERS:NONE\nQplsql_ccflagsLUG\nQplsql_warnings\nDISABLE:ALL\nQnls_length_semanticsBYTE\nQplsql_debug_FALSE\nQplsql_code_typeUINTERPRETED\nQplsql_optimize_level2\npackage prvt_compress wrapped\na000000\nabcd\nabcd\nabcd\n........\n........\nabcd\nabcd\nabcd\nabcd\nabcd\nabcd\nabcd\n361 1ba\nZX2\/u+vZD4rXLycMsI\/HBGH27ygwg+3xAK5qfC9AWHPVSBoJlal1T)\n        '       ;       O       c       w\ntimeExja\n<span style=\"color: #993366;\">RSAINI                                                       <span style=\"color: #ff0000;\">&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt; You can see ENAME<\/span>\n+91-7448236444                         <span style=\"color: #ff0000;\">                      &lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt; You can see MOBILE_NUMBER<\/span>\nJONES                                                        <span style=\"color: #ff0000;\">&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt; You can see ENAME<\/span>\n+91-7448236762                                               <span style=\"color: #ff0000;\">&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt; You can see MOBILE_NUMBER<\/span><\/span>\n[oracle@localhost ~]$<\/b><b style=\"font-size: 14px; white-space: pre-wrap;\">\t\n<\/b><\/span><span style=\"color: #0000ff; font-family: SFMono-Regular, Menlo, Monaco, Consolas, Liberation Mono, Courier New, monospace;\"><span style=\"font-size: 14px; white-space: pre-wrap; color: #000000;\"><b>\u00a0<\/b><\/span><\/span><\/pre>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-c9359f2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c9359f2\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fd02ff0\" data-id=\"fd02ff0\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9b1865b elementor-widget elementor-widget-text-editor\" data-id=\"9b1865b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><strong><span style=\"color: #0000ff;\">Hence it is proved, We can read data from oracle data files if files are not encrypted.\u00a0\u00a0<\/span><\/strong><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-b09e26f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b09e26f\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2bb198d\" data-id=\"2bb198d\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d1b6d0a elementor-widget elementor-widget-heading\" data-id=\"d1b6d0a\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">What are the security features in oracle database?\n<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-010380e elementor-widget elementor-widget-button\" data-id=\"010380e\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a href=\"https:\/\/dbanextstep.com\/index.php\/2023\/01\/03\/database-security\/\" class=\"elementor-button-link elementor-button elementor-size-sm elementor-animation-pulse\" role=\"button\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">See the Blog<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Table of Contents RND &amp; TESTING to read data \/ Contents from oracle datafiles which are not encrypted and Prove, why encryption is important for &hellip; <\/p>\n","protected":false},"author":6,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v18.4 (Yoast SEO v18.6) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>READ DataFile with OS CMD - DBA Next Step<\/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:\/\/dbanextstep.com\/index.php\/transparent-data-encryption\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"READ DataFile with OS CMD\" \/>\n<meta property=\"og:description\" content=\"Table of Contents RND &amp; TESTING to read data \/ Contents from oracle datafiles which are not encrypted and Prove, why encryption is important for &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbanextstep.com\/index.php\/transparent-data-encryption\/\" \/>\n<meta property=\"og:site_name\" content=\"DBA Next Step\" \/>\n<meta property=\"article:modified_time\" content=\"2023-01-10T23:13:03+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbanextstep.com\/#website\",\"url\":\"https:\/\/dbanextstep.com\/\",\"name\":\"DBA Next Step\",\"description\":\"DBA Best Practices \/ Oracle +\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbanextstep.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbanextstep.com\/index.php\/transparent-data-encryption\/#webpage\",\"url\":\"https:\/\/dbanextstep.com\/index.php\/transparent-data-encryption\/\",\"name\":\"READ DataFile with OS CMD - DBA Next Step\",\"isPartOf\":{\"@id\":\"https:\/\/dbanextstep.com\/#website\"},\"datePublished\":\"2023-01-07T12:07:04+00:00\",\"dateModified\":\"2023-01-10T23:13:03+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/dbanextstep.com\/index.php\/transparent-data-encryption\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbanextstep.com\/index.php\/transparent-data-encryption\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbanextstep.com\/index.php\/transparent-data-encryption\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbanextstep.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"READ DataFile with OS CMD\"}]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"READ DataFile with OS CMD - DBA Next Step","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:\/\/dbanextstep.com\/index.php\/transparent-data-encryption\/","og_locale":"en_US","og_type":"article","og_title":"READ DataFile with OS CMD","og_description":"Table of Contents RND &amp; TESTING to read data \/ Contents from oracle datafiles which are not encrypted and Prove, why encryption is important for &hellip;","og_url":"https:\/\/dbanextstep.com\/index.php\/transparent-data-encryption\/","og_site_name":"DBA Next Step","article_modified_time":"2023-01-10T23:13:03+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/dbanextstep.com\/#website","url":"https:\/\/dbanextstep.com\/","name":"DBA Next Step","description":"DBA Best Practices \/ Oracle +","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbanextstep.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/dbanextstep.com\/index.php\/transparent-data-encryption\/#webpage","url":"https:\/\/dbanextstep.com\/index.php\/transparent-data-encryption\/","name":"READ DataFile with OS CMD - DBA Next Step","isPartOf":{"@id":"https:\/\/dbanextstep.com\/#website"},"datePublished":"2023-01-07T12:07:04+00:00","dateModified":"2023-01-10T23:13:03+00:00","breadcrumb":{"@id":"https:\/\/dbanextstep.com\/index.php\/transparent-data-encryption\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbanextstep.com\/index.php\/transparent-data-encryption\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbanextstep.com\/index.php\/transparent-data-encryption\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbanextstep.com\/"},{"@type":"ListItem","position":2,"name":"READ DataFile with OS CMD"}]}]}},"_links":{"self":[{"href":"https:\/\/dbanextstep.com\/index.php\/wp-json\/wp\/v2\/pages\/1514"}],"collection":[{"href":"https:\/\/dbanextstep.com\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/dbanextstep.com\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/dbanextstep.com\/index.php\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/dbanextstep.com\/index.php\/wp-json\/wp\/v2\/comments?post=1514"}],"version-history":[{"count":66,"href":"https:\/\/dbanextstep.com\/index.php\/wp-json\/wp\/v2\/pages\/1514\/revisions"}],"predecessor-version":[{"id":2068,"href":"https:\/\/dbanextstep.com\/index.php\/wp-json\/wp\/v2\/pages\/1514\/revisions\/2068"}],"wp:attachment":[{"href":"https:\/\/dbanextstep.com\/index.php\/wp-json\/wp\/v2\/media?parent=1514"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}