{"id":895,"date":"2021-08-29T18:21:21","date_gmt":"2021-08-29T21:21:21","guid":{"rendered":"https:\/\/www.fernandosimon.com\/blog\/?p=895"},"modified":"2021-08-29T18:21:21","modified_gmt":"2021-08-29T21:21:21","slug":"21c-rooh","status":"publish","type":"post","link":"https:\/\/www.fernandosimon.com\/blog\/21c-rooh\/","title":{"rendered":"21c, ROOH"},"content":{"rendered":"<p style=\"text-align: justify;\">ROOH \u2013 Read-Only Oracle Home \u2013 is the new way to work with Oracle 21c where the Oracle Home folder is read-only. Now, (besides the previous version like 19c) it <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/21\/nfcon\/read-only-oracle-home-default-366970591.html\" target=\"_blank\" rel=\"noopener\">is the default<\/a> for 21c, and this means that some activities need to be changed from now.<\/p>\n<p style=\"text-align: justify;\">Recently I was playing with Data Guard and when I was creating it I passed over two situations: tnsnames and password files. Where they suppose to be placed? Bellow, I will show some examples, but I recommend you to <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/21\/ladbi\/configuring-read-only-oracle-homes.html#GUID-906DA159-AC83-4ACC-A8A6-5B4A39EB72E1\" target=\"_blank\" rel=\"noopener\">read the official documentation<\/a> for ROOH to understand all the details and <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/21\/ladbi\/file-path-directory-changes-read-only-oracle-home.html#GUID-695D5458-A4AF-4F2A-AE4B-FB1062CF6014\" target=\"_blank\" rel=\"noopener\">file paths<\/a>. But basically, you don\u2019t need to touch anymore the Oracle Home to edit files.<\/p>\n<p><a href=\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2021\/08\/Image-Move.png\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-896 size-medium\" src=\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2021\/08\/Image-Move-300x243.png\" alt=\"\" width=\"300\" height=\"243\" srcset=\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2021\/08\/Image-Move-300x243.png 300w, https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2021\/08\/Image-Move-768x621.png 768w, https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2021\/08\/Image-Move-624x505.png 624w, https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2021\/08\/Image-Move.png 999w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p style=\"text-align: justify;\"><!--more Click here to read more...--><\/p>\n<h1>TNSNAMES<\/h1>\n<p>So, I needed to add the new entries for tnsnames but below you can see that I edited the tnsnames.ora at the same way that we made in the past (until 19c), inside Oracle Home:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"raw\">[oracle@orcl21s ~]$ echo $ORACLE_HOME\r\n\/u01\/app\/oracle\/product\/21.0.0.0\/dbhome_1\r\n[oracle@orcl21s ~]$\r\n[oracle@orcl21s ~]$ ls -l $ORACLE_HOME\/network\/admin\r\ntotal 8\r\ndrwxr-xr-x 2 oracle oinstall 4096 Jul 27 23:00 samples\r\n-rw-r--r-- 1 oracle oinstall 1624 Feb 18  2020 shrept.lst\r\n[oracle@orcl21s ~]$\r\n[oracle@orcl21s ~]$ echo $TNS_ADMIN\r\n\r\n[oracle@orcl21s ~]$\r\n[oracle@orcl21s ~]$ vi $ORACLE_HOME\/network\/admin\/tnsnames.ora\r\n[oracle@orcl21s ~]$\r\n[oracle@orcl21s ~]$ cat $ORACLE_HOME\/network\/admin\/tnsnames.ora\r\nORA21DG =\r\n  (DESCRIPTION =\r\n    (ADDRESS = (PROTOCOL = TCP)(HOST = orcl21p-scan)(PORT = 1521))\r\n    (CONNECT_DATA =\r\n      (SERVER = DEDICATED)\r\n      (SERVICE_NAME = ora21dg)\r\n    )\r\n  )\r\n\r\n[oracle@orcl21s ~]$<\/pre>\n<p style=\"text-align: justify;\">And if I try to do tnsping, you can see that not works because can\u2019t find the entry:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"raw\">[oracle@orcl21s ~]$ tnsping ORA21DG\r\n\r\nTNS Ping Utility for Linux: Version 21.0.0.0.0 - Production on 23-AUG-2021 22:55:53\r\n\r\nCopyright (c) 1997, 2021, Oracle.  All rights reserved.\r\n\r\nUsed parameter files:\r\n\r\nTNS-03505: Failed to resolve name\r\n[oracle@orcl21s ~]$<\/pre>\n<p style=\"text-align: justify;\">Following the official doc, and editing the correct file placed inside of ORACLE_BASE_HOME (ORACLE_BASE\/homes\/HOME_NAME or \/u01\/app\/oracle\/homes\/OraDB21Home1) at <strong>ORACLE_BASE_HOME\/network\/admin<\/strong>, you can see that now it is working:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"raw\">[oracle@orcl21s ~]$ vi \/u01\/app\/oracle\/homes\/OraDB21Home1\/network\/admin\/tnsnames.ora\r\n[oracle@orcl21s ~]$\r\n[oracle@orcl21s ~]$ cat \/u01\/app\/oracle\/homes\/OraDB21Home1\/network\/admin\/tnsnames.ora\r\n# tnsnames.ora Network Configuration File: \/u01\/app\/oracle\/homes\/OraDB21Home1\/network\/admin\/tnsnames.ora\r\n# Generated by Oracle configuration tools.\r\n\r\nORA21DG =\r\n  (DESCRIPTION =\r\n    (ADDRESS = (PROTOCOL = TCP)(HOST = orcl21p-scan)(PORT = 1521))\r\n    (CONNECT_DATA =\r\n      (SERVER = DEDICATED)\r\n      (SERVICE_NAME = ora21dg)\r\n    )\r\n  )\r\n\r\n[oracle@orcl21s ~]$\r\n[oracle@orcl21s ~]$ tnsping ORA21DG\r\n\r\nTNS Ping Utility for Linux: Version 21.0.0.0.0 - Production on 23-AUG-2021 22:58:24\r\n\r\nCopyright (c) 1997, 2021, Oracle.  All rights reserved.\r\n\r\nUsed parameter files:\r\n\r\n\r\nUsed TNSNAMES adapter to resolve the alias\r\nAttempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl21p-scan)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ora21dg)))\r\nOK (10 msec)\r\n[oracle@orcl21s ~]$<\/pre>\n<p style=\"text-align: justify;\">So, even if is possible to create tnsnames.ora file inside Oracle Home, it will not work (even with TNS_ADMIN) not set. By default, Oracle will search the file in the new correct path.<\/p>\n<h1 style=\"text-align: justify;\">Password File<\/h1>\n<p style=\"text-align: justify;\">Another file that is common to edit (and create manually) is the Oracle password file, even more, when creating the Data Guard. When you create the database (by dbca) it will be put in the correct place (at AMS or local file system \u2013 depending on what is your environment and what you are using), but while you are creating the Data Guard you need to put it at the correct place.<\/p>\n<p style=\"text-align: justify;\">So, during the creation of the database I copied the password file from production and put it in the $ORACLE_HOME\/dbs folder:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"raw\">[oracle@orcl21s ~]$ echo $ORACLE_HOME\r\n\/u01\/app\/oracle\/product\/21.0.0.0\/dbhome_1\r\n[oracle@orcl21s ~]$\r\n[oracle@orcl21s ~]$ cp \/tmp\/orapwdgpry $ORACLE_HOME\/dbs\/orapwdg21nf1\r\n[oracle@orcl21s ~]$\r\n[oracle@orcl21s ~]$ orapwd describe file=$ORACLE_HOME\/dbs\/orapwdg21nf1\r\nPassword&nbsp;file&nbsp;Description&nbsp;:&nbsp;format=12\r\n[oracle@orcl21s ~]$&nbsp;\r\n[oracle@orcl21s ~]$ sqlplus sys\/oracle@dg21nf as sysdba\r\n\r\nSQL*Plus: Release 21.0.0.0.0 - Production on Tue Aug 24 00:35:40 2021\r\nVersion 21.3.0.0.0\r\n\r\nCopyright (c) 1982, 2021, Oracle.  All rights reserved.\r\n\r\nERROR:\r\nORA-01017: invalid username\/password; logon denied\r\n\r\n\r\nEnter user-name:\r\nERROR:\r\nORA-01017: invalid username\/password; logon denied\r\n\r\n\r\nEnter user-name:\r\nERROR:\r\nORA-01017: invalid username\/password; logon denied\r\n\r\n\r\nSP2-0157: unable to CONNECT to ORACLE after 3 attempts, exiting SQL*Plus\r\n[oracle@orcl21s ~]$<\/pre>\n<p style=\"text-align: justify;\"><strong>As you can see, not work<\/strong>. So now I put at the new (and correct) path &#8211; <strong>ORACLE_BASE_CONFIG\/dbs<\/strong> &#8211; and you can see that worked perfectly:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">[oracle@orcl21s ~]$ mv $ORACLE_HOME\/dbs\/orapwdg21nf1 \/u01\/app\/oracle\/dbs\/orapwdg21nf1\r\n[oracle@orcl21s ~]$\r\n[oracle@orcl21s ~]$ sqlplus sys\/oracle@dg21nf as sysdba\r\n\r\nSQL*Plus: Release 21.0.0.0.0 - Production on Tue Aug 24 00:36:18 2021\r\nVersion 21.3.0.0.0\r\n\r\nCopyright (c) 1982, 2021, Oracle.  All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production\r\nVersion 21.3.0.0.0\r\n\r\nSQL&gt; exit\r\nDisconnected from Oracle Database 21c Enterprise Edition Release 21.0.0.0.0 - Production\r\nVersion 21.3.0.0.0\r\n[oracle@orcl21s ~]$\r\n<\/pre>\n<p style=\"text-align: justify;\">So, starting with 21c you need to know where to copy your files. Now, the Oracle Home is Read-Only and if you continue to put files there (as made until 19c) you can have problems identifying and troubleshooting the error. Even more for Data Guard where sometimes you need to edit tnsnames and password files manually. <strong>Read the <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/21\/ladbi\/configuring-read-only-oracle-homes.html#GUID-906DA159-AC83-4ACC-A8A6-5B4A39EB72E1\" target=\"_blank\" rel=\"noopener\">official documentation<\/a> for ROOH to understand all the details and <a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/21\/ladbi\/file-path-directory-changes-read-only-oracle-home.html#GUID-695D5458-A4AF-4F2A-AE4B-FB1062CF6014\" target=\"_blank\" rel=\"noopener\">file paths<\/a><\/strong>.<\/p>\n<p style=\"text-align: justify;\">&nbsp;<\/p>\n<p style=\"text-align: justify;\"><strong>Disclaimer<\/strong>:&nbsp;<em>\u201cThe postings on this site are my own and don\u2019t necessarily represent my actual employer positions, strategies or opinions. The information here was edited to be useful for general purpose, specific data and identifications were removed to allow reach the generic audience and to be useful for the community. Post protected by copyright.\u201d<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"<p>ROOH \u2013 Read-Only Oracle Home \u2013 is the new way to work with Oracle 21c where the Oracle Home folder is read-only. Now, (besides the previous version like 19c) it is the default for 21c, and this means that some activities need to be changed from now. Recently I was playing with Data Guard and [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[164,29,5],"tags":[166,65],"class_list":["post-895","post","type-post","status-publish","format-standard","hentry","category-21c","category-database","category-oracle","tag-21c","tag-oracle"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>21c, ROOH - Fernando Simon<\/title>\n<meta name=\"description\" content=\"Check the correct path where to put the tnsnames.ora and password file at Oracle 21c for Read-Only Oracle Home - ROOH.\" \/>\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.fernandosimon.com\/blog\/21c-rooh\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"21c, ROOH - Fernando Simon\" \/>\n<meta property=\"og:description\" content=\"Check the correct path where to put the tnsnames.ora and password file at Oracle 21c for Read-Only Oracle Home - ROOH.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.fernandosimon.com\/blog\/21c-rooh\/\" \/>\n<meta property=\"og:site_name\" content=\"Fernando Simon\" \/>\n<meta property=\"article:published_time\" content=\"2021-08-29T21:21:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2021\/08\/Image-Move-300x243.png\" \/>\n<meta name=\"author\" content=\"Simon\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Simon\" \/>\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.fernandosimon.com\\\/blog\\\/21c-rooh\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/21c-rooh\\\/\"},\"author\":{\"name\":\"Simon\",\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/#\\\/schema\\\/person\\\/386da956604bca0d5be5dd52210c1dd9\"},\"headline\":\"21c, ROOH\",\"datePublished\":\"2021-08-29T21:21:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/21c-rooh\\\/\"},\"wordCount\":499,\"commentCount\":3,\"image\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/21c-rooh\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Image-Move-300x243.png\",\"keywords\":[\"21c\",\"Oracle\"],\"articleSection\":[\"21c\",\"Database\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/21c-rooh\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/21c-rooh\\\/\",\"url\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/21c-rooh\\\/\",\"name\":\"21c, ROOH - Fernando Simon\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/21c-rooh\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/21c-rooh\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Image-Move-300x243.png\",\"datePublished\":\"2021-08-29T21:21:21+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/#\\\/schema\\\/person\\\/386da956604bca0d5be5dd52210c1dd9\"},\"description\":\"Check the correct path where to put the tnsnames.ora and password file at Oracle 21c for Read-Only Oracle Home - ROOH.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/21c-rooh\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/21c-rooh\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/21c-rooh\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Image-Move.png\",\"contentUrl\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/Image-Move.png\",\"width\":999,\"height\":808},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/21c-rooh\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"21c, ROOH\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/\",\"name\":\"Fernando Simon\",\"description\":\"Have you hugged your backup today?\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/#\\\/schema\\\/person\\\/386da956604bca0d5be5dd52210c1dd9\",\"name\":\"Simon\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g\",\"caption\":\"Simon\"},\"sameAs\":[\"http:\\\/\\\/www.fernandosimon.com\"],\"url\":\"https:\\\/\\\/www.fernandosimon.com\\\/blog\\\/author\\\/simon\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"21c, ROOH - Fernando Simon","description":"Check the correct path where to put the tnsnames.ora and password file at Oracle 21c for Read-Only Oracle Home - ROOH.","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.fernandosimon.com\/blog\/21c-rooh\/","og_locale":"en_US","og_type":"article","og_title":"21c, ROOH - Fernando Simon","og_description":"Check the correct path where to put the tnsnames.ora and password file at Oracle 21c for Read-Only Oracle Home - ROOH.","og_url":"https:\/\/www.fernandosimon.com\/blog\/21c-rooh\/","og_site_name":"Fernando Simon","article_published_time":"2021-08-29T21:21:21+00:00","og_image":[{"url":"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2021\/08\/Image-Move-300x243.png","type":"","width":"","height":""}],"author":"Simon","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Simon","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.fernandosimon.com\/blog\/21c-rooh\/#article","isPartOf":{"@id":"https:\/\/www.fernandosimon.com\/blog\/21c-rooh\/"},"author":{"name":"Simon","@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9"},"headline":"21c, ROOH","datePublished":"2021-08-29T21:21:21+00:00","mainEntityOfPage":{"@id":"https:\/\/www.fernandosimon.com\/blog\/21c-rooh\/"},"wordCount":499,"commentCount":3,"image":{"@id":"https:\/\/www.fernandosimon.com\/blog\/21c-rooh\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2021\/08\/Image-Move-300x243.png","keywords":["21c","Oracle"],"articleSection":["21c","Database","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.fernandosimon.com\/blog\/21c-rooh\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.fernandosimon.com\/blog\/21c-rooh\/","url":"https:\/\/www.fernandosimon.com\/blog\/21c-rooh\/","name":"21c, ROOH - Fernando Simon","isPartOf":{"@id":"https:\/\/www.fernandosimon.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.fernandosimon.com\/blog\/21c-rooh\/#primaryimage"},"image":{"@id":"https:\/\/www.fernandosimon.com\/blog\/21c-rooh\/#primaryimage"},"thumbnailUrl":"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2021\/08\/Image-Move-300x243.png","datePublished":"2021-08-29T21:21:21+00:00","author":{"@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9"},"description":"Check the correct path where to put the tnsnames.ora and password file at Oracle 21c for Read-Only Oracle Home - ROOH.","breadcrumb":{"@id":"https:\/\/www.fernandosimon.com\/blog\/21c-rooh\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.fernandosimon.com\/blog\/21c-rooh\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.fernandosimon.com\/blog\/21c-rooh\/#primaryimage","url":"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2021\/08\/Image-Move.png","contentUrl":"https:\/\/www.fernandosimon.com\/blog\/wp-content\/uploads\/2021\/08\/Image-Move.png","width":999,"height":808},{"@type":"BreadcrumbList","@id":"https:\/\/www.fernandosimon.com\/blog\/21c-rooh\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.fernandosimon.com\/blog\/"},{"@type":"ListItem","position":2,"name":"21c, ROOH"}]},{"@type":"WebSite","@id":"https:\/\/www.fernandosimon.com\/blog\/#website","url":"https:\/\/www.fernandosimon.com\/blog\/","name":"Fernando Simon","description":"Have you hugged your backup today?","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.fernandosimon.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.fernandosimon.com\/blog\/#\/schema\/person\/386da956604bca0d5be5dd52210c1dd9","name":"Simon","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a3dbc48de62fffb1829befb4a588d789ec6dc5e05977afabb3407a5f37a16482?s=96&d=mm&r=g","caption":"Simon"},"sameAs":["http:\/\/www.fernandosimon.com"],"url":"https:\/\/www.fernandosimon.com\/blog\/author\/simon\/"}]}},"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5ofTp-er","jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/posts\/895","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/comments?post=895"}],"version-history":[{"count":0,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/posts\/895\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/media?parent=895"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/categories?post=895"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fernandosimon.com\/blog\/wp-json\/wp\/v2\/tags?post=895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}