{"id":17085,"date":"2022-01-21T21:58:53","date_gmt":"2022-01-21T20:58:53","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-database-appliance-oda-adjusting-to-the-new-oracle_base-setting-from-19-11-onwards\/"},"modified":"2022-01-21T21:58:53","modified_gmt":"2022-01-21T20:58:53","slug":"oracle-database-appliance-oda-adjusting-to-the-new-oracle_base-setting-from-19-11-onwards","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-database-appliance-oda-adjusting-to-the-new-oracle_base-setting-from-19-11-onwards\/","title":{"rendered":"Oracle Database Appliance (ODA): Adjusting to the new ORACLE_BASE-setting from 19.11. onwards"},"content":{"rendered":"

By Clemens Bleile<\/h2>\n

From Oracle Database Appliance (ODA) version 19.11. onwards the ORACLE_HOMEs and ORACLE_BASE will be created on ACFS, i.e. take space from an ASM-diskgroup instead of taking filesystem space from \/u01. See this blog<\/a> concerning details.<\/p>\n

If the ODA has been upgraded from a release < 19.11. to 19.11. or newer, then you usually have diag- and admin-data in 2 ORACLE_BASE-locations: <\/p>\n

\n\/u01\/app\/oracle\n<\/pre>\n
for databases created before migrating to ODA 19.11. or newer and<\/p>\n
\n\/u01\/app\/odaorabase\/oracle\n<\/pre>\n
for databases created after the migration to ODA 19.11. or newer.<\/p>\n
An ORACLE_HOME is associated to an ORACLE_BASE. This can be shown by running the command orabase:<\/p>\n
\noracle@dbi-oda-x8:\/home\/oracle\/ [rdbms191300] orabase\n\/u01\/app\/odaorabase\/oracle\n<\/pre>\n
orabase takes its info from <\/p>\n
\n$ORACLE_HOME\/install\/orabasetab\n<\/pre>\n
Migrating databases created before ODA 19.11. to an ORACLE_HOME created after the installation of ODA 19.11. causes diagnostics and admin-data to remain in the “old” ORACLE_BASE \/u01\/app\/oracle, but the command orabase points to the “new” ORACLE_BASE \/u01\/app\/odaorabase\/oracle. Tools, which rely on a global ORACLE_BASE settings may have problems handling 2 ORACLE_BASE locations on a machine. <\/p>\n
REMARK: The dbi-services tool DMK Management Kit<\/a> can handle the situation with different ORACLE_BASE on a machine by specifying the ORACLE_BASE-location per database in separate sections in $DMK_HOME\/etc\/dmk.conf.<\/p>\n
The following instructions will show the steps to move the diag- and admin-data of a database from an “old” ORACLE_BASE \/u01\/app\/oracle to the “new” ORACLE_BASE \/u01\/app\/odaorabase\/oracle:<\/p>\n
E.g. assume we have a Database CBLTEST which has an ORACLE_BASE \/u01\/app\/oracle and a newly created database CBLTEST2 with an ORACLE_BASE \/u01\/app\/odaorabase0:<\/p>\n
\n[root@dbi-oda-x8 log]# odacli list-databases\n \nID                                       DB Name    DB Type  DB Version           CDB        Class    Shape    Storage    Status        DbHomeID                                \n---------------------------------------- ---------- -------- -------------------- ---------- -------- -------- ---------- ------------ ----------------------------------------\nf9e51c56-fcd2-47a3-bcb4-56587a710f1e     CBLTEST    SI       19.9.0.0.201020      false      OLTP     odb1     ASM        CONFIGURED   d9d1b8dd-4abc-46fe-aae4-d52162d66dab    \n34fd593b-7586-41c9-a58d-71dfc0cf1d90     CBLTEST2   SI       19.13.0.0.211019     true       OLTP     odb1s    ASM        CONFIGURED   4dda330d-feed-491b-bace-006c22b75672\n<\/pre>\n
After bringing CBLTEST to 19.13. with<\/p>\n
\n# odacli update-dbhome -i d9d1b8dd-4abc-46fe-aae4-d52162d66dab -v 19.13.0.0.0\n<\/pre>\n
it has the following ORACLE_BASE-setting:<\/p>\n
\noracle@dbi-oda-x8:\/home\/oracle\/ [CBLTEST] orabase\n\/u01\/app\/odaorabase\/oracle\n<\/pre>\n
but the diagnostics-data still below the “old” ORACLE_BASE.<\/p>\n
Here the steps to copy your diag- and admin-data for CBLTEST to the new ORACLE_BASE:<\/p>\n
REMARK 1: The situation with Read-Only ORACLE_HOMEs is not covered here.
\nREMARK 2: Before doing this in production you should test this on a test system carefully. If in doubt open a Service Request with Oracle.<\/p>\n
1. Change diagnostic_dest and the audit_file_dest in the spfile<\/p>\n
\nsqlplus \/ as sysdba\nSQL> alter system set diagnostic_dest='\/u01\/app\/odaorabase\/oracle' scope=spfile;\nSQL> alter system set audit_file_dest='\/u01\/app\/odaorabase\/oracle\/admin\/CBLTEST\/adump' scope=spfile;\n<\/pre>\n
2. Shutdown the DB<\/p>\n
\nsrvctl stop database -db CBLTEST\n<\/pre>\n
3. Copy the rdbms-diag-data to new ORACLE_BASE<\/p>\n
\ncp -pR \/u01\/app\/oracle\/diag\/rdbms\/cbltest \/u01\/app\/odaorabase\/oracle\/diag\/rdbms\n<\/pre>\n
4. Copy the admin-directory to the new ORACLE_BASE<\/p>\n
\ncp -pR \/u01\/app\/oracle\/admin\/CBLTEST \/u01\/app\/odaorabase\/oracle\/admin\n<\/pre>\n
5. Copy the audit-data for spillover-files from unified auditing. <\/p>\n
\ncp -pR \/u01\/app\/oracle\/audit\/CBLTEST \/u01\/app\/odaorabase\/oracle\/audit\n<\/pre>\n
6. Change ORACLE_BASE to the new value and adjust your scripts, which do set ORACLE_BASE. E.g. for DMK adjust $DMK_HOME\/etc\/dmk.conf<\/p>\n
\nexport ORACLE_BASE=\/u01\/app\/odaorabase\/oracle\n<\/pre>\n
REMARK: You may check if the environment variable ORACLE_BASE has been stored in the Oracle Cluster registry:<\/p>\n
\noracle@dbi-oda-x8:\/home\/oracle\/ [CBLTEST] srvctl getenv database -d CBLTEST -t \"ORACLE_BASE\"\nCBLTEST:\nPRKF-1128 : Environment variable ORACLE_BASE is not defined.\n<\/pre>\n
If it has been set (which would be very unusuable on an ODA) then you can overwrite it with<\/p>\n
\noracle@dbi-oda-x8:\/home\/oracle\/ [CBLTEST] srvctl setenv database -d CBLTEST -t \"ORACLE_BASE=\/u01\/app\/odaorabase\/oracle\"\noracle@dbi-oda-x8:\/home\/oracle\/ [CBLTEST] srvctl getenv database -d CBLTEST -t \"ORACLE_BASE\"\nCBLTEST:\nORACLE_BASE=\/u01\/app\/odaorabase\/oracle\n<\/pre>\n
7. Startup the DB<\/p>\n
\nsrvctl start database -db CBLTEST\n<\/pre>\n
8. Check that everything is correct<\/p>\n
8.1. Re-login as oracle, set the environment and connect “as sysdba”. Here with DMK sourced:<\/p>\n
\noracle@dbi-oda-x8:\/home\/oracle\/ [rdbms191300] CBLTEST\n********* dbi services Ltd. *********\nSTATUS                 : OPEN\nDB_UNIQUE_NAME         : CBLTEST\nOPEN_MODE              : READ WRITE\nLOG_MODE               : ARCHIVELOG\nDATABASE_ROLE          : PRIMARY\nFLASHBACK_ON           : NO\nFORCE_LOGGING          : YES\nVERSION                : 19.13.0.0.0\nCDB Enabled            : NO\n*************************************\noracle@dbi-oda-x8:\/home\/oracle\/ [CBLTEST] echo $ORACLE_BASE\n\/u01\/app\/odaorabase\/oracle\noracle@dbi-oda-x8:\/home\/oracle\/ [CBLTEST] sqh\n\nSQL*Plus: Release 19.0.0.0.0 - Production on Fri Jan 21 20:51:48 2022\nVersion 19.13.0.0.0\n\nCopyright (c) 1982, 2021, Oracle.  All rights reserved.\n\nConnected to:\nOracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production\nVersion 19.13.0.0.0\n\nSQL> select value from v$diag_info where value like '\/u01%';\n\nVALUE\n---------------------------------------------------------------------------------\n\/u01\/app\/odaorabase\/oracle\n\/u01\/app\/odaorabase\/oracle\/diag\/rdbms\/cbltest\/CBLTEST\n\/u01\/app\/odaorabase\/oracle\/diag\/rdbms\/cbltest\/CBLTEST\/trace\n\/u01\/app\/odaorabase\/oracle\/diag\/rdbms\/cbltest\/CBLTEST\/alert\n\/u01\/app\/odaorabase\/oracle\/diag\/rdbms\/cbltest\/CBLTEST\/incident\n\/u01\/app\/odaorabase\/oracle\/diag\/rdbms\/cbltest\/CBLTEST\/cdump\n\/u01\/app\/odaorabase\/oracle\/diag\/rdbms\/cbltest\/CBLTEST\/hm\n\/u01\/app\/odaorabase\/oracle\/diag\/rdbms\/cbltest\/CBLTEST\/trace\/CBLTEST_ora_45735.trc\n\/u01\/app\/odaorahome\/oracle\/product\/19.0.0.0\/dbhome_4\n\n9 rows selected.\n\nSQL> quit\nDisconnected from Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production\nVersion 19.13.0.0.0\noracle@dbi-oda-x8:\/home\/oracle\/ [CBLTEST] cda\noracle@dbi-oda-x8:\/u01\/app\/odaorabase\/oracle\/admin\/CBLTEST\/ [CBLTEST] ls -l\ntotal 364\ndrwxr-x--- 2 oracle oinstall 20480 Jan 13 22:01 adump\ndrwxr-xr-x 2 oracle oinstall 20480 Jan 13 22:48 backup\ndrwxr-x--- 2 oracle oinstall 20480 Jan 13 12:27 dpdump\ndrwxr-xr-x 2 oracle oinstall 20480 Jan 13 18:01 etc\ndrwxr-xr-x 2 oracle oinstall 20480 Jan 13 22:48 log\ndrwxr-x--- 2 oracle oinstall 20480 Jan 13 12:29 pfile\ndrwxr-x--- 2 oracle oinstall 20480 Jan 13 12:23 xdb_wallet\noracle@dbi-oda-x8:\/u01\/app\/odaorabase\/oracle\/admin\/CBLTEST\/ [CBLTEST] \n<\/pre>\n
8.2. Check adrci<\/p>\n
\noracle@dbi-oda-x8:\/home\/oracle\/ [CBLTEST] adrci\n\nADRCI: Release 19.0.0.0.0 - Production on Fri Jan 21 19:51:30 2022\n\nCopyright (c) 1982, 2019, Oracle and\/or its affiliates.  All rights reserved.\n\nADR base = \"\/u01\/app\/odaorabase\/oracle\"\nadrci> show base\nADR base is \"\/u01\/app\/odaorabase\/oracle\"\nadrci> \n<\/pre>\n
–> The Base-setting in adrci is coming from the file $ORACLE_HOME\/log\/diag\/adrci_dir.mif<\/p>\n
9. Cleanup<\/p>\n
If everything is correct, then you may delete the data from the “old” ORACLE_BASE:<\/p>\n
\nrm -rf \/u01\/app\/oracle\/diag\/rdbms\/cbltest\nrm -rf \/u01\/app\/oracle\/admin\/CBLTEST\nrm -rf \/u01\/app\/oracle\/admin\/audit\/CBLTEST\n<\/pre>\n
References<\/h3>\n
https:\/\/marcelpils.de\/orabase-doesnt-show-the-current-oracle-base-path<\/a>
\nhttps:\/\/www.thegeekdiary.com\/oracle-database-how-to-set-environment-variables-using-srvctl<\/a>
\nhttps:\/\/logic.edchen.org\/how-to-resolve-no-adr-base-is-set<\/a><\/p>\n
MOS Notes<\/h3>\n
How To Change The Value For ORACLE_BASE In The Inventory Of A 12.1 RDBMS Home (Doc ID 2010941.1)
\norabase command returns no value instead of ORACLE_BASE value (Doc ID 2225573.1)<\/p>\n","protected":false},"excerpt":{"rendered":"
By Clemens Bleile From Oracle Database Appliance (ODA) version 19.11. onwards the ORACLE_HOMEs and ORACLE_BASE will be created on ACFS, i.e. take space from an ASM-diskgroup instead of taking filesystem space from \/u01. See this blog concerning details. If the ODA has been upgraded from a release < 19.11. to 19.11. or newer, then you […]<\/p>\n","protected":false},"author":35,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[600,79,2463,365,2464],"type_dbi":[],"class_list":["post-17085","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-acfs","tag-oda","tag-orabase","tag-oracle-database-appliance","tag-oracle_base"],"acf":[],"yoast_head":"\nOracle Database Appliance (ODA): Adjusting to the new ORACLE_BASE-setting from 19.11. onwards - dbi 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\/oracle-database-appliance-oda-adjusting-to-the-new-oracle_base-setting-from-19-11-onwards\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Database Appliance (ODA): Adjusting to the new ORACLE_BASE-setting from 19.11. onwards\" \/>\n<meta property=\"og:description\" content=\"By Clemens Bleile From Oracle Database Appliance (ODA) version 19.11. onwards the ORACLE_HOMEs and ORACLE_BASE will be created on ACFS, i.e. take space from an ASM-diskgroup instead of taking filesystem space from \/u01. See this blog concerning details. If the ODA has been upgraded from a release < 19.11. to 19.11. or newer, then you […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-database-appliance-oda-adjusting-to-the-new-oracle_base-setting-from-19-11-onwards\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-01-21T20:58:53+00:00\" \/>\n<meta name=\"author\" content=\"Clemens Bleile\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@ifgtxD2SrQ8r!YuXj\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Clemens Bleile\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 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\/oracle-database-appliance-oda-adjusting-to-the-new-oracle_base-setting-from-19-11-onwards\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-appliance-oda-adjusting-to-the-new-oracle_base-setting-from-19-11-onwards\/\"},\"author\":{\"name\":\"Clemens Bleile\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da\"},\"headline\":\"Oracle Database Appliance (ODA): Adjusting to the new ORACLE_BASE-setting from 19.11. onwards\",\"datePublished\":\"2022-01-21T20:58:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-appliance-oda-adjusting-to-the-new-oracle_base-setting-from-19-11-onwards\/\"},\"wordCount\":551,\"commentCount\":0,\"keywords\":[\"ACFS\",\"ODA\",\"orabase\",\"Oracle database appliance\",\"ORACLE_BASE\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-database-appliance-oda-adjusting-to-the-new-oracle_base-setting-from-19-11-onwards\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-appliance-oda-adjusting-to-the-new-oracle_base-setting-from-19-11-onwards\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-appliance-oda-adjusting-to-the-new-oracle_base-setting-from-19-11-onwards\/\",\"name\":\"Oracle Database Appliance (ODA): Adjusting to the new ORACLE_BASE-setting from 19.11. onwards - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2022-01-21T20:58:53+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-appliance-oda-adjusting-to-the-new-oracle_base-setting-from-19-11-onwards\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-database-appliance-oda-adjusting-to-the-new-oracle_base-setting-from-19-11-onwards\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-database-appliance-oda-adjusting-to-the-new-oracle_base-setting-from-19-11-onwards\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Database Appliance (ODA): Adjusting to the new ORACLE_BASE-setting from 19.11. onwards\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"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\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da\",\"name\":\"Clemens Bleile\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g\",\"caption\":\"Clemens Bleile\"},\"description\":\"Clemens Bleile has more than 30 years of IT experience, thirteen in Oracle Support and fifteen in Oracle Consulting. He is specialized in Oracle Database Performance Tuning (SQL Tuning, DB Tuning) and developing an Oracle DB IT architecture (highly available, low-maintenance, cost efficient storage of data). He is an expert in problem analysis and resolution. Prior to joining dbi services, Clemens Bleile was Manager of the EMEA Database Performance team at the Oracle Global Customer Support Services. Clemens Bleile is Oracle Certified Professional 11g, 12c and Oracle Certified Expert for Performance Management and Tuning and holds a Master Degree, Business Information Systems from the Fachhochschule Furtwangen, Germany.\",\"sameAs\":[\"https:\/\/www.dbi-services.com\",\"https:\/\/x.com\/ifgtxD2SrQ8r!YuXj\"],\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/clemens-bleile\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle Database Appliance (ODA): Adjusting to the new ORACLE_BASE-setting from 19.11. onwards - dbi 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\/oracle-database-appliance-oda-adjusting-to-the-new-oracle_base-setting-from-19-11-onwards\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Database Appliance (ODA): Adjusting to the new ORACLE_BASE-setting from 19.11. onwards","og_description":"By Clemens Bleile From Oracle Database Appliance (ODA) version 19.11. onwards the ORACLE_HOMEs and ORACLE_BASE will be created on ACFS, i.e. take space from an ASM-diskgroup instead of taking filesystem space from \/u01. See this blog concerning details. If the ODA has been upgraded from a release < 19.11. to 19.11. or newer, then you […]","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-database-appliance-oda-adjusting-to-the-new-oracle_base-setting-from-19-11-onwards\/","og_site_name":"dbi Blog","article_published_time":"2022-01-21T20:58:53+00:00","author":"Clemens Bleile","twitter_card":"summary_large_image","twitter_creator":"@ifgtxD2SrQ8r!YuXj","twitter_misc":{"Written by":"Clemens Bleile","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-appliance-oda-adjusting-to-the-new-oracle_base-setting-from-19-11-onwards\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-appliance-oda-adjusting-to-the-new-oracle_base-setting-from-19-11-onwards\/"},"author":{"name":"Clemens Bleile","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da"},"headline":"Oracle Database Appliance (ODA): Adjusting to the new ORACLE_BASE-setting from 19.11. onwards","datePublished":"2022-01-21T20:58:53+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-appliance-oda-adjusting-to-the-new-oracle_base-setting-from-19-11-onwards\/"},"wordCount":551,"commentCount":0,"keywords":["ACFS","ODA","orabase","Oracle database appliance","ORACLE_BASE"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-database-appliance-oda-adjusting-to-the-new-oracle_base-setting-from-19-11-onwards\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-appliance-oda-adjusting-to-the-new-oracle_base-setting-from-19-11-onwards\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-database-appliance-oda-adjusting-to-the-new-oracle_base-setting-from-19-11-onwards\/","name":"Oracle Database Appliance (ODA): Adjusting to the new ORACLE_BASE-setting from 19.11. onwards - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2022-01-21T20:58:53+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-appliance-oda-adjusting-to-the-new-oracle_base-setting-from-19-11-onwards\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-database-appliance-oda-adjusting-to-the-new-oracle_base-setting-from-19-11-onwards\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-database-appliance-oda-adjusting-to-the-new-oracle_base-setting-from-19-11-onwards\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle Database Appliance (ODA): Adjusting to the new ORACLE_BASE-setting from 19.11. onwards"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","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":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0ac04011f60f2e93c115358d0789c2da","name":"Clemens Bleile","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1f596609fc67cb28ed714e7bccc81ed4cd73b8582a8148a490c77daeb2fde21a?s=96&d=mm&r=g","caption":"Clemens Bleile"},"description":"Clemens Bleile has more than 30 years of IT experience, thirteen in Oracle Support and fifteen in Oracle Consulting. He is specialized in Oracle Database Performance Tuning (SQL Tuning, DB Tuning) and developing an Oracle DB IT architecture (highly available, low-maintenance, cost efficient storage of data). He is an expert in problem analysis and resolution. Prior to joining dbi services, Clemens Bleile was Manager of the EMEA Database Performance team at the Oracle Global Customer Support Services. Clemens Bleile is Oracle Certified Professional 11g, 12c and Oracle Certified Expert for Performance Management and Tuning and holds a Master Degree, Business Information Systems from the Fachhochschule Furtwangen, Germany.","sameAs":["https:\/\/www.dbi-services.com","https:\/\/x.com\/ifgtxD2SrQ8r!YuXj"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/clemens-bleile\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/17085","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\/35"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=17085"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/17085\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=17085"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=17085"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=17085"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=17085"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}