{"id":21110,"date":"2022-12-16T17:29:34","date_gmt":"2022-12-16T16:29:34","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=21110"},"modified":"2022-12-16T17:29:34","modified_gmt":"2022-12-16T16:29:34","slug":"secure-your-sql-scripts-with-an-oracle-wallet","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/secure-your-sql-scripts-with-an-oracle-wallet\/","title":{"rendered":"Secure your SQL scripts with an Oracle wallet"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Introduction<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Security is a real topic today: encryption, increased password complexity, regular patching, auditing, \u2026 But it&#8217;s tough to identify each security issue that needs a fix. Among these security flaws you may discover, the use of clear credentials in scripts is one of them. A password should never be in a text file, for sure.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Oracle wallets<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">A simple way to avoid passwords in script files is to use wallets to store passwords. Wallet is basically a file where passwords are stored with a strong encryption. A wallet is itself protected by a password, so you may think that it&#8217;s useless if you need to provide the password of the wallet in the script, but autologin wallets are there to address this problem. Actually, you won&#8217;t need any password for using this wallet, and you will be able to remove credentials from your scripts.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Test environment<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">My client has an alias DBITST for my test database on a remote server:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><strong>su \u2013 oracle\nvi $ORACLE_HOME\/network\/admin\/tnsnames.ora\n<\/strong>\nDBITST =\n  (DESCRIPTION =\n    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.36.0.241)(PORT = 1521))\n    (CONNECT_DATA =\n      (SERVER = DEDICATED)\n      (SERVICE_NAME = pdb1.dbi-lab.ch)\n    )\n  )<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">I need a script and this script first authenticates with a login\/password:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><strong>vi script.sql\n<\/strong>\nconn salty\/visiblePWD@DBITST\nshow user;\nselect count(*) \"Number of objects\" from all_objects;\nexit;\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">When I run this script, it returns the number of objects:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><strong>sqlplus -s \/nolog @script<\/strong>\nUSER is \"SALTY\"\n\nNumber of objects\n-----------------\n\t    55943<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Creating the wallet<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">I will create a wallet directory on my client, then create the wallet and provide the password for this wallet:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><strong>mkdir \/home\/oracle\/wallet\n<\/strong>\n<strong>orapki wallet create -wallet \/home\/oracle\/wallet -auto_login_local\n<\/strong>\nOracle Secret Store Tool Release 19.0.0.0.0 - Production\nVersion 19.4.0.0.0\nCopyright (c) 2004, 2021, Oracle and\/or its affiliates. All rights reserved.\n\nEnter password: <strong>***************<\/strong>\nEnter password again: <strong>***************<\/strong><\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">I will now add credentials for my database, the alias, the login and the password:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><strong>mkstore -wrl \/home\/oracle\/wallet -createCredential DBITST salty visiblePWD<\/strong>\n\nEnter wallet password: <strong>***************<\/strong>\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">I need to configure the wallet location in the sqlnet.ora file of my client:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><strong>vi $ORACLE_HOME\/network\/admin\/sqlnet.ora\n<\/strong>WALLET_LOCATION=\n  (SOURCE=\n    (METHOD=FILE)\n    (METHOD_DATA=\n       (DIRECTORY=\/home\/oracle\/wallet)\n       ))\n\nSQLNET.WALLET_OVERRIDE = TRUE\nSSL_CLIENT_AUTHENTICATION = FALSE\nSSL_VERSION = 0<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Testing<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Now I will create a new version of my script, this time without login\/password in it:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><strong>cp script.sql nopwd_script.sql\nvi nopwd_script.sql\n<\/strong>\nconn \/@DBITST\nshow user;\nselect count(*) \"Number of objects\" from all_objects;\nexit;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Let&#8217;s test if it works:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><strong>sqlplus -s \/nolog @nopwd_script<\/strong>\nUSER is \"SALTY\"\n\nNumber of objects\n-----------------\n\t    55943<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Fine!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Using different credentials for the same database<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">If different credentials for the same database are needed, another alias for the same database must be created, as well as another credentials line:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><strong>vi $ORACLE_HOME\/network\/admin\/tnsnames.ora\n<\/strong>DBITST =\n  (DESCRIPTION =\n    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.36.0.241)(PORT = 1521))\n    (CONNECT_DATA =\n      (SERVER = DEDICATED)\n      (SERVICE_NAME = pdb1.dbi-lab.ch)\n    )\n  )\n\nDBITST2 =\n  (DESCRIPTION =\n    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.36.0.241)(PORT = 1521))\n    (CONNECT_DATA =\n      (SERVER = DEDICATED)\n      (SERVICE_NAME = pdb1.dbi-lab.ch)\n    )\n  )\n\n<strong>mkstore -wrl \/home\/oracle\/wallet -createCredential DBITST2 tlas DWPelbisiv\n<\/strong>\nEnter wallet password: <strong>**************<\/strong>\n\n<strong>cp nopwd_script.sql nopwd_script_2.sql\n\nvi nopwd_script.sql<\/strong>\n\nconn \/@DBITST\nshow user\nselect count(*) \"Number of objects\" from all_objects;\nexit;\n\n<strong>vi nopwd_script_2.sql\n<\/strong>\n\nconn \/@DBITST2\nshow user\nselect count(*) \"Number of tables\" from all_tables;\nexit;\n\n<strong>sqlplus -s \/nolog @nopwd_script\n<\/strong>\n\nUSER is \"SALTY\"\n\nNumber of objects\n-----------------\n\t    55943\n\n<strong>sqlplus -s \/nolog @nopwd_script_2\n<\/strong>\n\nUSER is \"YTLAS\"\n\nNumber of objects\n-----------------\n\t      117<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Managing the wallet<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Let\u2019s have a look at what\u2019s inside the wallet:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><strong>mkstore -wrl \/home\/oracle\/wallet -listCredential\n<\/strong>Oracle Secret Store Tool Release 19.0.0.0.0 - Production\nVersion 19.4.0.0.0\nCopyright (c) 2004, 2021, Oracle and\/or its affiliates. All rights reserved.\n\nEnter wallet password: <strong>**************<\/strong>\nList credential (index: connect_string username)\n2: DBITST2 ytlas\n1: DBITST salty\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Let\u2019s try to remove the entry for DBITST:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><strong>mkstore -wrl \/home\/oracle\/wallet -deleteCredential DBITST\n<\/strong>\nOracle Secret Store Tool Release 19.0.0.0.0 - Production\nVersion 19.4.0.0.0\nCopyright (c) 2004, 2021, Oracle and\/or its affiliates. All rights reserved.\n\nEnter wallet password: <strong>**************\n<\/strong>\n<strong>mkstore -wrl \/home\/oracle\/wallet -listCredential\n<\/strong>\nOracle Secret Store Tool Release 19.0.0.0.0 - Production\nVersion 19.4.0.0.0\nCopyright (c) 2004, 2021, Oracle and\/or its affiliates. All rights reserved.\n\nEnter wallet password: <strong>**************<\/strong>\nList credential (index: connect_string username)\n2: DBITST2 tlas\n\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Confirm that it doesn\u2019t work anymore for the first script:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><strong>sqlplus -s \/nolog @nopwd_script\n\n<\/strong>\nERROR:\nORA-01017: invalid username\/password; logon denied\n\nUSER is \"\"\nSP2-0640: Not connected\n\n<strong>sqlplus -s \/nolog @nopwd_script_2\n\n<\/strong>\nUSER is \"TLAS\"\n\nNumber of objects\n-----------------\n\t      117\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Using wallets is quite easy, the most difficult task being to identify these scripts on the clients.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>How to secure your SQL script and remove password using Oracle wallets<\/p>\n","protected":false},"author":45,"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":[2786],"class_list":["post-21110","post","type-post","status-publish","format-standard","category-oracle","tag-wallet"],"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>Secure your SQL scripts with an Oracle wallet - 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\/secure-your-sql-scripts-with-an-oracle-wallet\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Secure your SQL scripts with an Oracle wallet\" \/>\n<meta property=\"og:description\" content=\"How to secure your SQL script and remove password using Oracle wallets\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/secure-your-sql-scripts-with-an-oracle-wallet\/\" \/>\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=\"2022-12-16T16:29:34+00:00\" \/>\n<meta name=\"author\" content=\"J\u00e9r\u00f4me Dubar\" \/>\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=\"J\u00e9r\u00f4me Dubar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 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\\\/secure-your-sql-scripts-with-an-oracle-wallet\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/secure-your-sql-scripts-with-an-oracle-wallet\\\/\"},\"author\":{\"name\":\"J\u00e9r\u00f4me Dubar\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/00030f6073bcf4c5a2825967ab17b8ba\"},\"headline\":\"Secure your SQL scripts with an Oracle wallet\",\"datePublished\":\"2022-12-16T16:29:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/secure-your-sql-scripts-with-an-oracle-wallet\\\/\"},\"wordCount\":356,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"keywords\":[\"wallet\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/secure-your-sql-scripts-with-an-oracle-wallet\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/secure-your-sql-scripts-with-an-oracle-wallet\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/secure-your-sql-scripts-with-an-oracle-wallet\\\/\",\"name\":\"Secure your SQL scripts with an Oracle wallet - dbi services Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2022-12-16T16:29:34+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/secure-your-sql-scripts-with-an-oracle-wallet\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/secure-your-sql-scripts-with-an-oracle-wallet\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/secure-your-sql-scripts-with-an-oracle-wallet\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Secure your SQL scripts with an Oracle wallet\"}]},{\"@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\\\/00030f6073bcf4c5a2825967ab17b8ba\",\"name\":\"J\u00e9r\u00f4me Dubar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/JDU_web-min-scaled.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/JDU_web-min-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/08\\\/JDU_web-min-scaled.jpg\",\"caption\":\"J\u00e9r\u00f4me Dubar\"},\"description\":\"J\u00e9r\u00f4me Dubar has more than 25 years of IT experience, including 20 years specializing in Oracle Database technology. His expertise covers database architecture, licensing, high availability (RAC), disaster recovery (Data Guard, Dbvisit), backup (RMAN), performance tuning (AWR\\\/Statspack), and migration and consolidation projects, particularly with Oracle Database Appliance (ODA), Multitenant, OLVM, and Delphix. Prior to dbi services, he was Database Team Manager and main consultant at a Franco-Belgian IT services company for seven years, and has taught Oracle Database courses for years. He holds a Computer Engineering degree from Lille Sciences and Technologies University. His industry experience covers public sector, retail, industry, banking, health, and e-commerce.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/jerome-dubar\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Secure your SQL scripts with an Oracle wallet - 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\/secure-your-sql-scripts-with-an-oracle-wallet\/","og_locale":"en_US","og_type":"article","og_title":"Secure your SQL scripts with an Oracle wallet","og_description":"How to secure your SQL script and remove password using Oracle wallets","og_url":"https:\/\/www.dbi-services.com\/blog\/secure-your-sql-scripts-with-an-oracle-wallet\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2022-12-16T16:29:34+00:00","author":"J\u00e9r\u00f4me Dubar","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"J\u00e9r\u00f4me Dubar","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/secure-your-sql-scripts-with-an-oracle-wallet\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/secure-your-sql-scripts-with-an-oracle-wallet\/"},"author":{"name":"J\u00e9r\u00f4me Dubar","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/00030f6073bcf4c5a2825967ab17b8ba"},"headline":"Secure your SQL scripts with an Oracle wallet","datePublished":"2022-12-16T16:29:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/secure-your-sql-scripts-with-an-oracle-wallet\/"},"wordCount":356,"commentCount":4,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"keywords":["wallet"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/secure-your-sql-scripts-with-an-oracle-wallet\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/secure-your-sql-scripts-with-an-oracle-wallet\/","url":"https:\/\/www.dbi-services.com\/blog\/secure-your-sql-scripts-with-an-oracle-wallet\/","name":"Secure your SQL scripts with an Oracle wallet - dbi services Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2022-12-16T16:29:34+00:00","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/secure-your-sql-scripts-with-an-oracle-wallet\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/secure-your-sql-scripts-with-an-oracle-wallet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/secure-your-sql-scripts-with-an-oracle-wallet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Secure your SQL scripts with an Oracle wallet"}]},{"@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\/00030f6073bcf4c5a2825967ab17b8ba","name":"J\u00e9r\u00f4me Dubar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/JDU_web-min-scaled.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/JDU_web-min-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2022\/08\/JDU_web-min-scaled.jpg","caption":"J\u00e9r\u00f4me Dubar"},"description":"J\u00e9r\u00f4me Dubar has more than 25 years of IT experience, including 20 years specializing in Oracle Database technology. His expertise covers database architecture, licensing, high availability (RAC), disaster recovery (Data Guard, Dbvisit), backup (RMAN), performance tuning (AWR\/Statspack), and migration and consolidation projects, particularly with Oracle Database Appliance (ODA), Multitenant, OLVM, and Delphix. Prior to dbi services, he was Database Team Manager and main consultant at a Franco-Belgian IT services company for seven years, and has taught Oracle Database courses for years. He holds a Computer Engineering degree from Lille Sciences and Technologies University. His industry experience covers public sector, retail, industry, banking, health, and e-commerce.","url":"https:\/\/www.dbi-services.com\/blog\/author\/jerome-dubar\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/21110","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\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=21110"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/21110\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=21110"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=21110"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=21110"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}