{"id":32267,"date":"2024-04-02T16:41:13","date_gmt":"2024-04-02T14:41:13","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=32267"},"modified":"2024-04-02T16:41:13","modified_gmt":"2024-04-02T14:41:13","slug":"rekey-operation-on-oracle-database-configured-with-oracle-key-vault","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/rekey-operation-on-oracle-database-configured-with-oracle-key-vault\/","title":{"rendered":"REKEY operation on Oracle Database configured with Oracle Key Vault"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">by Alexandre Nestor<\/p>\n\n\n\n<h1 class=\"wp-block-heading\" id=\"h-introduction\">Introduction<\/h1>\n\n\n\n<p class=\"wp-block-paragraph\">When Oracle database is configured with Oracle Key Vault, all mater encryption key (MEK) are stored on Oracle Key Vault server. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Rekey is the operation of changing the MEK. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In the previous article <a href=\"https:\/\/www.dbi-services.com\/blog\/clone-oracle-database-configured-with-oracle-key-vault-okv\/\">Clone Oracle Database configured with Oracle Key Vault (OKV)<\/a> I cloned a database <code>CDB01<\/code> to <code>CDB02<\/code> configured with OKV. At the end of the clone process the cloned database <code>CDB02<\/code> use the same keys as the source database. In a production environment this is not an acceptable solution.  The cloned <code>CDB02<\/code> database (which can be a clone for test purpose), need to use it&#8217;s own keys. To achieve this goal we need to REKEY the <code>CDB02<\/code> database. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">First we are going to create a wallet for <code>CDB02<\/code>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The we are going execute the REKEY operation, to generate new master encryption keys.<br>At the end to make the full separation between <code>CDB01<\/code> and <code>CDB02<\/code> we remove the rights for <code>CDB02<\/code> to read the wallet of <code>CDB01<\/code>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-preparation\">Preparation<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">As explained in the previous post, the RESTFul api is installed in <code>\/home\/oracle\/okv<\/code><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">I use a script to set the RESTFul API environnement:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n&#x5B;oracle@db okv]$ cat \/home\/oracle\/okv\/set_okv_rest_env.sh\nexport OKV_RESTCLI_CONFIG=$HOME\/okv\/conf\nexport JAVA_HOME=\/usr\/java\/jdk-11.0.10\nexport OKV_HOME=$HOME\/okv\nexport PATH=$PATH:$OKV_HOME\/bin\n\n&#x5B;oracle@db okv]$ source \/home\/oracle\/okv\/set_okv_rest_env.sh\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">I use an SQL script to output the wallet status:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n&#x5B;oracle@db okv]$ cat $HOME\/tde.sql\nset pages 200\nset line 300\ncol WRL_PARAMETER format a50\ncol status forma a10\ncol pdb_name  format a20\nselect pdb_id, pdb_name, guid from dba_pdbs;\nselect * from v$encryption_wallet where con_id != 2;\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-the-initial-status-of-cdb02\">The initial status of CDB02<\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n&#x5B;oracle@db ~]$ . oraenv &lt;&lt;&lt; CDB02\n&#x5B;CDB02]&#x5B;oracle@db ~]$ sqlplus \/ as sysdba\n\nSQL&gt; show parameter wallet_root\n\nNAME\t\t\t\t     TYPE\t VALUE\n------------------------------------ ----------- ------------------------------\nwallet_root\t\t\t     string\t \/opt\/oracle\/admin\/CDB02\/wallet\n\nSQL&gt; show parameter tde_configuration\n\nNAME\t\t\t\t     TYPE\t VALUE\n------------------------------------ ----------- ------------------------------\ntde_configuration\t\t     string\t KEYSTORE_CONFIGURATION=OKV|FIL\n\nSQL&gt; @tde.sql\n\n    PDB_ID PDB_NAME\t\tGUID\n---------- -------------------- --------------------------------\n\t 3 PDB01\t\t0AE3AEC4EE5ACDB1E063A001A8ACB8BB\n\t 2 PDB$SEED\t\t0AE38C7FF01EC651E063A001A8AC821E\n\n\nWRL_TYPE  WRL_PARAMETER                       STATUS              WALLET_TYPE   WALLET_OR KEYSTORE FULLY_BAC CON_ID\n-------- ----------------------------------- -------------------- ------------- --------- -------- --------- -------\nFILE     \/opt\/oracle\/admin\/CDB02\/wallet\/tde\/ OPEN_NO_MASTER_KEY    AUTOLOGIN    SINGLE      NONE     UNDEFINED  1\nOKV                                          OPEN                  OKV          SINGLE      NONE     UNDEFINED  1\nFILE                                         OPEN_NO_MASTER_KEY    AUTOLOGIN    SINGLE      UNITED   UNDEFINED  3\nOKV                                          OPEN_UNKNONW_         OKV          SINGLE      UNITED   UNDEFINED  3\n\nSQL&gt; exit; \n\n&#x5B;CDB02]&#x5B;oracle@db ~]$ \/opt\/oracle\/admin\/CDB02\/wallet\/okv\/bin\/okvutil list\nEnter Oracle Key Vault endpoint password: endpoint_password\nUnique ID                               Type            Identifier\n600D0743-01D9-4F2F-BF6F-C9E8AC74FF2A\tSymmetric Key\tTDE Master Encryption Key: TAG CDB:CDB01 MEK first\n6A752388-F93D-4F14-BF35-39E674CAAFED\tSymmetric Key\tTDE Master Encryption Key: TAG REKEY CDB01\nAB294686-1FC4-4FE8-BFAD-F56BAD0A124B\tSymmetric Key\tTDE Master Encryption Key: TAG REKEY CDB01\nBB0CC77A-10AD-4F55-BF0A-9F5A4C7F98C1\tSymmetric Key\tTDE Master Encryption Key: TAG CDB:DBTDEOKV:PDB1 MEK first\n\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-create-a-wallet-for-cdb02\">Create a wallet for CDB02<\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n&#x5B;CDB02]&#x5B;oracle@db json]$ $OKV_HOME\/bin\/okv manage-access wallet create --generate-json-input &gt; create_db_wallet_CDB02.json\n&#x5B;CDB02]&#x5B;oracle@db json]$ cat create_db_wallet_CDB02.json\n{\n  &quot;service&quot; : {\n    &quot;category&quot; : &quot;manage-access&quot;,\n    &quot;resource&quot; : &quot;wallet&quot;,\n    &quot;action&quot; : &quot;create&quot;,\n    &quot;options&quot; : {\n      &quot;wallet&quot; : &quot;ORA_CLONES&quot;,\n      &quot;type&quot; : &quot;GENERAL&quot;,\n      &quot;description&quot; : &quot;Wallet for Oracle Clones&quot;\n    }\n  }\n}\n\n&#x5B;CDB02]&#x5B;oracle@db json]$ $OKV_HOME\/bin\/okv manage-access wallet create --from-json create_db_wallet_CDB02.json\n{\n  &quot;result&quot; : &quot;Success&quot;\n}\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">Set the default wallet for CDB02<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n&#x5B;CDB02]&#x5B;oracle@db json]$ okv manage-access wallet set-default --generate-json-input &gt; set_default_wallet_CDB02.json\n\n\n&#x5B;CDB02]&#x5B;oracle@db json]$ cat set_default_wallet_CDB02.json\n{\n  &quot;service&quot; : {\n    &quot;category&quot; : &quot;manage-access&quot;,\n    &quot;resource&quot; : &quot;wallet&quot;,\n    &quot;action&quot; : &quot;set-default&quot;,\n    &quot;options&quot; : {\n      &quot;wallet&quot; : &quot;ORA_CLONES&quot;,\n      &quot;endpoint&quot; : &quot;DB_CDB02&quot;,\n      &quot;unique&quot; : &quot;FALSE&quot;\n    }\n  }\n}\n\n&#x5B;CDB02]&#x5B;oracle@db json]$ okv manage-access wallet set-default --from-json set_default_wallet_CDB02.json\n{\n  &quot;result&quot; : &quot;Success&quot;\n}\n\n# test \n&#x5B;CDB02]&#x5B;oracle@db json]$ $OKV_HOME\/bin\/okv manage-access wallet get-default --endpoint DB_CDB02\n{\n  &quot;result&quot; : &quot;Success&quot;,\n  &quot;value&quot; : {\n    &quot;defaultWallet&quot; : &quot;ORA_CLONES&quot;\n  }\n}\n\n# list wallets access for endpoint DB_CDB02\n&#x5B;CDB02]&#x5B;oracle@db json]$ $OKV_HOME\/bin\/okv manage-access wallet list-endpoint-wallets --endpoint DB_CDB02\n{\n  &quot;result&quot; : &quot;Success&quot;,\n  &quot;value&quot; : {\n    &quot;wallets&quot; : &#x5B; &quot;ORA_CLONES&quot;, &quot;ORA_DB&quot; ]\n  }\n}\n\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"h-rekey-operation\">REKEY operation <\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n&#x5B;CDB02]&#x5B;oracle@db json]$ sqlplus \/ as sysdba \n\n-- list all keys for CDB02\nSQL&gt; set line 200\nSQL&gt; col key_id format a40;\nSQL&gt; select KEY_ID, KEYSTORE_TYPE,CREATION_TIME from V$ENCRYPTION_KEYS;\n\nKEY_ID                                   KEYSTORE_TYPE\t   CREATION_TIME\n---------------------------------------- ----------------- ----------------------------\n066477563C41354F9ABFFD71C439728D90\t OKV\t\t   12-MAR-24 11.38.29.789446 AM +00:00\n06389A1CCF31E64F17BFC1101D9700F83E\t OKV\t\t   12-MAR-24 11.53.46.361951 AM +00:00\n064A92E70C7DBB4FBCBFDE46A9226CFB0A\t OKV\t\t   12-MAR-24 11.53.45.932774 AM +00:00\n06FED2B8DA29444F57BF11BB545ED7E60D\t OKV\t\t   12-MAR-24 11.20.59.949238 AM +00:00 \n\nSQL&gt; ADMINISTER KEY MANAGEMENT SET ENCRYPTION KEY FORCE KEYSTORE IDENTIFIED BY &quot;endpoint_password&quot; container=all;\n\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">Remove access from <code>CDB01<\/code> wallet:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\n&#x5B;CDB02]&#x5B;oracle@db json]$ $OKV_HOME\/bin\/okv manage-access wallet remove-access --generate-json-input &gt; remove_access_walet_CDB02.json\n\n&#x5B;CDB02]&#x5B;oracle@db json]$ cat remove_access_walet_CDB02.json\n{\n  &quot;service&quot; : {\n    &quot;category&quot; : &quot;manage-access&quot;,\n    &quot;resource&quot; : &quot;wallet&quot;,\n    &quot;action&quot; : &quot;remove-access&quot;,\n    &quot;options&quot; : {\n      &quot;wallet&quot; : &quot;ORA_DB&quot;,\n      &quot;endpoint&quot; : &quot;DB_CDB02&quot;\n    }\n  }\n}\n\n&#x5B;CDB02]&#x5B;oracle@db json]$ $OKV_HOME\/bin\/okv manage-access wallet remove-access --from-json remove_access_walet_CDB02.json\n{\n  &quot;result&quot; : &quot;Success&quot;\n}\n\n&#x5B;CDB02]&#x5B;oracle@db json]$ \/opt\/oracle\/admin\/CDB02\/wallet\/okv\/bin\/okvutil list\nEnter Oracle Key Vault endpoint password:\nUnique ID                               Type            Identifier\n1B382343-A786-4F26-BFF9-35A8329A327C\tSymmetric Key\tTDE Master Encryption Key: MKID 0612F89A18C7984F27BF571A0420C58025\n52B62409-6E8D-4F6F-BF08-F7DD73EC1938\tSymmetric Key\tTDE Master Encryption Key: MKID 06A9FD621A85A74F46BFD88BEB6082B9EB\n2DE4025E-CF35-454D-9F60-33640DAAC067\tTemplate\tDefault template for DB_CDB02\n\n-- restart CDB02 to test if the database open withouth any issue\nSQL&gt; startup force\n\nSQL&gt; @$HOME\/tde.sql\n\n    PDB_ID PDB_NAME\t\tGUID\n---------- -------------------- --------------------------------\n\t 3 PDB01\t\t0AE3AEC4EE5ACDB1E063A001A8ACB8BB\n\t 2 PDB$SEED\t\t0AE38C7FF01EC651E063A001A8AC821E\n\n\nWRL_TYPE    WRL_PARAMETER                       STATUS             WALLET_TYPE WALLET_OR KEYSTORE FULLY_BAC     CON_ID\n----------- ----------------------------------- ------------------ ----------- --------- -------- --------- ----------\nFILE        \/opt\/oracle\/admin\/CDB02\/wallet\/tde\/ OPEN_NO_MASTER_KEY AUTOLOGIN   SINGLE      NONE       UNDEFINED          1\nOKV                                             OPEN               OKV         SINGLE      NONE       UNDEFINED          1\nFILE                                            OPEN_NO_MASTER_KEY AUTOLOGIN   SINGLE      UNITED     UNDEFINED          3\nOKV                                             OPEN               OKV         SINGLE      NONE       UNDEFINED          3\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">Database <code>CDB02<\/code> open correctly. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">List the accessible keys for <code>CDB02<\/code>:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n&#x5B;CDB02]&#x5B;oracle@db json]$ \/opt\/oracle\/admin\/CDB02\/wallet\/okv\/bin\/okvutil list\nEnter Oracle Key Vault endpoint password:\nUnique ID                               Type            Identifier\n1B382343-A786-4F26-BFF9-35A8329A327C\tSymmetric Key\tTDE Master Encryption Key: MKID 0612F89A18C7984F27BF571A0420C58025\n2DE4025E-CF35-454D-9F60-33640DAAC067\tTemplate\tDefault template for DB_CDB02\n\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">List the wallets accessible for <code>CDB02<\/code>:<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: bash; title: ; notranslate\" title=\"\">\n&#x5B;CDB02]&#x5B;oracle@db json]$ $OKV_HOME\/bin\/okv manage-access wallet list-endpoint-wallets --endpoint DB_CDB02\n{\n  &quot;result&quot; : &quot;Success&quot;,\n  &quot;value&quot; : {\n    &quot;wallets&quot; : &#x5B; &quot;ORA_CLONES&quot; ]\n  }\n}\n<\/pre><\/div>\n\n\n<p class=\"wp-block-paragraph\">CDB02 has no more access to the CD01 wallet. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-conclusion\">Conclusion<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">If the database is not configured with OKV, after a REKEY operation the wallet file, stored on local disk, must be saved. When the database is configured with OKV when a REKEY operation is issued we have to do &#8230;. nothing. The keys are automatically stored in OKV database without any intervention. Just only one remark. The endpoint, in our example <code>DB_CDB02<\/code>, need to have a default wallet configured. Otherwise the keys will not belongs to any wallet. That doesn&#8217;t mean that the CDB02 database cannot access them, but having keys outside wallets in OKV, increase the maintenance operations. <\/p>\n","protected":false},"excerpt":{"rendered":"<p>REKEY Oracle database configured with Oracle Key Vault<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[59],"tags":[],"class_list":["post-32267","post","type-post","status-publish","format-standard","category-oracle"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.9) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>REKEY operation on Oracle Database configured with Oracle Key Vault - dbi services Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/rekey-operation-on-oracle-database-configured-with-oracle-key-vault\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"REKEY operation on Oracle Database configured with Oracle Key Vault\" \/>\n<meta property=\"og:description\" content=\"REKEY Oracle database configured with Oracle Key Vault\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/rekey-operation-on-oracle-database-configured-with-oracle-key-vault\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-04-02T14:41:13+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/rekey-operation-on-oracle-database-configured-with-oracle-key-vault\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/rekey-operation-on-oracle-database-configured-with-oracle-key-vault\\\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/bf7c7eb0bec165183207237c9d0ee1d5\"},\"headline\":\"REKEY operation on Oracle Database configured with Oracle Key Vault\",\"datePublished\":\"2024-04-02T14:41:13+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/rekey-operation-on-oracle-database-configured-with-oracle-key-vault\\\/\"},\"wordCount\":339,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/rekey-operation-on-oracle-database-configured-with-oracle-key-vault\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/rekey-operation-on-oracle-database-configured-with-oracle-key-vault\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/rekey-operation-on-oracle-database-configured-with-oracle-key-vault\\\/\",\"name\":\"REKEY operation on Oracle Database configured with Oracle Key Vault - dbi services Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2024-04-02T14:41:13+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/rekey-operation-on-oracle-database-configured-with-oracle-key-vault\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/rekey-operation-on-oracle-database-configured-with-oracle-key-vault\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/rekey-operation-on-oracle-database-configured-with-oracle-key-vault\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"REKEY operation on Oracle Database configured with Oracle Key Vault\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\",\"name\":\"dbi services\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/bf7c7eb0bec165183207237c9d0ee1d5\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/oracle-square.png\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/oracle-square.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/oracle-square.png\",\"caption\":\"Oracle Team\"},\"description\":\"Posts published under the Oracle Team account are collective contributions by the dbi services Oracle consultants. The practice covers the full Oracle Database lifecycle: architecture, migration and upgrade, high availability with RAC and Data Guard, backup and recovery, performance tuning, and engineered systems such as Oracle Database Appliance and Exadata. The team holds Oracle certifications up to Certified Master level and operates customer platforms under service level agreements.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/oracle-team\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"REKEY operation on Oracle Database configured with Oracle Key Vault - dbi services Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/rekey-operation-on-oracle-database-configured-with-oracle-key-vault\/","og_locale":"en_US","og_type":"article","og_title":"REKEY operation on Oracle Database configured with Oracle Key Vault","og_description":"REKEY Oracle database configured with Oracle Key Vault","og_url":"https:\/\/www.dbi-services.com\/blog\/rekey-operation-on-oracle-database-configured-with-oracle-key-vault\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2024-04-02T14:41:13+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/rekey-operation-on-oracle-database-configured-with-oracle-key-vault\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/rekey-operation-on-oracle-database-configured-with-oracle-key-vault\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bf7c7eb0bec165183207237c9d0ee1d5"},"headline":"REKEY operation on Oracle Database configured with Oracle Key Vault","datePublished":"2024-04-02T14:41:13+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/rekey-operation-on-oracle-database-configured-with-oracle-key-vault\/"},"wordCount":339,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/rekey-operation-on-oracle-database-configured-with-oracle-key-vault\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/rekey-operation-on-oracle-database-configured-with-oracle-key-vault\/","url":"https:\/\/www.dbi-services.com\/blog\/rekey-operation-on-oracle-database-configured-with-oracle-key-vault\/","name":"REKEY operation on Oracle Database configured with Oracle Key Vault - dbi services Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2024-04-02T14:41:13+00:00","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/rekey-operation-on-oracle-database-configured-with-oracle-key-vault\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/rekey-operation-on-oracle-database-configured-with-oracle-key-vault\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/rekey-operation-on-oracle-database-configured-with-oracle-key-vault\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"REKEY operation on Oracle Database configured with Oracle Key Vault"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/#organization","name":"dbi services","url":"https:\/\/www.dbi-services.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bf7c7eb0bec165183207237c9d0ee1d5","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/12\/oracle-square.png","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/12\/oracle-square.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/12\/oracle-square.png","caption":"Oracle Team"},"description":"Posts published under the Oracle Team account are collective contributions by the dbi services Oracle consultants. The practice covers the full Oracle Database lifecycle: architecture, migration and upgrade, high availability with RAC and Data Guard, backup and recovery, performance tuning, and engineered systems such as Oracle Database Appliance and Exadata. The team holds Oracle certifications up to Certified Master level and operates customer platforms under service level agreements.","url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/32267","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=32267"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/32267\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=32267"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=32267"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=32267"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}