{"id":9843,"date":"2017-03-10T10:37:01","date_gmt":"2017-03-10T09:37:01","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/12cr2-tns_admin-in-env-ora\/"},"modified":"2017-03-10T10:37:01","modified_gmt":"2017-03-10T09:37:01","slug":"12cr2-tns_admin-in-env-ora","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/12cr2-tns_admin-in-env-ora\/","title":{"rendered":"12cR2: TNS_ADMIN in env.ora"},"content":{"rendered":"<h2>By Franck Pachot<\/h2>\n<p>.<br \/>\nThe network files (sqlnet.ora, tnsnames.ora, lsnrctl.ora) are read by default from ORACLE_HOME\/network\/admin but you may have several Oracle installations, and want only one place for those files. Then you can use TNS_ADMIN environment variable. But are you sure that it is always set when starting the database? the listener? the client? They must be consistent (see <a href=\"https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-plsql-new-feature-tnsping-from-the-database\/\">https:\/\/www.dbi-services.com\/blog\/oracle-12cr2-plsql-new-feature-tnsping-from-the-database\/<\/a>). Then what we do for the cases where TNS_ADMIN is not set: define symbolic links from the ORACLE_HOME to the common location. It would be better to just change the default location and this is what can be done in 12.2 with env.ora<\/p>\n<p>By default, the $ORACLE_HOME\/env.ora is empty. There are only comments.<\/p>\n<p>If you run any oracle 12.2 client the $ORACLE_HOME\/ora.env will be read. If nothing is set here, then the default $ORACLE_HOME\/network\/admin location is read.<\/p>\n<h3>$ORACLE_HOME\/network\/admin<\/h3>\n<pre><code>[oracle@VM104 tmp]$ strace -e trace=file tnsping localhost 2&gt;&amp;1 | grep -E \"[.]ora\"\nlstat(\"\/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/env.ora\", {st_mode=S_IFREG|0644, st_size=852, ...}) = 0\nopen(\"\/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/env.ora\", O_RDONLY) = 3\naccess(\"\/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/network\/admin\/sqlnet.ora\", F_OK) = 0\nopen(\"\/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/network\/admin\/sqlnet.ora\", O_RDONLY) = 3\naccess(\"\/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/network\/admin\/sqlnet.ora\", F_OK) = 0\nopen(\"\/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/network\/admin\/sqlnet.ora\", O_RDONLY) = 3\naccess(\"\/home\/oracle\/.tnsnames.ora\", F_OK) = -1 ENOENT (No such file or directory)\naccess(\"\/etc\/tnsnames.ora\", F_OK)       = -1 ENOENT (No such file or directory)\naccess(\"\/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/network\/admin\/tnsnames.ora\", F_OK) = -1 ENOENT (No such file or directory)\n<\/code><\/pre>\n<p>Here I have a sqlnet.ora but no tnsnames.ora so the next locations that are searched are ~\/.tnsnames.ora and \/etc\/tnsnames.ora<\/p>\n<h3>TNS_ADMIN environment variable<\/h3>\n<p>If I set the environment variable TNS_ADMIN to \/tmp then <\/p>\n<pre><code>[oracle@VM104 tmp]$ TNS_ADMIN=\/tmp strace -e trace=file tnsping localhost 2&gt;&amp;1 | grep -E \"[.]ora\"\nlstat(\"\/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/env.ora\", {st_mode=S_IFREG|0644, st_size=852, ...}) = 0\nopen(\"\/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/env.ora\", O_RDONLY) = 3\naccess(\"\/tmp\/sqlnet.ora\", F_OK)         = 0\nopen(\"\/tmp\/sqlnet.ora\", O_RDONLY)       = 3\naccess(\"\/tmp\/sqlnet.ora\", F_OK)         = 0\nopen(\"\/tmp\/sqlnet.ora\", O_RDONLY)       = 3\naccess(\"\/home\/oracle\/.tnsnames.ora\", F_OK) = -1 ENOENT (No such file or directory)\naccess(\"\/tmp\/tnsnames.ora\", F_OK)       = -1 ENOENT (No such file or directory)\naccess(\"\/etc\/tnsnames.ora\", F_OK)       = -1 ENOENT (No such file or directory)\naccess(\"\/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/network\/admin\/tnsnames.ora\", F_OK) = -1 ENOENT (No such file or directory)\n<\/code><\/pre>\n<p>The directory defined in TNS_ADMIN is searched first<\/p>\n<h3>TNS_ADMIN in env.ora<\/h3>\n<p>I have added the TNS_ADMIN=\/tmp in the env.ora:<\/p>\n<pre><code>[oracle@VM104 tmp]$ tail -3 $ORACLE_HOME\/env.ora\n#   Default: $ORACLE_HOME\/network\/admin\n#\nTNS_ADMIN=\/tmp\n<\/code><\/pre>\n<p>When I run tnsping without setting any environment variable, I have exactly the same as before:<\/p>\n<pre><code>\n[oracle@VM104 tmp]$ strace -e trace=file tnsping localhost 2&gt;&amp;1 | grep -E \"[.]ora\"\nlstat(\"\/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/env.ora\", {st_mode=S_IFREG|0644, st_size=867, ...}) = 0\nopen(\"\/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/env.ora\", O_RDONLY) = 3\naccess(\"\/tmp\/sqlnet.ora\", F_OK)         = 0\nopen(\"\/tmp\/sqlnet.ora\", O_RDONLY)       = 3\naccess(\"\/tmp\/sqlnet.ora\", F_OK)         = 0\nopen(\"\/tmp\/sqlnet.ora\", O_RDONLY)       = 3\naccess(\"\/home\/oracle\/.tnsnames.ora\", F_OK) = -1 ENOENT (No such file or directory)\naccess(\"\/tmp\/tnsnames.ora\", F_OK)       = -1 ENOENT (No such file or directory)\naccess(\"\/etc\/tnsnames.ora\", F_OK)       = -1 ENOENT (No such file or directory)\naccess(\"\/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/network\/admin\/tnsnames.ora\", F_OK) = -1 ENOENT (No such file or directory)\n<\/code><\/pre>\n<p>The good thing about it is that the setting is centralized for all binaries running from this ORACLE_HOME set.<\/p>\n<h3>Both<\/h3>\n<p>However the setting in environment has priority over the env.ora one:<\/p>\n<pre><code>[oracle@VM104 tmp]$ TNS_ADMIN=\/var\/tmp strace -e trace=file tnsping localhost 2&gt;&amp;1 | grep -E \"[.]ora\"\nlstat(\"\/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/env.ora\", {st_mode=S_IFREG|0644, st_size=867, ...}) = 0\nopen(\"\/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/env.ora\", O_RDONLY) = 3\naccess(\"\/var\/tmp\/sqlnet.ora\", F_OK)     = 0\nopen(\"\/var\/tmp\/sqlnet.ora\", O_RDONLY)   = 3\naccess(\"\/var\/tmp\/sqlnet.ora\", F_OK)     = 0\nopen(\"\/var\/tmp\/sqlnet.ora\", O_RDONLY)   = 3\naccess(\"\/home\/oracle\/.tnsnames.ora\", F_OK) = -1 ENOENT (No such file or directory)\naccess(\"\/var\/tmp\/tnsnames.ora\", F_OK)   = -1 ENOENT (No such file or directory)\naccess(\"\/etc\/tnsnames.ora\", F_OK)       = -1 ENOENT (No such file or directory)\naccess(\"\/u01\/app\/oracle\/product\/12.2.0\/dbhome_1\/network\/admin\/tnsnames.ora\", F_OK) = -1 ENOENT (No such file or directory)<\/code><\/pre>\n<p>So the recommandation if you want to use the env.ora is not to set TNS_ADMIN, especially when starting the listener or the database, to be sure that the same environment is always used. Final note: I&#8217;ve not seen it in the documentation so if you rely on it for critical environment, better to validate with support.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>By Franck Pachot . The network files (sqlnet.ora, tnsnames.ora, lsnrctl.ora) are read by default from ORACLE_HOME\/network\/admin but you may have several Oracle installations, and want only one place for those files. Then you can use TNS_ADMIN environment variable. But are you sure that it is always set when starting the database? the listener? the client?&hellip;&nbsp;<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","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":[4133],"tags":[209,1025],"class_list":["post-9843","post","type-post","status-publish","format-standard","category-database","tag-oracle-12c","tag-oracle-12cr2"],"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>12cR2: TNS_ADMIN in env.ora - 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\/12cr2-tns_admin-in-env-ora\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"12cR2: TNS_ADMIN in env.ora\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . The network files (sqlnet.ora, tnsnames.ora, lsnrctl.ora) are read by default from ORACLE_HOME\/network\/admin but you may have several Oracle installations, and want only one place for those files. Then you can use TNS_ADMIN environment variable. But are you sure that it is always set when starting the database? the listener? the client?&hellip;&nbsp;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/12cr2-tns_admin-in-env-ora\/\" \/>\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=\"2017-03-10T09:37:01+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=\"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\\\/12cr2-tns_admin-in-env-ora\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/12cr2-tns_admin-in-env-ora\\\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/bf7c7eb0bec165183207237c9d0ee1d5\"},\"headline\":\"12cR2: TNS_ADMIN in env.ora\",\"datePublished\":\"2017-03-10T09:37:01+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/12cr2-tns_admin-in-env-ora\\\/\"},\"wordCount\":343,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"keywords\":[\"Oracle 12c\",\"Oracle 12cR2\"],\"articleSection\":[\"Database\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/12cr2-tns_admin-in-env-ora\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/12cr2-tns_admin-in-env-ora\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/12cr2-tns_admin-in-env-ora\\\/\",\"name\":\"12cR2: TNS_ADMIN in env.ora - dbi services Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2017-03-10T09:37:01+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/12cr2-tns_admin-in-env-ora\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/12cr2-tns_admin-in-env-ora\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/12cr2-tns_admin-in-env-ora\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"12cR2: TNS_ADMIN in env.ora\"}]},{\"@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":"12cR2: TNS_ADMIN in env.ora - 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\/12cr2-tns_admin-in-env-ora\/","og_locale":"en_US","og_type":"article","og_title":"12cR2: TNS_ADMIN in env.ora","og_description":"By Franck Pachot . The network files (sqlnet.ora, tnsnames.ora, lsnrctl.ora) are read by default from ORACLE_HOME\/network\/admin but you may have several Oracle installations, and want only one place for those files. Then you can use TNS_ADMIN environment variable. But are you sure that it is always set when starting the database? the listener? the client?&hellip;&nbsp;","og_url":"https:\/\/www.dbi-services.com\/blog\/12cr2-tns_admin-in-env-ora\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2017-03-10T09:37:01+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":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/12cr2-tns_admin-in-env-ora\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/12cr2-tns_admin-in-env-ora\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/bf7c7eb0bec165183207237c9d0ee1d5"},"headline":"12cR2: TNS_ADMIN in env.ora","datePublished":"2017-03-10T09:37:01+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/12cr2-tns_admin-in-env-ora\/"},"wordCount":343,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"keywords":["Oracle 12c","Oracle 12cR2"],"articleSection":["Database"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/12cr2-tns_admin-in-env-ora\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/12cr2-tns_admin-in-env-ora\/","url":"https:\/\/www.dbi-services.com\/blog\/12cr2-tns_admin-in-env-ora\/","name":"12cR2: TNS_ADMIN in env.ora - dbi services Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2017-03-10T09:37:01+00:00","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/12cr2-tns_admin-in-env-ora\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/12cr2-tns_admin-in-env-ora\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/12cr2-tns_admin-in-env-ora\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"12cR2: TNS_ADMIN in env.ora"}]},{"@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\/9843","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=9843"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/9843\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=9843"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=9843"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=9843"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}