{"id":1662,"date":"2023-01-08T14:02:33","date_gmt":"2023-01-08T14:02:33","guid":{"rendered":"https:\/\/dbanextstep.com\/?page_id=1662"},"modified":"2023-01-11T08:04:10","modified_gmt":"2023-01-11T08:04:10","slug":"transparent-data-encryptiontde","status":"publish","type":"page","link":"https:\/\/dbanextstep.com\/index.php\/transparent-data-encryptiontde\/","title":{"rendered":"Transparent Data Encryption(TDE)"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"1662\" class=\"elementor elementor-1662\" data-elementor-settings=\"{&quot;scroll_snap&quot;:&quot;yes&quot;}\">\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-f25a42a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f25a42a\" 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-f91897f\" data-id=\"f91897f\" 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-3f17d63 elementor-widget elementor-widget-image\" data-id=\"3f17d63\" data-element_type=\"widget\" data-widget_type=\"image.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-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1583\" height=\"716\" src=\"https:\/\/dbanextstep.com\/wp-content\/uploads\/2023\/01\/Encrypted-Data-At-rest-v2-min.jpg\" class=\"attachment-full size-full\" alt=\"\" srcset=\"https:\/\/dbanextstep.com\/wp-content\/uploads\/2023\/01\/Encrypted-Data-At-rest-v2-min.jpg 1583w, https:\/\/dbanextstep.com\/wp-content\/uploads\/2023\/01\/Encrypted-Data-At-rest-v2-min-300x136.jpg 300w, https:\/\/dbanextstep.com\/wp-content\/uploads\/2023\/01\/Encrypted-Data-At-rest-v2-min-1024x463.jpg 1024w, https:\/\/dbanextstep.com\/wp-content\/uploads\/2023\/01\/Encrypted-Data-At-rest-v2-min-768x347.jpg 768w, https:\/\/dbanextstep.com\/wp-content\/uploads\/2023\/01\/Encrypted-Data-At-rest-v2-min-1536x695.jpg 1536w\" sizes=\"(max-width: 1583px) 100vw, 1583px\" \/>\t\t\t\t\t\t\t\t\t\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-34b3569d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"34b3569d\" 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-2f546ab3\" data-id=\"2f546ab3\" 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-43ba7682 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"43ba7682\" 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-d82bc15 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d82bc15\" 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-7ff89c6\" data-id=\"7ff89c6\" 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-5d6ade5 elementor-widget elementor-widget-heading\" data-id=\"5d6ade5\" 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\">What is Transparent Data Encryption in oracle?<\/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-1de8948 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1de8948\" 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-631bf5d\" data-id=\"631bf5d\" 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-001c929 elementor-widget elementor-widget-text-editor\" data-id=\"001c929\" 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<p>In Simple words, Transparent Data Encryption (TDE) is a feature in Oracle that allows you to <strong>encrypt sensitive data stored in tables and tablespaces<\/strong>. <strong>TDE encrypts the data at the storage level<\/strong>, so the data is transparently encrypted as it is written to disk and <strong>decrypted when it is read from disk<\/strong>.\u00a0<\/p><p>This means that <strong>applications do not need to be modified to use TDE<\/strong>, and <strong>users do not need to be aware that the data is encrypted.<\/strong><\/p><p>TDE uses a database encryption <strong>key to encrypt the data in the database<\/strong>, and this key is protected by a master key. The <strong>master key is encrypted using a certificate<\/strong>, which is stored in the database. When TDE is enabled, <strong>all data written to the database is encrypted using the database encryption key<\/strong>, and <strong>all data read from the database is decrypted using the same key<\/strong>.<\/p><p>TDE is useful for <strong>protecting sensitive data from unauthorized access<\/strong>, as it ensures that the <strong>data is encrypted at all times<\/strong>, even when it is being transmitted or backed up. It is also <strong>useful for<\/strong> <strong>compliance<\/strong> with data privacy regulations, such as the <strong>General Data Protection Regulation (GDPR)<\/strong> and the <strong>Health Insurance Portability, AADHAR Card,CREDIT Card etc<\/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-798cfcb6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"798cfcb6\" 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-1777fbcf\" data-id=\"1777fbcf\" 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-1496e755 elementor-widget elementor-widget-heading\" data-id=\"1496e755\" 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\">Why need to deploy TDE?\n<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-645a3af0 elementor-widget elementor-widget-button\" data-id=\"645a3af0\" 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\/transparent-data-encryption\/\" 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\">Secure your data from hacking or misuse<\/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<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-2ac6ac3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2ac6ac3\" 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-9270aeb\" data-id=\"9270aeb\" 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-60855f3 elementor-widget elementor-widget-heading\" data-id=\"60855f3\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Key points to remember<\/h3>\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-6f0db49 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6f0db49\" 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-2570dbf\" data-id=\"2570dbf\" 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-12a6ead elementor-widget elementor-widget-text-editor\" data-id=\"12a6ead\" 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<ol><li>(TDE) enables you to encrypt sensitive data that you store in tables and tablespaces.<\/li><li>After the data is encrypted, this data is transparently decrypted for authorized users.<\/li><li>TDE stores the encryption keys in a security module external to the database, called a Keystore \/ Wallet.<\/li><li>Transparent to applications because the encryption and decryption processes do not require any application changes.<\/li><\/ol><p><strong><span style=\"color: #0000ff;\">Note: Sqlnet.ora file is very important to implement complete wallet.<\/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-eb2af69 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"eb2af69\" 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-ccf73c2\" data-id=\"ccf73c2\" 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-2c51ce3 elementor-widget elementor-widget-heading\" data-id=\"2c51ce3\" 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\">Benefits of TDE<\/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-4aca163 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4aca163\" 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-ebdd045\" data-id=\"ebdd045\" 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-a420623 elementor-widget elementor-widget-text-editor\" data-id=\"a420623\" 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<ul><li>Providing highly level of security.<\/li><li>Storage Media encrypted so no worry for misuse of data .<\/li><li>No need to change at Application end.<\/li><li>Help in regulatory Compliance.<\/li><li>Zero downtime required to deploy on prod.<\/li><\/ul>\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-df20039 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"df20039\" 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-8c8d736\" data-id=\"8c8d736\" 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-05f4361 elementor-widget elementor-widget-heading\" data-id=\"05f4361\" 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\">TDE Key Architecture<\/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-511697e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"511697e\" 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-50 elementor-top-column elementor-element elementor-element-27f0bbb\" data-id=\"27f0bbb\" 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-51dc67d elementor-widget elementor-widget-image\" data-id=\"51dc67d\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1024\" height=\"538\" src=\"https:\/\/dbanextstep.com\/wp-content\/uploads\/2023\/01\/Encrypted-Key-Arch1-min-1024x538.jpg\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/dbanextstep.com\/wp-content\/uploads\/2023\/01\/Encrypted-Key-Arch1-min-1024x538.jpg 1024w, https:\/\/dbanextstep.com\/wp-content\/uploads\/2023\/01\/Encrypted-Key-Arch1-min-300x158.jpg 300w, https:\/\/dbanextstep.com\/wp-content\/uploads\/2023\/01\/Encrypted-Key-Arch1-min-768x403.jpg 768w, https:\/\/dbanextstep.com\/wp-content\/uploads\/2023\/01\/Encrypted-Key-Arch1-min.jpg 1295w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\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<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-59ad399\" data-id=\"59ad399\" 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-86d6a17 elementor-widget elementor-widget-text-editor\" data-id=\"86d6a17\" 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<ul><li>Data encryption keys are created and managed by TDE automatically<\/li><li>A master encryption key encrypts the data encryption keys<\/li><li>The master key typically is stored in Oracle Wallet or Oracle Key Vault<\/li><\/ul>\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-2c7699a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2c7699a\" 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-d3dec12\" data-id=\"d3dec12\" 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-0ebfe08 elementor-widget elementor-widget-heading\" data-id=\"0ebfe08\" 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\"> Tablespace Encryption vs Column Encryption <\/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-9b39496 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9b39496\" 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-50 elementor-top-column elementor-element elementor-element-6539d23\" data-id=\"6539d23\" 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-5368150 elementor-widget elementor-widget-heading\" data-id=\"5368150\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Column<\/p>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d191b9f elementor-widget elementor-widget-text-editor\" data-id=\"d191b9f\" 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<ul><li>Encrypt individual columns<\/li><li>Unique for all encrypted columns in a table<span style=\"color: #ff9900;\"><strong> (a bit overhead to manage)<\/strong><\/span><\/li><li>Default Algorithm : <strong><span style=\"color: #0000ff;\">AES 192<\/span><\/strong><\/li><li>Execution Plans may be change for a table<\/li><li>Encrypted <span style=\"color: #0000ff;\"><strong>inside Buffer Cache<\/strong>, <strong>gets decrypted when moved to PGA<\/strong><\/span><\/li><\/ul>\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<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-017a774\" data-id=\"017a774\" 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-d700a75 elementor-widget elementor-widget-heading\" data-id=\"d700a75\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<p class=\"elementor-heading-title elementor-size-default\">Tablespace<\/p>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-75218b5 elementor-widget elementor-widget-text-editor\" data-id=\"75218b5\" 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<ul><li>Encrypt the entire Tablespace (All Datafiles)<\/li><li>Unique Tablespace Key (Same key for all datafiles in a tablespace)<\/li><li>Default Algorithm : <strong><span style=\"color: #0000ff;\">AES 128<\/span><\/strong><\/li><li>Execution Plans <strong><span style=\"color: #339966;\">(Oracle recommended)<\/span><\/strong><\/li><li><strong><span style=\"color: #0000ff;\">Data stays decrypted inside Buffer Cache<\/span><\/strong><\/li><\/ul>\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-876de3e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"876de3e\" 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-7a153f4\" data-id=\"7a153f4\" 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-8e383a8 elementor-widget elementor-widget-heading\" data-id=\"8e383a8\" 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\">Database detail before implement TDE<\/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-50503b1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"50503b1\" 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-aacdfff\" data-id=\"aacdfff\" 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-525a6c3 elementor-widget elementor-widget-text-editor\" data-id=\"525a6c3\" 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>Database Version:&nbsp;Oracle Database <span style=\"color: #0000ff;\"><strong>21c Express Edition Release 21.0.0.0.0<\/strong><\/span> &#8211; Production&nbsp;<span style=\"color: var( --e-global-color-text ); font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-weight: var( --e-global-typography-text-font-weight ); font-size: 1.125rem;\">Version 21.3.0.0.0<\/span><\/p>\n<ul>\n<li>Database Name :&nbsp;<strong><span style=\"color: #0000ff;\">XE<\/span><\/strong><\/li>\n<li><span style=\"color: var( --e-global-color-text ); font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-weight: var( --e-global-typography-text-font-weight ); font-size: 1.125rem;\">CDB Name :&nbsp;<\/span><span style=\"color: #0000ff;\"><strong>CDB$ROOT<\/strong><\/span>&nbsp;<\/li>\n<li><span style=\"color: var( --e-global-color-text ); font-family: var( --e-global-typography-text-font-family ), Sans-serif; font-weight: var( --e-global-typography-text-font-weight ); font-size: 1.125rem;\">PDB Database Name :&nbsp;&nbsp;<\/span><strong><span style=\"color: #0000ff;\">XEPDB1<\/span><\/strong><\/li>\n<li><span style=\"color: #0000ff;\"><span style=\"font-weight: bolder; color: #000000;\"><span style=\"color: #0000ff;\"><span style=\"color: #000000;\"><span style=\"color: #000000;\"><b>Decided<\/b><span style=\"font-weight: bolder;\"> to set default (root) location to save keys<\/span><\/span><\/span><span style=\"color: #0000ff;\"><span style=\"font-weight: bolder;\"> : &#8220;\/opt\/oracle\/wallet&#8221; (use parameter WALLET_ROOT)<\/span><\/span><\/span><\/span><br><\/span><\/li>\n<li><strong><span style=\"color: #0000ff;\"><span style=\"color: #000000;\">Location to save keys<\/span> :&nbsp;<\/span><\/strong><span style=\"color: #0000ff;\"><b>\/opt\/oracle\/wallet\/<span style=\"color: #00ccff;\">tde<\/span>&nbsp;<span style=\"color: #ff9900;\">(manually created)<\/span><\/b><\/span><\/li>\n<li><span style=\"color: #000000;\"><b>Location of sqlnet.ora :&nbsp;<\/b><\/span><span style=\"color: #0000ff;\"><b>\/opt\/oracle\/homes\/OraDBHome21cXE\/network\/admin\/sqlnet.ora<\/b><\/span><\/li>\n<li><span style=\"color: #0000ff;\"><b><span style=\"color: #000000;\">Parameters need to takecare :<\/span>&nbsp;<\/b><\/span><strong><span style=\"color: #0000ff;\">WALLET_ROOT<\/span><\/strong>&nbsp;,&nbsp;<strong><span style=\"color: #0000ff;\">TDE_CONFIGURATION&nbsp;<\/span><\/strong>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<\/li>\n<\/ul>\n<div><span style=\"color: #0000ff;\"><b><span style=\"color: #ff6600;\"><span style=\"text-decoration: underline;\">Note :<\/span> <u>sqlnet.ora is most important file<\/u><\/span> to configure oracle database wallet and network parameter setting<\/b><\/span><\/div>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-80744a6 elementor-widget elementor-widget-button\" data-id=\"80744a6\" 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:\/\/www.oracle.com\/in\/database\/technologies\/xe-downloads.html\" class=\"elementor-button-link elementor-button elementor-size-md\" 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\">Free Download 21c Express Edition<\/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<section data-particle_enable=\"false\" data-particle-mobile-disabled=\"false\" class=\"elementor-section elementor-top-section elementor-element elementor-element-0f4ef06 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0f4ef06\" 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-c863e1d\" data-id=\"c863e1d\" 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-c328af6 elementor-widget elementor-widget-heading\" data-id=\"c328af6\" 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\">Can we implement TDE directly on PDB database?<\/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-1eed6a6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1eed6a6\" 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-5d6a18e\" data-id=\"5d6a18e\" 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-6cdc318 elementor-widget elementor-widget-text-editor\" data-id=\"6cdc318\" 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>In simple words <span style=\"color: #0000ff;\">&#8220;No&#8221;<\/span><\/strong> . We have to enable TDE feature on CDB first and then we implement changes on PDB.<\/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-bed1923 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bed1923\" 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-8472ce8\" data-id=\"8472ce8\" 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-03a0633 elementor-widget elementor-widget-heading\" data-id=\"03a0633\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Configure Transparent Database Encryption (TDE) for CDB<\/h3>\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-2db2272 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2db2272\" 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-ff8b035\" data-id=\"ff8b035\" 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-ea19c8d elementor-widget elementor-widget-heading\" data-id=\"ea19c8d\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Capture current status \/ detail of XE database<\/h4>\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-79916185 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"79916185\" 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-4a9c160d\" data-id=\"4a9c160d\" 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-231e671c elementor-widget elementor-widget-text-editor\" data-id=\"231e671c\" 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=\"margin-bottom: 0px; margin-top: 0px;\"><b style=\"font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace; font-size: 14px;\">[oracle@localhost ~]$ sqlplus \/ as sysdba\n\nSQL*Plus: Release 21.0.0.0.0 - Production on Mon Jan 9 06:51:18 2023\nVersion 21.3.0.0.0\n\nCopyright (c) 1982, 2021, Oracle.  All rights reserved.\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--------|---|----------\n<span style=\"color: #0000ff;\">XE      |YES|         0<\/span>\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----------|----------|----------|---------------------------------------------------------------------------\n<span style=\"color: #0000ff;\">CDB$ROOT  |3006541124|READ WRITE|09-JAN-23 05.42.08.063 AM +00:00<\/span>\nPDB$SEED  |3937184287|READ ONLY |09-JAN-23 05.42.08.147 AM +00:00\n<span style=\"color: #0000ff;\">XEPDB1    | 671033675|READ WRITE|09-JAN-23 05.42.12.950 AM +00:00<\/span>\n\ncol WRL_PARAMETER format a10\ncol WRL_TYPE format a10\ncol wallet_type format a10\ncol STATUS format a20\ncol KEYSTORE_MODE format a50\nset linesize 300 trims on colsep |\nSQL&gt; set linesize 300\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      |<span style=\"color: #0000ff;\">UNKNOWN<\/span>   |NOT_AVAILABLE       |<span style=\"color: #0000ff;\">NONE          &lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt; CDB Status<\/span>\n         2|FILE      |UNKNOWN   |NOT_AVAILABLE       |UNITED\n         3|FILE      |UNKNOWN   |NOT_AVAILABLE       |UNITED\n\n\nSQL&gt; select name cname,dbid,E.con_id,wrl_type,wallet_type,status,keystore_mode\n  2  from V$ENCRYPTION_WALLET E , V$CONTAINERS C\n  3  where E.con_id=C.con_id ORDER BY CON_ID;\n\nCNAME     |      DBID|    CON_ID|WRL_TYPE  |WALLET_TYP|STATUS              |KEYSTORE_MODE\n----------|----------|----------|----------|----------|--------------------|--------------------------------------------------\n<span style=\"color: #0000ff;\">CDB$ROOT  |3006541124|         1|FILE      |UNKNOWN   |NOT_AVAILABLE       |NONE<\/span>\nPDB$SEED  |3937184287|         2|FILE      |UNKNOWN   |NOT_AVAILABLE       |UNITED\n<span style=\"color: #0000ff;\">XEPDB1    | 671033675|         3|FILE      |UNKNOWN   |NOT_AVAILABLE       |UNITED\n<\/span><\/b><span style=\"font-family: ui-monospace, SFMono-Regular, SF Mono, Menlo, Consolas, Liberation Mono, monospace;\"><span style=\"font-size: 14px;\"><b><br \/><\/b><\/span><\/span><\/pre><pre style=\"margin-bottom: 0px; margin-top: 0px;\"><span style=\"font-family: ui-monospace, SFMono-Regular, SF Mono, Menlo, Consolas, Liberation Mono, monospace;\"><span style=\"font-size: 14px;\"><b>SQL&gt; SELECT * FROM V$ENCRYPTION_WALLET;\n\nWRL_TYPE  |WRL_PARAMETER                           |STATUS              |WALLET_TYP|WALLET_OR|KEYSTORE_MODE            |FULLY_BAC|    CON_ID\n----------|----------------------------------------|--------------------|----------|---------|-------------------------|---------|----------\n<span style=\"color: #0000ff;\">FILE      |\/opt\/oracle\/admin\/XE\/wallet             |NOT_AVAILABLE       |UNKNOWN   |SINGLE   |NONE                     |UNDEFINED|         1  &lt;&lt;&lt;&lt;&lt; Default Setting<\/span>\nFILE      |                                        |NOT_AVAILABLE       |UNKNOWN   |SINGLE   |UNITED                   |UNDEFINED|         2\nFILE      |                                        |NOT_AVAILABLE       |UNKNOWN   |SINGLE   |UNITED                   |UNDEFINED|         3\n\nSQL&gt; show parameter WALLET_ROOT\n\nNAME                                |TYPE       |VALUE\n------------------------------------|-----------|------------------------------\n<span style=\"color: #0000ff;\">wallet_root                         |string     |      &lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt; Null need to set for base directory of wallet\n<\/span><\/b><\/span><\/span><b style=\"font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace; font-size: 14px;\">\nSQL&gt; col FILE_NAME format a70\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------------------------------|----------------------------------------------------------------------|--------------------|---------|---|---\nSYSAUX                        |\/opt\/oracle\/oradata\/XE\/sysaux01.dbf                                   |ONLINE              |LOGGING  |YES|<span style=\"color: #0000ff;\">NO          &lt;&lt;&lt;&lt;&lt; Encryption not enabled yet<\/span>\nSYSTEM                        |\/opt\/oracle\/oradata\/XE\/system01.dbf                                   |ONLINE              |LOGGING  |YES|<span style=\"color: #0000ff;\">NO          &lt;&lt;&lt;&lt;&lt; Encryption not enabled yet<\/span>\nUNDOTBS1                      |\/opt\/oracle\/oradata\/XE\/undotbs01.dbf                                  |ONLINE              |LOGGING  |NO |<span style=\"color: #0000ff;\">NO          &lt;&lt;&lt;&lt;&lt; Encryption not enabled yet<\/span>\nUSERS                         |\/opt\/oracle\/oradata\/XE\/users01.dbf                                    |ONLINE              |LOGGING  |NO |<span style=\"color: #0000ff;\">NO          &lt;&lt;&lt;&lt;&lt; Encryption not enabled yet<\/span>\n\nSQL&gt; show pdbs\n\n    CON_ID|CON_NAME                      |OPEN MODE |RESTRICTED\n----------|------------------------------|----------|----------\n         2|PDB$SEED                      |READ ONLY |NO\n         3|XEPDB1                        |READ WRITE|NO\nSQL&gt;\n<span style=\"color: #0000ff;\">##### Create new tablespace \"encryption_test\" for encryption test<\/span>\nSQL&gt; create tablespace encryption_test datafile\n       '\/opt\/oracle\/oradata\/XE\/encrypt_tb01.dbf' size 1G;  \n\nTablespace created.\n\nSQL&gt; select T.TABLESPACE_NAME,d.FILE_NAME,T.STATUS,T.LOGGING,T.FORCE_LOGGING,T.ENCRYPTED\n  2  from dba_tablespaces T ,\n  3  dba_data_files d\nwhere T.TABLESPACE_NAME=D.TABLESPACE_NAME order by 1;  \n\nTABLESPACE_NAME               |FILE_NAME                                                             |STATUS              |LOGGING  |FOR|ENC\n------------------------------|----------------------------------------------------------------------|--------------------|---------|---|---\nENCRYPTION_TEST               |\/opt\/oracle\/oradata\/XE\/encrypt_tb01.dbf                               |ONLINE              |LOGGING  |NO |<span style=\"color: #0000ff;\">NO       &lt;&lt;&lt;&lt;&lt; Newly created but encryption not set yet<\/span>\nSYSAUX                        |\/opt\/oracle\/oradata\/XE\/sysaux01.dbf                                   |ONLINE              |LOGGING  |YES|NO\nSYSTEM                        |\/opt\/oracle\/oradata\/XE\/system01.dbf                                   |ONLINE              |LOGGING  |YES|NO\nUNDOTBS1                      |\/opt\/oracle\/oradata\/XE\/undotbs01.dbf                                  |ONLINE              |LOGGING  |NO |NO\nUSERS                         |\/opt\/oracle\/oradata\/XE\/users01.dbf                                    |ONLINE              |LOGGING  |NO |NO\n<\/b>\u00a0<b>\n<\/b><\/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-541d800 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"541d800\" 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-4b3bbea\" data-id=\"4b3bbea\" 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-cb93de0 elementor-widget elementor-widget-heading\" data-id=\"cb93de0\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Create user scott, allocate tablespace,create table emp and insert few records. <\/h4>\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-5d2987ab elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5d2987ab\" 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-78254657\" data-id=\"78254657\" 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-4a77251a elementor-widget elementor-widget-text-editor\" data-id=\"4a77251a\" 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=\"margin-bottom: 0px; margin-top: 0px;\"><span style=\"font-family: ui-monospace, SFMono-Regular, SF Mono, Menlo, Consolas, Liberation Mono, monospace;\"><span style=\"font-size: 14px;\"><b>SQL&gt; CREATE USER scott IDENTIFIED BY tiger DEFAULT TABLESPACE encryption_test TEMPORARY TABLESPACE TEMP;\nCREATE USER scott IDENTIFIED BY tiger DEFAULT TABLESPACE encryption_test TEMPORARY TABLESPACE TEMP\n            *\n<span style=\"color: #ff0000;\">ERROR at line 1:\nORA-65096: invalid common user or role name<\/span>\n\n\n<span style=\"color: #0000ff;\">SQL&gt; alter session set \"_ORACLE_SCRIPT\"=true;    &lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;Set parameter to resolve above problem<\/span>\n\nSession altered.\n\nSQL&gt; CREATE USER <\/b><span style=\"color: #0000ff;\">scott<\/span> <b>IDENTIFIED BY tiger DEFAULT TABLESPACE <span style=\"color: #0000ff;\">encryption_test<\/span> TEMPORARY TABLESPACE <span style=\"color: #0000ff;\">TEMP<\/span>;\n\nUser created.\n\nSQL&gt; GRANT CONNECT, RESOURCE TO scott;\n\nGrant succeeded.\n\nSQL&gt; ALTER USER scott QUOTA UNLIMITED ON <span style=\"color: #0000ff;\">encryption_test<\/span>;\n\nUser altered.<br \/>\n<span style=\"color: #0000ff;\">#### Insert records for Scott user, Keep in mind still you are connected with SYS user<\/span> \n\nSQL&gt; CREATE TABLE scott.EMP\n       (EMPNO NUMBER(4), ENAME VARCHAR2(10), MOBILE_NUMBER VARCHAR2(20)) tablespace encryption_test;  \nTable created.\n\nSQL&gt; INSERT INTO scott.EMP VALUES\n        (7566, 'JONES','+91-7448236762');\n1 row created.\nSQL&gt; INSERT INTO scott.EMP VALUES\n       (7156,'RSAINI', '+91-9558236444');\n1 row created.\nSQL&gt; INSERT INTO scott.EMP VALUES\n        (7156,'RSAINI', '+91-8286744864');  2\n1 row created.\n<\/b><\/span><\/span><br \/><span style=\"font-family: ui-monospace, SFMono-Regular, SF Mono, Menlo, Consolas, Liberation Mono, monospace;\"><span style=\"font-size: 14px;\"><b><span style=\"color: #0000ff;\">SQL&gt; commit;                      &lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt; Save data with commit\nCommit complete<\/span>.\n<\/b><\/span><\/span><span style=\"color: #0000ff;\"><b style=\"font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace; font-size: 14px;\">\nSQL&gt; show user;                   &lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt; User Connected \nUSER is \"SYS\"\n<\/b><\/span><\/pre><div>\u00a0<\/div><div>\u00a0<\/div>\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-a71d05c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a71d05c\" 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-f88e9c8\" data-id=\"f88e9c8\" 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-d64ac02 elementor-widget elementor-widget-heading\" data-id=\"d64ac02\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Switch over log and Checkpoint to write data permanently in datafile. <\/h4>\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-634e73f9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"634e73f9\" 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-39614bc5\" data-id=\"39614bc5\" 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-3e10165a elementor-widget elementor-widget-text-editor\" data-id=\"3e10165a\" 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=\"margin-bottom: 0px; margin-top: 0px;\"><span style=\"font-family: ui-monospace, SFMono-Regular, SF Mono, Menlo, Consolas, Liberation Mono, monospace;\"><span style=\"font-size: 14px;\"><b><span style=\"color: #993366;\">SQL&gt; show user;\nUSER is \"SYS\"<br \/><\/span>\n<span style=\"color: #0000ff;\">SQL&gt; ALTER SYSTEM CHECKPOINT;\nSystem altered.<\/span>\n\nSQL&gt; \/\nSystem altered.\nSQL&gt; \/\nSystem altered.\n\n<span style=\"color: #0000ff;\">SQL&gt; ALTER SYSTEM SWITCH LOGFILE;\nSystem altered.<\/span>\n\n<span style=\"color: #0000ff;\">SQL&gt; ALTER SYSTEM SWITCH LOGFILE;\nSystem altered.<\/span>\n\n<span style=\"color: #0000ff;\">SQL&gt; ALTER SYSTEM SWITCH LOGFILE;\nSystem altered.<\/span>\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; \n\nTABLESPACE_NAME               |FILE_NAME                                                             |STATUS              |LOGGING  |FOR|ENC\n------------------------------|----------------------------------------------------------------------|--------------------|---------|---|---\n<span style=\"color: #0000ff;\">ENCRYPTION_TEST               |\/opt\/oracle\/oradata\/XE\/encrypt_tb01.dbf                               |ONLINE              |LOGGING  |NO |NO    &lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt; Still tablespace is not encrypted  <\/span>\nSYSAUX                        |\/opt\/oracle\/oradata\/XE\/sysaux01.dbf                                   |ONLINE              |LOGGING  |YES|NO\nSYSTEM                        |\/opt\/oracle\/oradata\/XE\/system01.dbf                                   |ONLINE              |LOGGING  |YES|NO\nUNDOTBS1                      |\/opt\/oracle\/oradata\/XE\/undotbs01.dbf                                  |ONLINE              |LOGGING  |NO |NO\nUSERS                         |\/opt\/oracle\/oradata\/XE\/users01.dbf                                    |ONLINE              |LOGGING  |NO |NO\n\n<span style=\"color: #0000ff;\">SQL&gt; ! &lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;    See \/ Read data file contents, You can see it is not protected and it is proved <span style=\"color: #ff0000;\">HACKER<\/span> can read data from normal datafile <\/span>\n[oracle@localhost ~]$ strings \/opt\/oracle\/oradata\/XE\/encrypt_tb01.dbf    <span style=\"color: #ff0000;\">&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt; As discussed in past, you can see the inserted data \/ read content from datafile.<\/span>\n}|{z\nENCRYPTION_TEST\nAAAAAAAA\nRSAINI\n+91-8286744864,\nRSAINI\n+91-9558236444,\nJONES\n+91-7448236762\n^C\n^Z\n[1]+  Stopped                 strings \/opt\/oracle\/oradata\/XE\/encrypt_tb01.dbf\n[oracle@localhost ~]$ exit\nexit\nThere are stopped jobs.\n[oracle@localhost ~]$ exit\nexit<\/b><\/span><\/span>\u00a0<\/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-a75ba21 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a75ba21\" 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-17bf2aa\" data-id=\"17bf2aa\" 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-a9c455c elementor-widget elementor-widget-heading\" data-id=\"a9c455c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Capture data and current status of wallet<\/h3>\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-a21bd13 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a21bd13\" 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-6922d8e\" data-id=\"6922d8e\" 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-2c6c58e elementor-widget elementor-widget-heading\" data-id=\"2c6c58e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Keep in mind to capture data for parameters <\/h4>\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-0b53cf3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0b53cf3\" 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-b82d2e8\" data-id=\"b82d2e8\" 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-b8a0640 elementor-widget elementor-widget-text-editor\" data-id=\"b8a0640\" 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<ul><li>WRL_PARAMETER<\/li><li>WALLET_ROOT<\/li><li>ENCRYPTION_WALLET_LOCATION (From sqlnet.ora file)<\/li><li>Decide the physical location of database wallet and keystore (Software)\u00a0<\/li><\/ul>\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-158a6f5b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"158a6f5b\" 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-c62662b\" data-id=\"c62662b\" 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-2804af34 elementor-widget elementor-widget-text-editor\" data-id=\"2804af34\" 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=\"margin-bottom: 0px; margin-top: 0px;\"><span style=\"font-family: ui-monospace, SFMono-Regular, SF Mono, Menlo, Consolas, Liberation Mono, monospace;\"><span style=\"font-size: 14px;\"><b>SQL&gt; col WRL_PARAMETER format a40\nSQL&gt; col KEYSTORE_MODE format a25\nSQL&gt; SELECT * FROM V$ENCRYPTION_WALLET;\n\nWRL_TYPE  |<span style=\"color: #0000ff;\">WRL_PARAMETER<\/span>                           |STATUS              |WALLET_TYP|WALLET_OR|KEYSTORE_MODE          |FULLY_BAC|    CON_ID\n----------|----------------------------------------|--------------------|----------|---------|-----------------------|---------|----------\n<span style=\"color: #0000ff;\">FILE      |\/opt\/oracle\/admin\/XE\/wallet             |NOT_AVAILABLE       |UNKNOWN   |SINGLE   |NONE                   |UNDEFINED|         1<\/span>\nFILE      |                                        |NOT_AVAILABLE       |UNKNOWN   |SINGLE   |UNITED                 |UNDEFINED|         2\nFILE      |                                        |NOT_AVAILABLE       |UNKNOWN   |SINGLE   |UNITED                 |UNDEFINED|         3\n\nSQL&gt; ! ls -ltr \/opt\/oracle\/admin\/XE\/wallet\n<span style=\"color: #ff0000;\">ls: cannot access '\/opt\/oracle\/admin\/XE\/wallet': No such file or directory<\/span><\/b><\/span><\/span>\n<br \/><br \/><span style=\"color: #0000ff;\"><b>#### Change location of Wallet root location<br \/>SQL&gt; alter system set WALLET_ROOT=\"\/opt\/oracle\/wallet\" scope=spfile; &lt;&lt;&lt;&lt;&lt;&lt; Parameter set in spfile\n\nSystem altered.\n\nSQL&gt; SELECT * FROM V$ENCRYPTION_WALLET;\n\nWRL_TYPE  |WRL_PARAMETER                           |STATUS              |WALLET_TYP|WALLET_OR|KEYSTORE_MODE          |FULLY_BAC|    CON_ID\n----------|----------------------------------------|--------------------|----------|---------|-----------------------|---------|----------\nFILE      |\/opt\/oracle\/admin\/XE\/wallet             |NOT_AVAILABLE       |UNKNOWN   |SINGLE   |NONE                   |UNDEFINED|         1\nFILE      |                                        |NOT_AVAILABLE       |UNKNOWN   |SINGLE   |UNITED                 |UNDEFINED|         2\nFILE      |                                        |NOT_AVAILABLE       |UNKNOWN   |SINGLE   |UNITED                 |UNDEFINED|         3\n<\/b><\/span><\/pre><pre style=\"margin-bottom: 0px; margin-top: 0px;\"><span style=\"font-family: ui-monospace, SFMono-Regular, SF Mono, Menlo, Consolas, Liberation Mono, monospace;\"><span style=\"font-size: 14px;\"><b>SQL&gt; SELECT WRL_PARAMETER,STATUS,WALLET_TYPE FROM V$ENCRYPTION_WALLET;\n\n<span style=\"color: #0000ff;\">WRL_PARAMETER<\/span>                           |STATUS              |WALLET_TYP\n----------------------------------------|--------------------|----------\n<span style=\"color: #0000ff;\">\/opt\/oracle\/admin\/XE\/wallet             |NOT_AVAILABLE       |UNKNOWN<\/span>\n                                        |NOT_AVAILABLE       |UNKNOWN\n                                        |NOT_AVAILABLE       |UNKNOWN<\/b><\/span><\/span><\/pre><pre style=\"margin-bottom: 0px; margin-top: 0px;\"><span style=\"font-family: ui-monospace, SFMono-Regular, SF Mono, Menlo, Consolas, Liberation Mono, monospace;\"><span style=\"font-size: 14px;\"><b>SQL&gt; SELECT KEY_ID,KEYSTORE_TYPE,CREATOR,CREATOR_INSTANCE_NAME,CREATOR_PDBNAME FROM V$ENCRYPTION_KEYS;\nno rows selected\n\n<\/b><\/span><\/span><b style=\"font-size: 14px; font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace; color: var( --e-global-color-text );\"><span style=\"color: #0000ff;\">###### All useful queries if you want to use<\/span> <\/b><br \/><b style=\"font-size: 14px; font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace; color: var( --e-global-color-text );\">SELECT * FROM V$ENCRYPTION_WALLET;<\/b><br \/><b style=\"font-size: 14px; font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace; color: var( --e-global-color-text );\">SELECT * FROM V$ENCRYPTION_KEYS;<\/b><br \/><b style=\"font-size: 14px; font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace; color: var( --e-global-color-text );\">SELECT WRL_PARAMETER,STATUS,WALLET_TYPE FROM V$ENCRYPTION_WALLET;<\/b><\/pre><pre style=\"margin-bottom: 0px; margin-top: 0px;\"><b>SELECT KEY_ID,KEYSTORE_TYPE,CREATOR,CREATOR_INSTANCE_NAME,CREATOR_PDBNAME FROM V$ENCRYPTION_KEYS;<\/b><b style=\"font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace; color: var( --e-global-color-text ); font-size: 14px;\"> <\/b>\u00a0<\/pre><div>\u00a0<\/div>\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-a1adff9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a1adff9\" 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-8da48b9\" data-id=\"8da48b9\" 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-bab1da8 elementor-widget elementor-widget-heading\" data-id=\"bab1da8\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Change the location of Wallet if you want<\/h3>\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-1a5da095 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1a5da095\" 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-73481a9d\" data-id=\"73481a9d\" 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-7556a5f1 elementor-widget elementor-widget-text-editor\" data-id=\"7556a5f1\" 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=\"margin-bottom: 0px; margin-top: 0px;\"><span style=\"font-size: 0.9375rem; color: var( --e-global-color-text ); font-weight: var( --e-global-typography-text-font-weight ); font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace;\"><span style=\"font-size: 14px;\"><b>######### Set <\/b><\/span><\/span><span style=\"color: #0000ff;\"><b style=\"font-size: 0.9375rem;\"><u><i>WALLET_ROOT<\/i><\/u> <\/b><\/span><b style=\"color: var( --e-global-color-text ); font-size: 14px; font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace;\">parameter with new location, <\/b><b style=\"font-size: 0.9375rem; color: var( --e-global-color-text );\"><span style=\"color: #0000ff;\"><u><i>WALLET_ROOT<\/i><\/u> <\/span>is parameter can set in spfile and need to restart database.  <\/b><\/pre><pre style=\"margin-bottom: 0px; margin-top: 0px;\"><span style=\"font-family: ui-monospace, SFMono-Regular, SF Mono, Menlo, Consolas, Liberation Mono, monospace;\"><span style=\"font-size: 14px;\"><b>SQL&gt; alter system set WALLET_ROOT=\"\/opt\/oracle\/wallet\" scope=spfile;\n\nSystem altered.\n\nSQL&gt; show parameter wallet\n\nNAME                                |TYPE       |VALUE\n------------------------------------|-----------|------------------------------\nssl_wallet                          |string     |\nwallet_root                         |string     |\n<br \/><\/b><\/span><\/span><\/pre><pre style=\"margin-bottom: 0px; margin-top: 0px;\"><span style=\"font-family: ui-monospace, SFMono-Regular, SF Mono, Menlo, Consolas, Liberation Mono, monospace;\"><span style=\"font-size: 14px;\"><b>SQL&gt; SELECT * FROM V$ENCRYPTION_WALLET;\n\nWRL_TYPE  |WRL_PARAMETER                           |STATUS              |WALLET_TYP|WALLET_OR|KEYSTORE_MODE            |FULLY_BAC|    CON_ID\n----------|----------------------------------------|--------------------|----------|---------|-------------------------|---------|----------\nFILE      |\/opt\/oracle\/admin\/XE\/wallet             |NOT_AVAILABLE       |UNKNOWN   |SINGLE   |NONE                     |UNDEFINED|         1\nFILE      |                                        |NOT_AVAILABLE       |UNKNOWN   |SINGLE   |UNITED                   |UNDEFINED|         2\nFILE      |                                        |NOT_AVAILABLE       |UNKNOWN   |SINGLE   |UNITED                   |UNDEFINED|         3\n<\/b><\/span><\/span><b style=\"font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace; font-size: 14px;\">\n<\/b><br \/><span style=\"color: #0000ff;\"><b style=\"font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace; font-size: 14px;\">#### Restart Database<br \/><\/b><\/span><span style=\"font-family: ui-monospace, SFMono-Regular, SF Mono, Menlo, Consolas, Liberation Mono, monospace;\"><span><span style=\"font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace; font-size: 14px; font-weight: bold; color: #0000ff;\">SQL&gt; shutdown immediate;<\/span><b style=\"font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace; font-size: 14px;\">\nDatabase closed.\nDatabase dismounted.\nORACLE instance shut down.\n<\/b><span style=\"font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace; font-size: 14px; font-weight: bold; color: #0000ff;\">SQL&gt; startup<\/span><b style=\"font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace; font-size: 14px;\">\nORACLE instance started.\n\nTotal System Global Area|1157625952|bytes\nFixed Size              |   9685088|bytes\nVariable Size           | 402653184|bytes\nDatabase Buffers        | 738197504|bytes\nRedo Buffers            |   7090176|bytes\nDatabase mounted.\nDatabase opened.<br \/>\n<\/b><strong><span style=\"color: #0000ff;\"><span style=\"font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace; font-size: 14px;\">SQL&gt; alter system register;   &lt;&lt;&lt; force to Register services with <\/span><span style=\"color: #0000ff; font-family: ui-monospace, SFMono-Regular, SF Mono, Menlo, Consolas, Liberation Mono, monospace;\"><span style=\"font-size: 14px;\">listener<\/span><\/span><\/span><\/strong><b style=\"font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace; font-size: 14px;\">\nSystem altered.\n\nSQL&gt; show parameter wallet\nNAME                                |TYPE       |VALUE\n------------------------------------|-----------|------------------------------\nssl_wallet                          |string     |\n<\/b><span style=\"font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace; font-size: 14px; font-weight: bold; color: #0000ff;\">wallet_root                         |string     |\/opt\/oracle\/wallet<\/span><b style=\"font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace; font-size: 14px;\">\nSQL&gt; SELECT * FROM V$ENCRYPTION_WALLET;\n\nWRL_TYPE  |WRL_PARAMETER                           |STATUS              |WALLET_TYP|WALLET_OR|KEYSTORE_MODE            |FULLY_BAC|    CON_ID\n----------|----------------------------------------|--------------------|----------|---------|-------------------------|---------|----------\nFILE      |                                        |NOT_AVAILABLE       |UNKNOWN   |SINGLE   |NONE                     |UNDEFINED|         1\nFILE      |                                        |NOT_AVAILABLE       |UNKNOWN   |SINGLE   |UNITED                   |UNDEFINED|         2\nFILE      |                                        |NOT_AVAILABLE       |UNKNOWN   |SINGLE   |UNITED                   |UNDEFINED|         3\n\nSQL&gt; <\/b><span style=\"font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace; font-size: 14px; font-weight: bold; color: #0000ff;\">alter system set TDE_CONFIGURATION=\"KEYSTORE_CONFIGURATION=FILE\" scope=both;<\/span><b style=\"font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace; font-size: 14px;\">                       <\/b><span style=\"font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace; font-size: 14px; font-weight: bold; color: #0000ff;\"> &lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt; Note the point<\/span><b style=\"font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace; font-size: 14px;\"> (Software wallet)\n\nSystem altered.\n\nSQL&gt; SELECT * FROM V$ENCRYPTION_WALLET;\n\nWRL_TYPE  |WRL_PARAMETER                           |STATUS              |WALLET_TYP|WALLET_OR|KEYSTORE_MODE            |FULLY_BAC|    CON_ID\n----------|----------------------------------------|--------------------|----------|---------|-------------------------|---------|----------\n<\/b><span style=\"font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace; font-size: 14px; font-weight: bold; color: #0000ff;\">FILE      |\/opt\/oracle\/wallet\/tde\/                 |NOT_AVAILABLE       |UNKNOWN   |SINGLE   |NONE                     |UNDEFINED|         1    &lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt; Note new directory created<\/span><b style=\"font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace; font-size: 14px;\"> \nFILE      |                                        |NOT_AVAILABLE       |UNKNOWN   |SINGLE   |UNITED                   |UNDEFINED|         2\nFILE      |                                        |NOT_AVAILABLE       |UNKNOWN   |SINGLE   |UNITED                   |UNDEFINED|         3<\/b><\/span><\/span>\u00a0<\/pre><div>\u00a0<\/div>\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-0badf31 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0badf31\" 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-fe43ac8\" data-id=\"fe43ac8\" 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-0a5718f elementor-widget elementor-widget-heading\" data-id=\"0a5718f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Change sqlnet.ora and  create \/ verify dir <\/h4>\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-6fb63f02 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6fb63f02\" 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-309ee71d\" data-id=\"309ee71d\" 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-396f1e1e elementor-widget elementor-widget-text-editor\" data-id=\"396f1e1e\" 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=\"margin-bottom: 0px; margin-top: 0px;\"><span style=\"font-family: ui-monospace, SFMono-Regular, SF Mono, Menlo, Consolas, Liberation Mono, monospace;\"><span style=\"font-size: 14px;\"><b>[oracle@localhost ~]$ ls -ltr \/opt\/oracle\/homes\/OraDBHome21cXE\/network\/admin\/sqlnet.ora\n-rw-r-----. 1 oracle oinstall 188 Jan  9 14:30 \/opt\/oracle\/homes\/OraDBHome21cXE\/network\/admin\/sqlnet.ora\n[oracle@localhost ~]$<\/b><\/span><\/span><br \/><span style=\"font-family: ui-monospace, SFMono-Regular, SF Mono, Menlo, Consolas, Liberation Mono, monospace;\"><span style=\"font-size: 14px;\"><b><span style=\"color: #0000ff;\">###### See sqlnet.ora before modify \/ set paramterer<\/span>\n[oracle@localhost ~]$ cat \/opt\/oracle\/homes\/OraDBHome21cXE\/network\/admin\/sqlnet.ora\n# sqlnet.ora Network Configuration File: \/opt\/oracle\/homes\/OraDBHome21cXE\/network\/admin\/sqlnet.ora\n# Generated by Oracle configuration tools.\n\nNAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)<\/b><\/span><\/span><br \/><b>[oracle@localhost ~]$<\/b><br \/><span style=\"font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace; font-size: 14px;\"><br \/><\/span><br \/><span style=\"font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace; font-size: 14px;\"><span style=\"color: #0000ff;\"><b>###### Backup of sqlnet.ora<\/b><\/span>\n[oracle@localhost ~]$ cp \/opt\/oracle\/homes\/OraDBHome21cXE\/network\/admin\/sqlnet.ora \/opt\/oracle\/homes\/OraDBHome21cXE\/network\/admin\/sqlnet.ora_bkp\n<br \/><\/span><b><span style=\"color: #0000ff;\">##### Modify Sqlnet.ora<\/span> <\/b><br \/><span style=\"font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace; font-size: 14px;\">[oracle@localhost ~]$ vi \/opt\/oracle\/homes\/OraDBHome21cXE\/network\/admin\/sqlnet.ora\n<br \/><\/span><span style=\"color: #0000ff;\"><strong>##### See file after modification<\/strong> <\/span><br \/><span style=\"font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace; font-size: 14px;\">[oracle@localhost ~]$ cat \/opt\/oracle\/homes\/OraDBHome21cXE\/network\/admin\/sqlnet.ora\n# sqlnet.ora Network Configuration File: \/opt\/oracle\/homes\/OraDBHome21cXE\/network\/admin\/sqlnet.ora\n# Generated by Oracle configuration tools.\n\nNAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)\n\n<span style=\"color: #ff6600;\"><strong><i>#######encryption setting#### Modified contents########\nENCRYPTION_WALLET_LOCATION =\n        (SOURCE = (METHOD = FILE)\n          (METHOD_DATA =\n          (DIRECTORY = \/opt\/oracle\/wallet\/tde)\n         )\n         )<\/i><\/strong><\/span>\n[oracle@localhost ~]$ <span style=\"color: #000080;\">ls -ltr \/opt\/oracle\/wallet\/tde<\/span>\n<span style=\"color: #ff0000;\">ls: cannot access '\/opt\/oracle\/wallet\/tde': No such file or directory<\/span>\n<br \/><\/span><b><span style=\"color: #0000ff;\">###### Create directory which is set\/showing at database level after restart<\/span> <br \/><span style=\"font-family: ui-monospace, SFMono-Regular, 'SF Mono', Menlo, Consolas, 'Liberation Mono', monospace; font-size: 14px;\">[oracle@localhost ~]$ mkdir -p \/opt\/oracle\/wallet\/tde <br \/>[oracle@localhost ~]$ ls -ltr \/opt\/oracle\/wallet\/tde <br \/>total 0 <br \/>[oracle@localhost ~]$<\/span><\/b>\u00a0<\/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-d2d36f1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d2d36f1\" 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-c6892fa\" data-id=\"c6892fa\" 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-afb3c45 elementor-widget elementor-widget-heading\" data-id=\"afb3c45\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">Create the keystore<\/h4>\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-7dc9bc2a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7dc9bc2a\" 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-739436a9\" data-id=\"739436a9\" 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-4ab1bc0b elementor-widget elementor-widget-text-editor\" data-id=\"4ab1bc0b\" 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=\"margin-bottom: 0px; margin-top: 0px;\"><span style=\"font-family: ui-monospace, SFMono-Regular, SF Mono, Menlo, Consolas, Liberation Mono, monospace;\"><span style=\"font-size: 14px;\"><b>SQL&gt; ADMINISTER KEY MANAGEMENT CREATE KEYSTORE '\/opt\/oracle\/wallet\/tde' IDENTIFIED BY welcome123;\n\nkeystore altered.\n\nSQL&gt; !\n[oracle@localhost ~]$ ls -ltr \/opt\/oracle\/wallet\/tde\ntotal 4\n<span style=\"color: #0000ff;\">-rw-------. 1 oracle oinstall 2555 Jan 10 07:22 ewallet.p12 <\/span>                   <span style=\"color: #0000ff;\">&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt; See newly created file<\/span>\n[oracle@localhost ~]$ exit\nexit\n<span style=\"color: #0000ff;\">#### Open Key Wallet<\/span>\nSQL&gt; ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY welcome123;\n\nkeystore altered.\n<br \/><span style=\"color: #0000ff;\">#### Set Master Encryption key (Need always keystore password)<\/span> \nSQL&gt; ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY welcome123 with backup;\n\nkeystore altered.\n\nSQL&gt; !ls -ltr \/opt\/oracle\/wallet\/tde\ntotal 8\n<span style=\"color: #0000ff;\">-rw-------. 1 oracle oinstall 2555 Jan 10 07:25 ewallet_2023011007255813.p12    <\/span><\/b><\/span><\/span><span style=\"color: #0000ff;\"><b>&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt; See another created file<\/b><span style=\"font-family: ui-monospace, SFMono-Regular, SF Mono, Menlo, Consolas, Liberation Mono, monospace;\"><span style=\"font-size: 14px;\"><b><br \/><\/b><\/span><\/span><\/span><span style=\"font-family: ui-monospace, SFMono-Regular, SF Mono, Menlo, Consolas, Liberation Mono, monospace;\"><span style=\"font-size: 14px;\"><b>-rw-------. 1 oracle oinstall 3995 Jan 10 07:26 ewallet.p12\n\nSQL&gt;\nSQL&gt; SELECT * FROM V$ENCRYPTION_WALLET;\n\nWRL_TYPE  |WRL_PARAMETER                           |STATUS              |WALLET_TYP|WALLET_OR|KEYSTORE_MODE            |FULLY_BAC|    CON_ID\n----------|----------------------------------------|--------------------|----------|---------|-------------------------|---------|----------\n<span style=\"color: #0000ff;\">FILE      |\/opt\/oracle\/wallet\/tde\/                 |OPEN                |PASSWORD  |SINGLE   |NONE                     |NO       |         1\n<\/span>FILE      |                                        |CLOSED              |UNKNOWN   |SINGLE   |UNITED                   |UNDEFINED|         2\nFILE      |                                        |CLOSED              |UNKNOWN   |SINGLE   |UNITED                   |UNDEFINED|         3\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------------------------------|----------------------------------------------------------------------|--------------------|---------|---|---\n<span style=\"color: #0000ff;\">ENCRYPTION_TEST               |\/opt\/oracle\/oradata\/XE\/encrypt_tb01.dbf                               |ONLINE              |LOGGING  |NO |NO   &lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;See <\/span><\/b><\/span><\/span><span style=\"color: #0000ff;\">ENCRYPTED status before<span style=\"font-family: ui-monospace, SFMono-Regular, SF Mono, Menlo, Consolas, Liberation Mono, monospace;\"><span style=\"font-size: 14px;\"><b><br \/><\/b><\/span><\/span><\/span><span style=\"font-family: ui-monospace, SFMono-Regular, SF Mono, Menlo, Consolas, Liberation Mono, monospace;\"><span style=\"font-size: 14px;\"><b>SYSAUX                        |\/opt\/oracle\/oradata\/XE\/sysaux01.dbf                                   |ONLINE              |LOGGING  |YES|NO\nSYSTEM                        |\/opt\/oracle\/oradata\/XE\/system01.dbf                                   |ONLINE              |LOGGING  |YES|NO\nUNDOTBS1                      |\/opt\/oracle\/oradata\/XE\/undotbs01.dbf                                  |ONLINE              |LOGGING  |NO |NO\nUSERS                         |\/opt\/oracle\/oradata\/XE\/users01.dbf                                    |ONLINE              |LOGGING  |NO |NO\n\n<\/b><strong><span style=\"color: #0000ff;\">SQL&gt; ALTER TABLESPACE ENCRYPTION_TEST ENCRYPTION online USING 'AES128' ENCRYPT;                  &lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt; enable <\/span><\/strong><\/span><\/span><strong><span style=\"color: #0000ff;\">ENCRYPTION on tablespace<span style=\"font-family: ui-monospace, SFMono-Regular, SF Mono, Menlo, Consolas, Liberation Mono, monospace;\"><span style=\"font-size: 14px;\"><br \/><\/span><\/span><\/span><\/strong><span style=\"font-family: ui-monospace, SFMono-Regular, SF Mono, Menlo, Consolas, Liberation Mono, monospace;\"><span style=\"font-size: 14px;\"><strong><span style=\"color: #0000ff;\">\nTablespace altered.\n<\/span><\/strong><b>\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------------------------------|----------------------------------------------------------------------|--------------------|---------|---|---\n<span style=\"color: #0000ff;\">ENCRYPTION_TEST               |\/opt\/oracle\/oradata\/XE\/encrypt_tb01.dbf                               |ONLINE              |LOGGING  |NO |YES <\/span><\/b><\/span><\/span><span style=\"color: #0000ff;\"><span style=\"font-size: 14px;\"><span style=\"font-weight: bold;\">&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt; See <\/span><\/span><span style=\"font-size: 0.9375rem; font-weight: var( --e-global-typography-text-font-weight );\">ENCRYPTED status After<\/span><span style=\"font-family: ui-monospace, SFMono-Regular, SF Mono, Menlo, Consolas, Liberation Mono, monospace;\"><span style=\"font-size: 14px;\"><b><br \/><\/b><\/span><\/span><\/span><span style=\"font-family: ui-monospace, SFMono-Regular, SF Mono, Menlo, Consolas, Liberation Mono, monospace;\"><span style=\"font-size: 14px;\"><b>SYSAUX                        |\/opt\/oracle\/oradata\/XE\/sysaux01.dbf                                   |ONLINE              |LOGGING  |YES|NO\nSYSTEM                        |\/opt\/oracle\/oradata\/XE\/system01.dbf                                   |ONLINE              |LOGGING  |YES|NO\nUNDOTBS1                      |\/opt\/oracle\/oradata\/XE\/undotbs01.dbf                                  |ONLINE              |LOGGING  |NO |NO\nUSERS                         |\/opt\/oracle\/oradata\/XE\/users01.dbf                                    |ONLINE              |LOGGING  |NO |NO\n\nSQL&gt;<\/b><\/span><\/span>\n<\/pre><div>\u00a0<\/div><div>\u00a0<\/div>\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-1413f7b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1413f7b\" 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-d743908\" data-id=\"d743908\" 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-5062169 elementor-widget elementor-widget-heading\" data-id=\"5062169\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-default\">See Encrypted \/ Decrypted data into datafile<\/h4>\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-0fb1363 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0fb1363\" 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-87007de\" data-id=\"87007de\" 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-f868b8e elementor-widget elementor-widget-text-editor\" data-id=\"f868b8e\" 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>See difference of Encrypted and Non-Encrypted tablespace datafile\u00a0<\/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-9ef6615 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9ef6615\" 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-50 elementor-top-column elementor-element elementor-element-7c6cb5e\" data-id=\"7c6cb5e\" 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-18f3e2a elementor-widget elementor-widget-image\" data-id=\"18f3e2a\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1024\" height=\"597\" src=\"https:\/\/dbanextstep.com\/wp-content\/uploads\/2023\/01\/Encrypted-Tablespace-Datafile-1-min-1024x597.jpg\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/dbanextstep.com\/wp-content\/uploads\/2023\/01\/Encrypted-Tablespace-Datafile-1-min-1024x597.jpg 1024w, https:\/\/dbanextstep.com\/wp-content\/uploads\/2023\/01\/Encrypted-Tablespace-Datafile-1-min-300x175.jpg 300w, https:\/\/dbanextstep.com\/wp-content\/uploads\/2023\/01\/Encrypted-Tablespace-Datafile-1-min-768x448.jpg 768w, https:\/\/dbanextstep.com\/wp-content\/uploads\/2023\/01\/Encrypted-Tablespace-Datafile-1-min.jpg 1040w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/>\t\t\t\t\t\t\t\t\t\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<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-5824d69\" data-id=\"5824d69\" 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-f0da84e elementor-widget elementor-widget-image\" data-id=\"f0da84e\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"824\" height=\"369\" src=\"https:\/\/dbanextstep.com\/wp-content\/uploads\/2023\/01\/Decrypted-Tablespace-Datafile-min.jpg\" class=\"attachment-large size-large\" alt=\"\" srcset=\"https:\/\/dbanextstep.com\/wp-content\/uploads\/2023\/01\/Decrypted-Tablespace-Datafile-min.jpg 824w, https:\/\/dbanextstep.com\/wp-content\/uploads\/2023\/01\/Decrypted-Tablespace-Datafile-min-300x134.jpg 300w, https:\/\/dbanextstep.com\/wp-content\/uploads\/2023\/01\/Decrypted-Tablespace-Datafile-min-768x344.jpg 768w\" sizes=\"(max-width: 824px) 100vw, 824px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-83d77a5 elementor-widget elementor-widget-text-editor\" data-id=\"83d77a5\" 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: #993366;\">You can see the &#8220;<span style=\"color: #ff0000;\">mobile&#8221;<\/span> are appearing during read of datafile which is not safe.<\/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-fa8460c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fa8460c\" 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-8f58b9f\" data-id=\"8f58b9f\" 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-097060e elementor-widget elementor-widget-heading\" data-id=\"097060e\" 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\">Configure Transparent Database Encryption (TDE) for PDB<\/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-15b11586 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"15b11586\" 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-1ce461aa\" data-id=\"1ce461aa\" 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-7f39db72 elementor-widget elementor-widget-text-editor\" data-id=\"7f39db72\" 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=\"margin-bottom: 0px; margin-top: 0px;\"><span style=\"font-family: ui-monospace, SFMono-Regular, SF Mono, Menlo, Consolas, Liberation Mono, monospace;\"><span style=\"font-size: 14px;\"><span style=\"color: #0000ff;\"><strong>## Connect to database<\/strong><\/span><b><br \/>[oracle@localhost ~]$ sqlplus \/ as sysdba\nSQL*Plus: Release 21.0.0.0.0 - Production on Tue Jan 10 20:36:22 2023\nVersion 21.3.0.0.0\n\nCopyright (c) 1982, 2021, Oracle.  All rights reserved.\nConnected to:\nOracle Database 21c Express Edition Release 21.0.0.0.0 - Production\nVersion 21.3.0.0.0\n\n<span style=\"color: #0000ff;\">SQL&gt; show pdbs<\/span>\n\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\n---------- ------------------------------ ---------- ----------\n         2 PDB$SEED                       READ ONLY  NO\n         3 XEPDB1                         READ WRITE NO\n\t\t \n<span style=\"color: #0000ff;\">#### Connect to pdb database xepdb1<\/span>\nSQL&gt;  Alter session set container=xepdb1;\nSession altered.\n\n<span style=\"color: #0000ff;\">#### Check current status of Keystore and Files<\/span>\n\ncol WRL_PARAMETER format a10\ncol WRL_TYPE format a10\ncol wallet_type format a10\ncol STATUS format a20\ncol KEYSTORE_MODE format a50\ncol CNAME format a10\nset 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         3|FILE      |UNKNOWN   |CLOSED              |UNITED\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;  2    3\n\nCNAME     |      DBID|    CON_ID|WRL_TYPE  |WALLET_TYP|STATUS              |KEYSTORE_MODE\n----------|----------|----------|----------|----------|--------------------|--------------------\nXEPDB1    |3507460321|         3|FILE      |UNKNOWN   |CLOSED              |UNITED                       <span style=\"color: #0000ff;\">&lt;&lt;&lt;&lt;&lt; WALLET_TYPE unknow and Closed<\/span>\n\n<span style=\"color: #0000ff;\">#### Tablespaces are non-encrypted<\/span>\n\nSQL&gt; col FILE_NAME format a70\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; \n\nTABLESPACE_NAME               |FILE_NAME                                                             |STATUS              |LOGGING  |FOR|ENC\n------------------------------|----------------------------------------------------------------------|--------------------|---------|---|---\nSYSAUX                        |\/opt\/oracle\/oradata\/XE\/XEPDB1\/sysaux01.dbf                            |ONLINE              |LOGGING  |YES|NO    <span style=\"color: #0000ff;\">&lt;&lt;&lt;&lt;&lt;&lt;&lt; Encryption not enabled<\/span>\nSYSTEM                        |\/opt\/oracle\/oradata\/XE\/XEPDB1\/system01.dbf                            |ONLINE              |LOGGING  |YES|NO    <span style=\"color: #0000ff;\">&lt;&lt;&lt;&lt;&lt;&lt;&lt; Encryption not enabled<\/span>\nUNDOTBS1                      |\/opt\/oracle\/oradata\/XE\/XEPDB1\/undotbs01.dbf                           |ONLINE              |LOGGING  |NO |NO    <span style=\"color: #0000ff;\">&lt;&lt;&lt;&lt;&lt;&lt;&lt; Encryption not enabled<\/span>\nUSERS                         |\/opt\/oracle\/oradata\/XE\/XEPDB1\/users01.dbf                             |ONLINE              |LOGGING  |NO |NO    <span style=\"color: #0000ff;\">&lt;&lt;&lt;&lt;&lt;&lt;&lt; Encryption not enabled<\/span>\n\n\n<span style=\"color: #0000ff;\">#### See wallet_root Parameter<\/span> \n\nSQL&gt; show parameter wallet\n\nNAME                                |TYPE       |VALUE\n------------------------------------|-----------|------------------------------\nssl_wallet                          |string     |\nwallet_root                         |string     |\/opt\/oracle\/wallet                       <span style=\"color: #0000ff;\">&lt;&lt;&lt;&lt;&lt; See root location of wallet<\/span>\n\nSQL&gt; !\n[oracle@localhost ~]$ ls -ltr \/opt\/oracle\/wallet\ntotal 0\ndrwxr-xr-x. 2 oracle oinstall 61 Jan 10 07:25 tde\n[oracle@localhost ~]$ exit\nexit\n\n[oracle@localhost ~]$  ls -ltr \/opt\/oracle\/wallet\/tde   <span style=\"color: #0000ff;\">&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt; Container Wallet files are already present<\/span> \ntotal 8\n-rw-------. 1 oracle oinstall 2555 Jan 10 07:25 ewallet_2023011007255813.p12 \n-rw-------. 1 oracle oinstall 3995 Jan 10 07:26 ewallet.p12\n[oracle@localhost ~]$ exit\nexit\n\n<span style=\"color: #0000ff;\"># Open the Keystore &amp; Create a Master Encryption Key for PDB<\/span>\n\nSQL&gt; ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY welcome123;      <span style=\"color: #0000ff;\">&lt;&lt;&lt;&lt; Open keystore at CDB level<\/span> \nADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY welcome123\n<span style=\"color: #ff0000;\">*\nERROR at line 1:\nORA-46661: keystore not open in root container<\/span>\n\nSQL&gt; ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY welcome123;   <span style=\"color: #0000ff;\">&lt;&lt;&lt;&lt;&lt; Once keystore is opened at CDB level, then you can open it PDB level<\/span> \nkeystore altered.\n\nSQL&gt; !\n[oracle@localhost ~]$ ls -ltr \/opt\/oracle\/wallet\/tde            <span style=\"color: #0000ff;\"> &lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt; Verify current files keystore files availavle in folder<\/span>\ntotal 8\n-rw-------. 1 oracle oinstall 2555 Jan 10 07:25 ewallet_2023011007255813.p12\n-rw-------. 1 oracle oinstall 3995 Jan 10 07:26 ewallet.p12\n\nSQL&gt; ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY oracle123 with backup;    <span style=\"color: #0000ff;\">&lt;&lt;&lt;&lt; If you try with other key<\/span> \nADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY oracle123 with backup\n<span style=\"color: #ff0000;\">*\nERROR at line 1:\nORA-46627: keystore password mismatch<\/span>\n\nSQL&gt; ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY welcome123 with backup;  <span style=\"color: #0000ff;\">&lt;&lt;&lt;&lt;&lt; If you try with same key used at container level<\/span> \nkeystore altered.\n\nSQL&gt; !\n[oracle@localhost ~]$ ls -ltr \/opt\/oracle\/wallet\/tde\ntotal 16\n-rw-------. 1 oracle oinstall 2555 Jan 10 07:25 ewallet_2023011007255813.p12\n-rw-------. 1 oracle oinstall 3995 Jan 10 20:09 ewallet_2023011020092033.p12    <span style=\"color: #0000ff;\">&lt;&lt;&lt;&lt;&lt; New file is created<\/span>\n-rw-------. 1 oracle oinstall 5467 Jan 10 20:09 ewallet.p12\n[oracle@localhost ~]$ exit\nexit\n\n<span style=\"color: #0000ff;\">#### Verify if the Wallet has been opened in PDB<\/span>\n\nSQL&gt; select con_id, WRL_TYPE,wallet_type,STATUS,KEYSTORE_MODE from V$encryption_wallet;    <span style=\"color: #0000ff;\">&lt;&lt;&lt;&lt; Re-verify status of wallet<\/span>\n\n    CON_ID|WRL_TYPE  |WALLET_TYP|STATUS              |KEYSTORE_MODE\n----------|----------|----------|--------------------|--------------------\n         3|FILE      |PASSWORD  |OPEN                |UNITED\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----------|----------|----------|----------|----------|--------------------|--------------------\nXEPDB1    |3507460321|         3|FILE      |PASSWORD  |OPEN                |UNITED\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;  \n\nTABLESPACE_NAME               |FILE_NAME                                                             |STATUS              |LOGGING  |FOR|ENC\n------------------------------|----------------------------------------------------------------------|--------------------|---------|---|---\nSYSAUX                        |\/opt\/oracle\/oradata\/XE\/XEPDB1\/sysaux01.dbf                            |ONLINE              |LOGGING  |YES|NO   <span style=\"color: #0000ff;\">&lt;&lt;&lt;&lt;&lt;&lt;&lt; Encryption not enabled<\/span>\nSYSTEM                        |\/opt\/oracle\/oradata\/XE\/XEPDB1\/system01.dbf                            |ONLINE              |LOGGING  |YES|NO  <span style=\"color: #0000ff;\"> &lt;&lt;&lt;&lt;&lt;&lt;&lt; Encryption not enabled<\/span>\nUNDOTBS1                      |\/opt\/oracle\/oradata\/XE\/XEPDB1\/undotbs01.dbf                           |ONLINE              |LOGGING  |NO |NO   <span style=\"color: #0000ff;\">&lt;&lt;&lt;&lt;&lt;&lt;&lt; Encryption not enabled<\/span>\nUSERS                         |\/opt\/oracle\/oradata\/XE\/XEPDB1\/users01.dbf                             |ONLINE              |LOGGING  |NO |NO   <span style=\"color: #0000ff;\">&lt;&lt;&lt;&lt;&lt;&lt;&lt; Encryption not enabled<\/span><\/b><\/span><\/span>\n<\/pre><div>\u00a0<\/div><div>\u00a0<\/div>\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-b45454c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b45454c\" 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-388e81e\" data-id=\"388e81e\" 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-9edd7d3 elementor-widget elementor-widget-heading\" data-id=\"9edd7d3\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Create \/ Alter Tablespace encryption option <\/h3>\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-527b15c1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"527b15c1\" 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-488eab8d\" data-id=\"488eab8d\" 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-9717903 elementor-widget elementor-widget-text-editor\" data-id=\"9717903\" 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=\"margin-bottom: 0px; margin-top: 0px;\"><span style=\"font-family: ui-monospace, SFMono-Regular, SF Mono, Menlo, Consolas, Liberation Mono, monospace;\"><span style=\"font-size: 14px;\"><b><span style=\"color: #0000ff;\">#### You can use following options for ENCRYPTION<\/span>\n\nSQL&gt;  create tablespace ENCRYPTION_PDB_TBS_01 datafile '\/opt\/oracle\/oradata\/XE\/XEPDB1\/encryption_pdb_tbs_01.dbf' size 1m\n   encryption using 'AES128' ENCRYPT;  \n\nTablespace created.\n\nSQL&gt; create tablespace ENCRYPTION_PDB_TBS_02 datafile '\/opt\/oracle\/oradata\/XE\/XEPDB1\/encryption_pdb_tbs_02.dbf' size 1m\n   encryption using 'AES256' default storage (encrypt) ;  \n\nTablespace created.\n\nSQL&gt; create tablespace ENCRYPTION_PDB_TBS_03 datafile\n       '\/opt\/oracle\/oradata\/XE\/XEPDB1\/encryption_pdb_tbs03.dbf' size 1m;    2\n\nTablespace created.\n\nSQL&gt;  ALTER TABLESPACE ENCRYPTION_PDB_TBS_03 ENCRYPTION USING 'AES256' ENCRYPT;\n\nTablespace altered.\n\nSQL&gt;\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; \n\nTABLESPACE_NAME               |FILE_NAME                                                             |STATUS              |LOGGING  |FOR|ENC\n------------------------------|----------------------------------------------------------------------|--------------------|---------|---|---\nENCRYPTION_PDB_TBS_01         |\/opt\/oracle\/oradata\/XE\/XEPDB1\/encryption_pdb_tbs_01.dbf               |ONLINE              |LOGGING  |NO |<span style=\"color: #0000ff;\">YES<\/span>   <span style=\"color: #00ff00;\">&lt;&lt;&lt;&lt;&lt; See tablespace is encrypted<\/span> \nENCRYPTION_PDB_TBS_02         |\/opt\/oracle\/oradata\/XE\/XEPDB1\/encryption_pdb_tbs_02.dbf               |ONLINE              |LOGGING  |NO |<span style=\"color: #0000ff;\">YES   <span style=\"color: #00ff00;\">&lt;&lt;&lt;&lt;&lt; See tablespace is encrypted<\/span><\/span>\nENCRYPTION_PDB_TBS_03         |\/opt\/oracle\/oradata\/XE\/XEPDB1\/encryption_pdb_tbs03.dbf                |ONLINE              |LOGGING  |NO |<span style=\"color: #0000ff;\">YES   <span style=\"color: #00ff00;\">&lt;&lt;&lt;&lt;&lt; See tablespace is encrypted<\/span><\/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\n7 rows selected.<\/b><\/span><\/span><\/pre><div>\u00a0<\/div>\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-0757107 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0757107\" 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-7e20399\" data-id=\"7e20399\" 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-b2f1c3b elementor-widget elementor-widget-heading\" data-id=\"b2f1c3b\" 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\">Issue \/ Problem during implementation of wallet and resolution<\/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-b20a174 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b20a174\" 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-d6d20b6\" data-id=\"d6d20b6\" 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-5dee46b elementor-widget elementor-widget-toggle\" data-id=\"5dee46b\" data-element_type=\"widget\" data-widget_type=\"toggle.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-toggle{text-align:left}.elementor-toggle .elementor-tab-title{font-weight:700;line-height:1;margin:0;padding:15px;border-bottom:1px solid #d4d4d4;cursor:pointer;outline:none}.elementor-toggle .elementor-tab-title .elementor-toggle-icon{display:inline-block;width:1em}.elementor-toggle .elementor-tab-title .elementor-toggle-icon svg{-webkit-margin-start:-5px;margin-inline-start:-5px;width:1em;height:1em}.elementor-toggle .elementor-tab-title .elementor-toggle-icon.elementor-toggle-icon-right{float:right;text-align:right}.elementor-toggle .elementor-tab-title .elementor-toggle-icon.elementor-toggle-icon-left{float:left;text-align:left}.elementor-toggle .elementor-tab-title .elementor-toggle-icon .elementor-toggle-icon-closed{display:block}.elementor-toggle .elementor-tab-title .elementor-toggle-icon .elementor-toggle-icon-opened{display:none}.elementor-toggle .elementor-tab-title.elementor-active{border-bottom:none}.elementor-toggle .elementor-tab-title.elementor-active .elementor-toggle-icon-closed{display:none}.elementor-toggle .elementor-tab-title.elementor-active .elementor-toggle-icon-opened{display:block}.elementor-toggle .elementor-tab-content{padding:15px;border-bottom:1px solid #d4d4d4;display:none}@media (max-width:767px){.elementor-toggle .elementor-tab-title{padding:12px}.elementor-toggle .elementor-tab-content{padding:12px 10px}}.e-con-inner>.elementor-widget-toggle,.e-con>.elementor-widget-toggle{width:var(--container-widget-width,100%)}<\/style>\t\t<div class=\"elementor-toggle\" role=\"tablist\">\n\t\t\t\t\t\t\t<div class=\"elementor-toggle-item\">\n\t\t\t\t\t<div id=\"elementor-tab-title-9841\" class=\"elementor-tab-title\" data-tab=\"1\" role=\"tab\" aria-controls=\"elementor-tab-content-9841\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon elementor-toggle-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon-closed\"><i class=\"fas fa-caret-right\"><\/i><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon-opened\"><i class=\"elementor-toggle-icon-opened fas fa-caret-up\"><\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"\" class=\"elementor-toggle-title\">ORA-46661: keystore not open in root container<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t<div id=\"elementor-tab-content-9841\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"1\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-9841\"><ul><li><span style=\"color: #0000ff;\"><strong>Connect to container and execute\u00a0<\/strong><\/span><\/li><\/ul><p>[oracle@localhost ~]$ sqlplus \/ as sysdba<br \/>SQL*Plus: Release 21.0.0.0.0 &#8211; Production on Tue Jan 10 19:54:09 2023<br \/>Version 21.3.0.0.0<br \/>Copyright (c) 1982, 2021, Oracle. All rights reserved.<\/p><p>Connected to:<br \/>Oracle Database 21c Express Edition Release 21.0.0.0.0 &#8211; Production<br \/>Version 21.3.0.0.0<\/p><p><strong>SQL&gt; ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY welcome123;<\/strong><br \/><span style=\"color: #0000ff;\"><strong>keystore altered.<\/strong><\/span><\/p><p>SQL&gt;<\/p><ul><li><span style=\"color: #0000ff;\"><strong>Now connect to PDB and try to open KEYSTORE<\/strong><\/span><\/li><\/ul><p>SQL&gt; ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED BY welcome123;<\/p><p><span style=\"color: #00ff00;\"><strong>keystore altered.<\/strong><\/span><\/p><p>SQL&gt;<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-toggle-item\">\n\t\t\t\t\t<div id=\"elementor-tab-title-9842\" class=\"elementor-tab-title\" data-tab=\"2\" role=\"tab\" aria-controls=\"elementor-tab-content-9842\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon elementor-toggle-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon-closed\"><i class=\"fas fa-caret-right\"><\/i><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon-opened\"><i class=\"elementor-toggle-icon-opened fas fa-caret-up\"><\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"\" class=\"elementor-toggle-title\">ORA-46633 Description: creation of a password-based keystore failed<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t<div id=\"elementor-tab-content-9842\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"2\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-9842\"><p>Cause:\u00a0<strong>Password<\/strong>-based\u00a0<strong>keystore<\/strong>\u00a0could not be created at the specified location due to either incorrect file permissions for Oracle on the specified location or due to the nonexistence of the specified location.<\/p><p>Or\u00a0<\/p><p>You are connected to PDB and try to create a KEYSTORE\u00a0\u00a0<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<div class=\"elementor-toggle-item\">\n\t\t\t\t\t<div id=\"elementor-tab-title-9843\" class=\"elementor-tab-title\" data-tab=\"3\" role=\"tab\" aria-controls=\"elementor-tab-content-9843\" aria-expanded=\"false\">\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon elementor-toggle-icon-left\" aria-hidden=\"true\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon-closed\"><i class=\"fas fa-caret-right\"><\/i><\/span>\n\t\t\t\t\t\t\t\t<span class=\"elementor-toggle-icon-opened\"><i class=\"elementor-toggle-icon-opened fas fa-caret-up\"><\/i><\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"\" class=\"elementor-toggle-title\">ORA-46627: keystore password mismatch<\/a>\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t<div id=\"elementor-tab-content-9843\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"3\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-9843\"><p>SQL&gt; ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY oracle123 with backup;<br \/>ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY oracle123 with backup<br \/>*<br \/>ERROR at line 1:<br \/>ORA-46627: keystore password mismatch<\/p><p><br \/>SQL&gt; ADMINISTER KEY MANAGEMENT SET KEY IDENTIFIED BY welcome123 with backup;<\/p><p>keystore altered.<\/p><p>SQL&gt; !<br \/>[oracle@localhost ~]$ ls -ltr \/opt\/oracle\/wallet\/tde<br \/>total 16<br \/>-rw&#8212;&#8212;-. 1 oracle oinstall 2555 Jan 10 07:25 ewallet_2023011007255813.p12<br \/>-rw&#8212;&#8212;-. 1 oracle oinstall 3995 Jan 10 20:09 ewallet_2023011020092033.p12\u00a0 \u00a0 <span style=\"color: #0000ff;\">&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt;&lt; New file is created<\/span><br \/>-rw&#8212;&#8212;-. 1 oracle oinstall 5467 Jan 10 20:09 ewallet.p12<br \/>[oracle@localhost ~]$<\/p><\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\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 What is Transparent Data Encryption in oracle? In Simple words, Transparent Data Encryption (TDE) is a feature in Oracle that allows you &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>Transparent Data Encryption(TDE) - DBA Next Step<\/title>\n<meta name=\"description\" content=\"Secure your DB, TDE, Oracle Database security, secure db, how hacker can hack DB data, Why Security required for DB, Improve Data protection, Data at rest, encrypt datafile and encrypt tablespace\" \/>\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-encryptiontde\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Transparent Data Encryption(TDE)\" \/>\n<meta property=\"og:description\" content=\"Secure your DB, TDE, Oracle Database security, secure db, how hacker can hack DB data, Why Security required for DB, Improve Data protection, Data at rest, encrypt datafile and encrypt tablespace\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbanextstep.com\/index.php\/transparent-data-encryptiontde\/\" \/>\n<meta property=\"og:site_name\" content=\"DBA Next Step\" \/>\n<meta property=\"article:modified_time\" content=\"2023-01-11T08:04:10+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/dbanextstep.com\/wp-content\/uploads\/2023\/01\/Encrypted-Data-At-rest-v2-min.jpg\" \/>\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=\"16 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\":\"ImageObject\",\"@id\":\"https:\/\/dbanextstep.com\/index.php\/transparent-data-encryptiontde\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/dbanextstep.com\/wp-content\/uploads\/2023\/01\/Encrypted-Data-At-rest-v2-min.jpg\",\"contentUrl\":\"https:\/\/dbanextstep.com\/wp-content\/uploads\/2023\/01\/Encrypted-Data-At-rest-v2-min.jpg\",\"width\":1583,\"height\":716},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbanextstep.com\/index.php\/transparent-data-encryptiontde\/#webpage\",\"url\":\"https:\/\/dbanextstep.com\/index.php\/transparent-data-encryptiontde\/\",\"name\":\"Transparent Data Encryption(TDE) - DBA Next Step\",\"isPartOf\":{\"@id\":\"https:\/\/dbanextstep.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbanextstep.com\/index.php\/transparent-data-encryptiontde\/#primaryimage\"},\"datePublished\":\"2023-01-08T14:02:33+00:00\",\"dateModified\":\"2023-01-11T08:04:10+00:00\",\"description\":\"Secure your DB, TDE, Oracle Database security, secure db, how hacker can hack DB data, Why Security required for DB, Improve Data protection, Data at rest, encrypt datafile and encrypt tablespace\",\"breadcrumb\":{\"@id\":\"https:\/\/dbanextstep.com\/index.php\/transparent-data-encryptiontde\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbanextstep.com\/index.php\/transparent-data-encryptiontde\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbanextstep.com\/index.php\/transparent-data-encryptiontde\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbanextstep.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Transparent Data Encryption(TDE)\"}]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Transparent Data Encryption(TDE) - DBA Next Step","description":"Secure your DB, TDE, Oracle Database security, secure db, how hacker can hack DB data, Why Security required for DB, Improve Data protection, Data at rest, encrypt datafile and encrypt tablespace","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-encryptiontde\/","og_locale":"en_US","og_type":"article","og_title":"Transparent Data Encryption(TDE)","og_description":"Secure your DB, TDE, Oracle Database security, secure db, how hacker can hack DB data, Why Security required for DB, Improve Data protection, Data at rest, encrypt datafile and encrypt tablespace","og_url":"https:\/\/dbanextstep.com\/index.php\/transparent-data-encryptiontde\/","og_site_name":"DBA Next Step","article_modified_time":"2023-01-11T08:04:10+00:00","og_image":[{"url":"http:\/\/dbanextstep.com\/wp-content\/uploads\/2023\/01\/Encrypted-Data-At-rest-v2-min.jpg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"16 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":"ImageObject","@id":"https:\/\/dbanextstep.com\/index.php\/transparent-data-encryptiontde\/#primaryimage","inLanguage":"en-US","url":"https:\/\/dbanextstep.com\/wp-content\/uploads\/2023\/01\/Encrypted-Data-At-rest-v2-min.jpg","contentUrl":"https:\/\/dbanextstep.com\/wp-content\/uploads\/2023\/01\/Encrypted-Data-At-rest-v2-min.jpg","width":1583,"height":716},{"@type":"WebPage","@id":"https:\/\/dbanextstep.com\/index.php\/transparent-data-encryptiontde\/#webpage","url":"https:\/\/dbanextstep.com\/index.php\/transparent-data-encryptiontde\/","name":"Transparent Data Encryption(TDE) - DBA Next Step","isPartOf":{"@id":"https:\/\/dbanextstep.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbanextstep.com\/index.php\/transparent-data-encryptiontde\/#primaryimage"},"datePublished":"2023-01-08T14:02:33+00:00","dateModified":"2023-01-11T08:04:10+00:00","description":"Secure your DB, TDE, Oracle Database security, secure db, how hacker can hack DB data, Why Security required for DB, Improve Data protection, Data at rest, encrypt datafile and encrypt tablespace","breadcrumb":{"@id":"https:\/\/dbanextstep.com\/index.php\/transparent-data-encryptiontde\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbanextstep.com\/index.php\/transparent-data-encryptiontde\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/dbanextstep.com\/index.php\/transparent-data-encryptiontde\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbanextstep.com\/"},{"@type":"ListItem","position":2,"name":"Transparent Data Encryption(TDE)"}]}]}},"_links":{"self":[{"href":"https:\/\/dbanextstep.com\/index.php\/wp-json\/wp\/v2\/pages\/1662"}],"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=1662"}],"version-history":[{"count":284,"href":"https:\/\/dbanextstep.com\/index.php\/wp-json\/wp\/v2\/pages\/1662\/revisions"}],"predecessor-version":[{"id":2091,"href":"https:\/\/dbanextstep.com\/index.php\/wp-json\/wp\/v2\/pages\/1662\/revisions\/2091"}],"wp:attachment":[{"href":"https:\/\/dbanextstep.com\/index.php\/wp-json\/wp\/v2\/media?parent=1662"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}