{"id":10026,"date":"2017-05-10T15:24:21","date_gmt":"2017-05-10T13:24:21","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/upgrade-to-oracle-12-2-with-dbupgrade-utility\/"},"modified":"2023-06-08T16:33:30","modified_gmt":"2023-06-08T14:33:30","slug":"upgrade-to-oracle-12-2-with-dbupgrade-utility","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/upgrade-to-oracle-12-2-with-dbupgrade-utility\/","title":{"rendered":"Upgrade to Oracle 12.2 with  dbupgrade utility"},"content":{"rendered":"<p><strong>By Mouhamadou Diaw<\/strong><\/p>\n<p>Oracle 12.2 is released and we will have to upgrade. And in this blog we are going to talk about upgrading to oracle 12.2 using the dbupgrade utility.<\/p>\n<p>Of course the dbua tool is still available and can be also used.<\/p>\n<p>Oracle Database 12.1 introduced the Parallel Upgrade Utility, catctl.pl. This utility reduces the total amount of time it takes to perform an upgrade by loading the database dictionary in parallel, and by using multiple SQL processes to upgrade the database.<\/p>\n<p>In Oracle 12.1 catcpl.pl had to be run using perl like<br \/>\n<code>$ORACLE_HOME\/perl\/bin\/perl catctl.pl -n 8 -l \/home\/oracle catupgrd.log<\/code><br \/>\nStarting with Oracle 12.2, we can use dbupgrade utility which starts up catctl.pl instead to run it from perl.<\/p>\n<p>In this article we will describe the steps for upgrade using <span style=\"color: #ea6d14\">dbupgrade<\/span>.<\/p>\n<p>The first step is to run the preupgrade information tool <span style=\"color: #ea6d14\">preupgrade.jar<\/span> tool which replaced the preupgrd.sql and utluppkg.sql scripts. This tool can be run from operating system command line. Remember that in 12.1, the Pre-Upgrade Information Tool was run within SQL*Plus as a SQL file.<\/p>\n<p>Following environment variables must be set. Indeed ORACLE_HOME must point to the earlier release.<br \/>\n<code><br \/>\n[oracle@serveroracle ~]$ export ORACLE_HOME=\/u01\/app\/oracle\/product\/12.1.0\/dbhome_1<br \/>\n[oracle@serveroracle ~]$ export ORACLE_BASE=\/u01\/app\/oracle<br \/>\n[oracle@serveroracle ~]$ export ORACLE_SID=ORCL<br \/>\n[oracle@serveroracle ~]$ export PATH=.:$ORACLE_HOME\/bin:$PATH<br \/>\n<\/code><br \/>\nThe preupgrade.jar file is located to the oracle 12.2 $ORACLE_HOME\/rdbms\/admin. We can execute it using the TERMINAL or FILE options. The TERMINAL option will send output in the terminal and with FILE we will have the output in a file.<br \/>\n<code><br \/>\noracle@serveroracle:~[ORCL] $ORACLE_HOME\/jdk\/bin\/java -jar \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/admin\/preupgrade.jar TERMINAL TEXT<br \/>\nReport generated by Oracle Database Pre-Upgrade Information Tool Version<br \/>\n12.2.0.1.0<br \/>\nUpgrade-To version: 12.2.0.1.0<br \/>\n=======================================<br \/>\nStatus of the database prior to upgrade<br \/>\n=======================================<br \/>\nDatabase Name:  ORCL<br \/>\nContainer Name:  ORCL<br \/>\nContainer ID:  0<br \/>\nVersion:  12.1.0.2.0<br \/>\nCompatible:  12.1.0.2.0<br \/>\nBlocksize:  8192<br \/>\nPlatform:  Linux x86 64-bit<br \/>\nTimezone File:  18<br \/>\nDatabase log mode:  ARCHIVELOG<br \/>\nReadonly:  FALSE<br \/>\nEdition:  EE<br \/>\n...<br \/>\n...<br \/>\n...<br \/>\nPreupgrade generated files:<br \/>\n\/u01\/app\/oracle\/cfgtoollogs\/ORCL\/preupgrade\/preupgrade_fixups.sql<br \/>\n\/u01\/app\/oracle\/cfgtoollogs\/ORCL\/preupgrade\/postupgrade_fixups.sql<br \/>\noracle@serveroracle:~[ORCL]<br \/>\n<\/code><br \/>\nAs specified if we want the output in a file, we can use the option FILE instead of TERMINAL. The output directory is $ORACLE_BASE\/cfgtoollogs\/$ORACLE_SID<br \/>\n<code><br \/>\n[oracle@serveroracle ~]$ $ORACLE_HOME\/jdk\/bin\/java -jar \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/admin\/preupgrade.jar FILE  TEXT<br \/>\nPreupgrade generated files:<br \/>\n\/u01\/app\/oracle\/cfgtoollogs\/ORCL\/preupgrade\/preupgrade.log<br \/>\n\/u01\/app\/oracle\/cfgtoollogs\/ORCL\/preupgrade\/preupgrade_fixups.sql<br \/>\n\/u01\/app\/oracle\/cfgtoollogs\/ORCL\/preupgrade\/postupgrade_fixups.sql<br \/>\n[oracle@serveroracle ~]$<br \/>\n<\/code><br \/>\nOnce the execution done, the tool will identify possible issues during the upgrade and will also generate 2 scripts<br \/>\n\uf0d8 preupgrade_fixups.sql: fixes issues that an automated script can fix safely. This script must be run before the upgrade<br \/>\n\uf0d8 postupgrade_fixups.sql: fixes the upgrade issues that can be automatically fixed after the upgrade.<br \/>\nFor all other issues we have to manually fix them.<br \/>\n<code><br \/>\nConnected to:<br \/>\nOracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production<br \/>\nWith the Partitioning, OLAP, Advanced Analytics and Real Application Testing options<br \/>\nSQL&gt; @preupgrade_fixups.sql<br \/>\n<\/code><br \/>\nOnce done we are ready to run the dbupgrade utility.<\/p>\n<p>Prepare the environment<br \/>\n<code><br \/>\noracle@serveroracle:\/home\/oracle\/ [rdbm12201] which dbupgrade<br \/>\n\/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/bin\/dbupgrade<br \/>\noracle@serveroracle:\/home\/oracle\/ [rdbm12201] echo $ORACLE_HOME<br \/>\n\/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1<br \/>\noracle@serveroracle:\/home\/oracle\/ [rdbm12201] export ORACLE_SID=ORCL<br \/>\n<\/code><br \/>\nCopy the parameter file to the oracle 12.2 ORACLE_HOME\/dbs<br \/>\n<code><br \/>\noracle@serveroracle:\/home\/oracle\/ [ORCL] cp \/u01\/app\/oracle\/product\/12.1.0\/dbhome_1\/dbs\/spfileORCL.ora \/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/dbs\/<br \/>\noracle@serveroracle:\/home\/oracle\/ [ORCL]<br \/>\n<\/code><br \/>\nStart the database in the new environment in an upgrade mode<br \/>\n<code><br \/>\noracle@serveroracle:\/home\/oracle\/ [ORCL] which sqlplus<br \/>\n\/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/bin\/sqlplus<br \/>\noracle@serveroracle:\/home\/oracle\/ [ORCL] sqlplus<br \/>\nSQL*Plus: Release 12.2.0.1.0 Production on Thu May 4 16:24:22 2017<br \/>\nCopyright (c) 1982, 2016, Oracle.  All rights reserved.<br \/>\nConnected to an idle instance.<br \/>\nSQL&gt; startup upgrade<br \/>\nORACLE instance started.<br \/>\nTotal System Global Area  394264576 bytes<br \/>\nFixed Size                  8621136 bytes<br \/>\nVariable Size             293602224 bytes<br \/>\nDatabase Buffers           83886080 bytes<br \/>\nRedo Buffers                8155136 bytes<br \/>\nDatabase mounted.<br \/>\nDatabase opened.<br \/>\nSQL&gt;<br \/>\n<\/code><br \/>\nAnd then run the dbupgrade utility<br \/>\n<code><br \/>\noracle@serveroracle:\/home\/oracle\/upgrade\/ [ORCL] dbupgrade -n 2 -l \/home\/oracle\/upgrade<br \/>\nArgument list for [\/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\/rdbms\/admin\/catctl.pl]<br \/>\nRun in                c = 0<br \/>\nDo not run in         C = 0<br \/>\nInput Directory       d = 0<br \/>\nEcho OFF              e = 1<br \/>\nSimulate              E = 0<br \/>\nForced cleanup        F = 0<br \/>\nLog Id                i = 0<br \/>\nChild Process         I = 0<br \/>\nLog Dir               l = \/home\/oracle\/upgrade<br \/>\nPriority List Name    L = 0<br \/>\nUpgrade Mode active   M = 0<br \/>\nSQL Process Count     n = 2<br \/>\nSQL PDB Process Count N = 0<br \/>\nOpen Mode Normal      o = 0<br \/>\nStart Phase           p = 0<br \/>\nEnd Phase             P = 0<br \/>\nReverse Order         r = 0<br \/>\nAutoUpgrade Resume    R = 0<br \/>\nScript                s = 0<br \/>\nSerial Run            S = 0<br \/>\nRO User Tablespaces   T = 0<br \/>\nDisplay Phases        y = 0<br \/>\nDebug catcon.pm       z = 0<br \/>\nDebug catctl.pl       Z = 0<br \/>\ncatctl.pl VERSION: [12.2.0.1.0]<br \/>\nSTATUS: [production]<br \/>\nBUILD: [RDBMS_12.2.0.1.0_LINUX.X64_170125]<br \/>\n...<br \/>\n...<br \/>\n...<br \/>\nLOG FILES: (\/home\/oracle\/upgrade\/catupgrd*.log)<br \/>\nUpgrade Summary Report Located in:<br \/>\n\/home\/oracle\/upgrade\/upg_summary.log<br \/>\nGrand Total Upgrade Time:    [0d:1h:38m:21s]<br \/>\noracle@serveroracle:\/home\/oracle\/upgrade\/ [ORCL]<br \/>\n<\/code><br \/>\nOnce the upgraded finished without errors, we can run the postupgrade_fixups.sql.<br \/>\n<code><br \/>\nSQL*Plus: Release 12.2.0.1.0 Production on Thu May 4 23:17:10 2017<br \/>\nCopyright (c) 1982, 2016, Oracle.  All rights reserved.<br \/>\nConnected to:<br \/>\nOracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production<br \/>\nSQL&gt; @postupgrade_fixups.sql<br \/>\n<\/code><\/p>\n<p>Hope that this article will help<\/p>\n","protected":false},"excerpt":{"rendered":"<p>By Mouhamadou Diaw Oracle 12.2 is released and we will have to upgrade. And in this blog we are going to talk about upgrading to oracle 12.2 using the dbupgrade utility. Of course the dbua tool is still available and can be also used. Oracle Database 12.1 introduced the Parallel Upgrade Utility, catctl.pl. This utility [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[1087,279,1088,988,219],"type_dbi":[],"class_list":["post-10026","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","tag-catctl-pl","tag-dbua","tag-dbupgrade","tag-oracle-12-2","tag-upgrade"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Upgrade to Oracle 12.2 with dbupgrade utility - dbi Blog<\/title>\n<meta name=\"description\" content=\"oracle 12.2, upgrade, dbupgrade, migration\" \/>\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\/upgrade-to-oracle-12-2-with-dbupgrade-utility\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Upgrade to Oracle 12.2 with dbupgrade utility\" \/>\n<meta property=\"og:description\" content=\"oracle 12.2, upgrade, dbupgrade, migration\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/upgrade-to-oracle-12-2-with-dbupgrade-utility\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-05-10T13:24:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-08T14:33:30+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\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\/upgrade-to-oracle-12-2-with-dbupgrade-utility\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/upgrade-to-oracle-12-2-with-dbupgrade-utility\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Upgrade to Oracle 12.2 with dbupgrade utility\",\"datePublished\":\"2017-05-10T13:24:21+00:00\",\"dateModified\":\"2023-06-08T14:33:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/upgrade-to-oracle-12-2-with-dbupgrade-utility\/\"},\"wordCount\":386,\"commentCount\":0,\"keywords\":[\"catctl.pl\",\"dbua\",\"dbupgrade\",\"Oracle 12.2\",\"Upgrade\"],\"articleSection\":[\"Database Administration &amp; Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/upgrade-to-oracle-12-2-with-dbupgrade-utility\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/upgrade-to-oracle-12-2-with-dbupgrade-utility\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/upgrade-to-oracle-12-2-with-dbupgrade-utility\/\",\"name\":\"Upgrade to Oracle 12.2 with dbupgrade utility - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2017-05-10T13:24:21+00:00\",\"dateModified\":\"2023-06-08T14:33:30+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"description\":\"oracle 12.2, upgrade, dbupgrade, migration\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/upgrade-to-oracle-12-2-with-dbupgrade-utility\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/upgrade-to-oracle-12-2-with-dbupgrade-utility\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/upgrade-to-oracle-12-2-with-dbupgrade-utility\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Upgrade to Oracle 12.2 with dbupgrade utility\"}]},{\"@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\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Upgrade to Oracle 12.2 with dbupgrade utility - dbi Blog","description":"oracle 12.2, upgrade, dbupgrade, migration","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\/upgrade-to-oracle-12-2-with-dbupgrade-utility\/","og_locale":"en_US","og_type":"article","og_title":"Upgrade to Oracle 12.2 with dbupgrade utility","og_description":"oracle 12.2, upgrade, dbupgrade, migration","og_url":"https:\/\/www.dbi-services.com\/blog\/upgrade-to-oracle-12-2-with-dbupgrade-utility\/","og_site_name":"dbi Blog","article_published_time":"2017-05-10T13:24:21+00:00","article_modified_time":"2023-06-08T14:33:30+00:00","author":"Oracle Team","twitter_card":"summary_large_image","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\/upgrade-to-oracle-12-2-with-dbupgrade-utility\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/upgrade-to-oracle-12-2-with-dbupgrade-utility\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Upgrade to Oracle 12.2 with dbupgrade utility","datePublished":"2017-05-10T13:24:21+00:00","dateModified":"2023-06-08T14:33:30+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/upgrade-to-oracle-12-2-with-dbupgrade-utility\/"},"wordCount":386,"commentCount":0,"keywords":["catctl.pl","dbua","dbupgrade","Oracle 12.2","Upgrade"],"articleSection":["Database Administration &amp; Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/upgrade-to-oracle-12-2-with-dbupgrade-utility\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/upgrade-to-oracle-12-2-with-dbupgrade-utility\/","url":"https:\/\/www.dbi-services.com\/blog\/upgrade-to-oracle-12-2-with-dbupgrade-utility\/","name":"Upgrade to Oracle 12.2 with dbupgrade utility - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2017-05-10T13:24:21+00:00","dateModified":"2023-06-08T14:33:30+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"description":"oracle 12.2, upgrade, dbupgrade, migration","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/upgrade-to-oracle-12-2-with-dbupgrade-utility\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/upgrade-to-oracle-12-2-with-dbupgrade-utility\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/upgrade-to-oracle-12-2-with-dbupgrade-utility\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Upgrade to Oracle 12.2 with dbupgrade utility"}]},{"@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\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10026","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=10026"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10026\/revisions"}],"predecessor-version":[{"id":25696,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10026\/revisions\/25696"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=10026"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=10026"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=10026"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=10026"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}