{"id":10991,"date":"2018-02-25T20:20:04","date_gmt":"2018-02-25T19:20:04","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/pdb-upgrade-from-12c-to-18c\/"},"modified":"2018-02-25T20:20:04","modified_gmt":"2018-02-25T19:20:04","slug":"pdb-upgrade-from-12c-to-18c","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/pdb-upgrade-from-12c-to-18c\/","title":{"rendered":"PDB upgrade from 12c to 18c"},"content":{"rendered":"

By Franck Pachot<\/h2>\n

.
\nOracle 18c is out, in the Oracle Cloud, and the first thing I do with a new version is testing how long it takes to upgrade a previous version PDB by unplug\/plug. Faster upgrade should be the benefit of having a slim dictionary where the system objects are reduced to metadata links and data links. However, it looks like upgrading the PDB dictionary still takes the same time as upgrading the CDB$ROOT.<\/p>\n

The idea is to create a DBaaS service with a new CDB in 18.1 and plug a PDB coming from 12.2.0.1. Actually, I’m saying 18.1 but that may be 18.0 as I’m now lost in those version numbers. The cloud service was created with version: “18.0.0.0”, V$VERSION displays 18.1.0.0 for the release and 18.0.0.0 for the version:<\/p>\n

Connected to:\nOracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production\nVersion 18.1.0.0.0<\/code><\/pre>\n
My understanding is that the 18.0.0.0 is the version of the 18c dictionary, which will need a full upgrade only for 19c (19.0.0.0). And 18.1.0.0 is about the version, which will be incremented by Release Updates later.
\n<\/p>\n
I have an unplugged PDB that I plug into the new CDB:<\/p>\n
SQL> create pluggable database PDB0 using '\/u01\/app\/temp\/PDB0.pdb';\nPluggable database PDB0 created.<\/code><\/pre>\n
When I open it, I get a warning:<\/p>\n
SQL> alter pluggable database pdb0 open;\n \nORA-24344: success with compilation error\n24344. 00000 -  \"success with compilation error\"\n*Cause:    A sql\/plsql compilation error occurred.\n*Action:   Return OCI_SUCCESS_WITH_INFO along with the error code\n \nPluggable database PDB0 altered.\n<\/code><\/pre>\n
Then I check the PDB PLUG IN VIOLATIONS:
\n <\/p>\n
SQL> select * from pdb_plug_in_violations;\nTIME                              NAME   CAUSE           TYPE        ERROR_NUMBER   LINE MESSAGE                                                                                                 STATUS    ACTION                                                          CON_ID\n----                              ----   -----           ----        ------------   ---- -------                                                                                                 ------    ------                                                          ------\n24-FEB-18 08.35.16.965295000 PM   PDB0   OPTION          ERROR                  0      1 Database option APS mismatch: PDB installed version 12.2.0.1.0. CDB installed version 18.0.0.0.0.       PENDING   Fix the database option in the PDB or the CDB                        1\n24-FEB-18 08.35.16.966343000 PM   PDB0   OPTION          ERROR                  0      2 Database option CATALOG mismatch: PDB installed version 12.2.0.1.0. CDB installed version 18.0.0.0.0.   PENDING   Fix the database option in the PDB or the CDB                        1\n24-FEB-18 08.35.16.966556000 PM   PDB0   OPTION          ERROR                  0      3 Database option CATJAVA mismatch: PDB installed version 12.2.0.1.0. CDB installed version 18.0.0.0.0.   PENDING   Fix the database option in the PDB or the CDB                        1\n24-FEB-18 08.35.16.966780000 PM   PDB0   OPTION          ERROR                  0      4 Database option CATPROC mismatch: PDB installed version 12.2.0.1.0. CDB installed version 18.0.0.0.0.   PENDING   Fix the database option in the PDB or the CDB                        1\n24-FEB-18 08.35.16.966940000 PM   PDB0   OPTION          ERROR                  0      5 Database option CONTEXT mismatch: PDB installed version 12.2.0.1.0. CDB installed version 18.0.0.0.0.   PENDING   Fix the database option in the PDB or the CDB                        1\n24-FEB-18 08.35.16.967096000 PM   PDB0   OPTION          ERROR                  0      6 Database option DV mismatch: PDB installed version 12.2.0.1.0. CDB installed version 18.0.0.0.0.        PENDING   Fix the database option in the PDB or the CDB                        1\n24-FEB-18 08.35.16.967250000 PM   PDB0   OPTION          ERROR                  0      7 Database option JAVAVM mismatch: PDB installed version 12.2.0.1.0. CDB installed version 18.0.0.0.0.    PENDING   Fix the database option in the PDB or the CDB                        1\n24-FEB-18 08.35.16.967403000 PM   PDB0   OPTION          ERROR                  0      8 Database option OLS mismatch: PDB installed version 12.2.0.1.0. CDB installed version 18.0.0.0.0.       PENDING   Fix the database option in the PDB or the CDB                        1\n24-FEB-18 08.35.16.967602000 PM   PDB0   OPTION          ERROR                  0      9 Database option ORDIM mismatch: PDB installed version 12.2.0.1.0. CDB installed version 18.0.0.0.0.     PENDING   Fix the database option in the PDB or the CDB                        1\n24-FEB-18 08.35.16.967785000 PM   PDB0   OPTION          ERROR                  0     10 Database option OWM mismatch: PDB installed version 12.2.0.1.0. CDB installed version 18.0.0.0.0.       PENDING   Fix the database option in the PDB or the CDB                        1\n24-FEB-18 08.35.16.967939000 PM   PDB0   OPTION          ERROR                  0     11 Database option SDO mismatch: PDB installed version 12.2.0.1.0. CDB installed version 18.0.0.0.0.       PENDING   Fix the database option in the PDB or the CDB                        1\n24-FEB-18 08.35.16.968091000 PM   PDB0   OPTION          ERROR                  0     12 Database option XDB mismatch: PDB installed version 12.2.0.1.0. CDB installed version 18.0.0.0.0.       PENDING   Fix the database option in the PDB or the CDB                        1\n24-FEB-18 08.35.16.968246000 PM   PDB0   OPTION          ERROR                  0     13 Database option XML mismatch: PDB installed version 12.2.0.1.0. CDB installed version 18.0.0.0.0.       PENDING   Fix the database option in the PDB or the CDB                        1\n24-FEB-18 08.35.16.968398000 PM   PDB0   OPTION          ERROR                  0     14 Database option XOQ mismatch: PDB installed version 12.2.0.1.0. CDB installed version 18.0.0.0.0.       PENDING   Fix the database option in the PDB or the CDB                        1\n24-FEB-18 08.35.16.971138000 PM   PDB0   Parameter       WARNING                0      1 CDB parameter compatible mismatch: Previous '12.2.0' Current '18.0.0'                                   PENDING   Please check the parameter in the current CDB                        1\n24-FEB-18 08.35.17.115346000 PM   PDB0   VSN not match   ERROR                  0      1 PDB's version does not match CDB's version: PDB's version 12.2.0.1.0. CDB's version 18.0.0.0.0.         PENDING   Either upgrade the PDB or reload the components in the PDB.          4\n<\/code><\/pre>\n
The messages are clear: all components have a 12.2.0.1 dictionary and must be upgraded to a 18.0.0.0.0 one<\/p>\n
The PDB is opened in MIGRATE mode with only RESTRICTED sessions enabled:<\/p>\n
SQL> show pdbs\nSP2-0382: The SHOW PDBS command is not available.\nSQL> pdbs\n \n  CON_ID CON_NAME   OPEN_MODE   RESTRICTED   STATUS     FOREIGN_CDB_DBID   FOREIGN_PDB_ID CREATION_TIME   REFRESH_MODE     REFRESH_INTERVAL   LAST_REFRESH_SCN    CDB_DBID   CURRENT_SCN\n  ------ --------   ---------   ----------   ------     ----------------   -------------- -------------   ------------     ----------------   ----------------    --------   -----------\n       2 PDB$SEED   READ ONLY   NO           NORMAL              1201448                2 11:42:25        NONE                                                   942476327       3958500\n       3 CDB1PDB    MOUNTED                  NORMAL            942476327                2 19:58:55        NONE                                                   942476327       3958500\n       4 PDB0       MIGRATE     YES          NEW               941386968                3 20:34:50        NONE                                                   942476327       3958500\n<\/code><\/pre>\n
Then, here is the upgrade for this newly plugged PDB0:<\/p>\n
\n[oracle@DBaaS18c 18c]$ dbupgrade -c PDB0\n \nArgument list for [\/u01\/app\/oracle\/product\/18.0.0\/dbhome_1\/rdbms\/admin\/catctl.pl]\nRun in                c = PDB0\nDo not run in         C = 0\nInput Directory       d = 0\nEcho OFF              e = 1\nSimulate              E = 0\nForced cleanup        F = 0\nLog Id                i = 0\nChild Process         I = 0\nLog Dir               l = 0\nPriority List Name    L = 0\nUpgrade Mode active   M = 0\nSQL Process Count     n = 0\nSQL PDB Process Count N = 0\nOpen Mode Normal      o = 0\nStart Phase           p = 0\nEnd Phase             P = 0\nReverse Order         r = 0\nAutoUpgrade Resume    R = 0\nScript                s = 0\nSerial Run            S = 0\nRO User Tablespaces   T = 0\nDisplay Phases        y = 0\nDebug catcon.pm       z = 0\nDebug catctl.pl       Z = 0\n \ncatctl.pl VERSION: [18.0.0.0.0]\n           STATUS: [Production]\n            BUILD: [RDBMS_18.1.0.0.0_LINUX.X64_180103.1]\n...<\/code><\/pre>\n
The Build number mentions 18.1 built on 03-JAN-2018<\/p>\n
Look at the summary to see the time it takes:<\/p>\n
Oracle Database Release 18 Post-Upgrade Status Tool    02-24-2018 21:36:5\n                             [PDB0]\n \nComponent                               Current         Full     Elapsed Time\nName                                    Status          Version  HH:MM:SS\n \nOracle Server                          UPGRADED      18.1.0.0.0  00:13:37\nJServer JAVA Virtual Machine           UPGRADED      18.1.0.0.0  00:00:51\nOracle XDK                             UPGRADED      18.1.0.0.0  00:00:21\nOracle Database Java Packages          UPGRADED      18.1.0.0.0  00:00:05\nOLAP Analytic Workspace                UPGRADED      18.1.0.0.0  00:00:11\nOracle Label Security                  UPGRADED      18.1.0.0.0  00:00:03\nOracle Database Vault                  UPGRADED      18.1.0.0.0  00:00:34\nOracle Text                            UPGRADED      18.1.0.0.0  00:00:11\nOracle Workspace Manager               UPGRADED      18.1.0.0.0  00:00:18\nOracle Real Application Clusters       UPGRADED      18.1.0.0.0  00:00:00\nOracle XML Database                    UPGRADED      18.1.0.0.0  00:00:49\nOracle Multimedia                      UPGRADED      18.1.0.0.0  00:01:03\nSpatial                                UPGRADED      18.1.0.0.0  00:02:06\nOracle OLAP API                        UPGRADED      18.1.0.0.0  00:00:08\nUpgrade Datapatch                                                00:00:05\nFinal Actions                                                    00:00:09\nPost Upgrade                                                     00:00:02\nPost Upgrade Datapatch                                           00:00:04\n \nTotal Upgrade Time: 00:20:47 [PDB0]\n \nDatabase time zone version is 26. It is older than current release time\nzone version 31. Time zone upgrade is needed using the DBMS_DST package.\n \nGrand Total Upgrade Time:    [0d:0h:21m:10s]\n<\/code><\/pre>\n
\"Capture18cCDBROOTupg\"<\/a>
\nHere we see 18.1 but the important number is the time: 21 minutes… Once again, I see no improvement in the time to upgrade the PDB dictionary. This was on a service with 2 OCPU and I’ve run a whole CDB upgrade with a similar shape and the time to upgrade the CDB$ROOT is exaclty the same – see the screenshot on the right.<\/p>\n
Finally I open the PDB:<\/p>\n
\nSQL> alter pluggable database pdb0 open;\nPluggable database PDB0 altered.\n<\/code><\/pre>\n
And check that the violations are resolved:<\/p>\n
\nSQL> select * from pdb_plug_in_violations where status'RESOLVED';\n \nTIME                              NAME   CAUSE    TYPE        ERROR_NUMBER   LINE MESSAGE                                                                                       STATUS    ACTION                                            CON_ID\n----                              ----   -----    ----        ------------   ---- -------                                                                                       ------    ------                                            ------\n24-FEB-18 09.46.25.302228000 PM   PDB0   OPTION   WARNING                0     15 Database option RAC mismatch: PDB installed version 18.0.0.0.0. CDB installed version NULL.   PENDING   Fix the database option in the PDB or the CDB          4\n<\/code><\/pre>\n
Ok, I suppose I can ignore that as this is not RAC.<\/p>\n
I’ve not seen a lot of differences in the dbupgrade output. There’s a new summary of versions before and after upgrade, which was not there in 12c:<\/p>\n
DOC>#####################################################\nDOC>#####################################################\nDOC>\nDOC>    DIAG OS Version: linux x86_64-linux-thread-multi 2.6.39-400.211.1.el6uek.x86_64\nDOC>    DIAG Database Instance Name: CDB1\nDOC>    DIAG Database Time Zone Version: 31\nDOC>    DIAG Database Version Before Upgrade: 12.2.0.1.0\nDOC>    DIAG Database Version After Upgrade: 18.1.0.0.0\nDOC>#####################################################\nDOC>#####################################################\n<\/code><\/pre>\n
However, be careful with this information. The OS Version is not correct:<\/p>\n
\n[opc@DB ~]$ uname -a\nLinux DB 4.1.12-112.14.10.el6uek.x86_64 #2 SMP Mon Jan 8 18:24:01 PST 2018 x86_64 x86_64 x86_64 GNU\/Linux\n<\/code><\/pre>\n
It seems that this info comes from Config.pm which is the OS version where the perl binaries were built…<\/p>\n
In summary, nothing changes here about the time it takes to upgrade a PDB when plugged into a new CDB.
\nHowever, in 18c (and maybe only with next Release Updates) we should have a way to get this improved by recording the upgrade of CDB$ROOT and re-playing a trimmed version on the PDB dictionaries, in the same way as in Application Containers for application upgrades. We already see some signs of it with ‘_enable_cdb_upgrade_capture’ undocumented parameter and PDB_UPGRADE_SYNC database property. This may even become automatic when PDB is opened with the PDB_AUTO_UPGRADE property. But that’s for the future, and not yet documented. <\/p>\n
For the moment, you still need to run a full catupgrd on each container, through catctl.pl called by the ‘dbupgrade’ script. Here on a 2 OCPU service, it takes 20 minutes.<\/p>\n","protected":false},"excerpt":{"rendered":"
By Franck Pachot . Oracle 18c is out, in the Oracle Cloud, and the first thing I do with a new version is testing how long it takes to upgrade a previous version PDB by unplug\/plug. Faster upgrade should be the benefit of having a slim dictionary where the system objects are reduced to metadata […]<\/p>\n","protected":false},"author":27,"featured_media":10992,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[59],"tags":[96,1184,1171,219],"type_dbi":[],"class_list":["post-10991","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-oracle","tag-oracle-18c","tag-oracle-19c","tag-upgrade"],"acf":[],"yoast_head":"\nPDB upgrade from 12c to 18c - 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\/pdb-upgrade-from-12c-to-18c\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PDB upgrade from 12c to 18c\" \/>\n<meta property=\"og:description\" content=\"By Franck Pachot . Oracle 18c is out, in the Oracle Cloud, and the first thing I do with a new version is testing how long it takes to upgrade a previous version PDB by unplug\/plug. Faster upgrade should be the benefit of having a slim dictionary where the system objects are reduced to metadata […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/pdb-upgrade-from-12c-to-18c\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-02-25T19:20:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture18cCDBROOTupg.png\" \/>\n\t<meta property=\"og:image:width\" content=\"637\" \/>\n\t<meta property=\"og:image:height\" content=\"397\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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=\"7 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\/pdb-upgrade-from-12c-to-18c\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/pdb-upgrade-from-12c-to-18c\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"PDB upgrade from 12c to 18c\",\"datePublished\":\"2018-02-25T19:20:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/pdb-upgrade-from-12c-to-18c\/\"},\"wordCount\":543,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/pdb-upgrade-from-12c-to-18c\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture18cCDBROOTupg.png\",\"keywords\":[\"Oracle\",\"Oracle 18c\",\"Oracle 19c\",\"Upgrade\"],\"articleSection\":[\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/pdb-upgrade-from-12c-to-18c\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/pdb-upgrade-from-12c-to-18c\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/pdb-upgrade-from-12c-to-18c\/\",\"name\":\"PDB upgrade from 12c to 18c - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/pdb-upgrade-from-12c-to-18c\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/pdb-upgrade-from-12c-to-18c\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture18cCDBROOTupg.png\",\"datePublished\":\"2018-02-25T19:20:04+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/pdb-upgrade-from-12c-to-18c\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/pdb-upgrade-from-12c-to-18c\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/pdb-upgrade-from-12c-to-18c\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture18cCDBROOTupg.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture18cCDBROOTupg.png\",\"width\":637,\"height\":397},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/pdb-upgrade-from-12c-to-18c\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PDB upgrade from 12c to 18c\"}]},{\"@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":"PDB upgrade from 12c to 18c - 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\/pdb-upgrade-from-12c-to-18c\/","og_locale":"en_US","og_type":"article","og_title":"PDB upgrade from 12c to 18c","og_description":"By Franck Pachot . Oracle 18c is out, in the Oracle Cloud, and the first thing I do with a new version is testing how long it takes to upgrade a previous version PDB by unplug\/plug. Faster upgrade should be the benefit of having a slim dictionary where the system objects are reduced to metadata […]","og_url":"https:\/\/www.dbi-services.com\/blog\/pdb-upgrade-from-12c-to-18c\/","og_site_name":"dbi Blog","article_published_time":"2018-02-25T19:20:04+00:00","og_image":[{"width":637,"height":397,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture18cCDBROOTupg.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/pdb-upgrade-from-12c-to-18c\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/pdb-upgrade-from-12c-to-18c\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"PDB upgrade from 12c to 18c","datePublished":"2018-02-25T19:20:04+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/pdb-upgrade-from-12c-to-18c\/"},"wordCount":543,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/pdb-upgrade-from-12c-to-18c\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture18cCDBROOTupg.png","keywords":["Oracle","Oracle 18c","Oracle 19c","Upgrade"],"articleSection":["Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/pdb-upgrade-from-12c-to-18c\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/pdb-upgrade-from-12c-to-18c\/","url":"https:\/\/www.dbi-services.com\/blog\/pdb-upgrade-from-12c-to-18c\/","name":"PDB upgrade from 12c to 18c - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/pdb-upgrade-from-12c-to-18c\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/pdb-upgrade-from-12c-to-18c\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture18cCDBROOTupg.png","datePublished":"2018-02-25T19:20:04+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/pdb-upgrade-from-12c-to-18c\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/pdb-upgrade-from-12c-to-18c\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/pdb-upgrade-from-12c-to-18c\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture18cCDBROOTupg.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Capture18cCDBROOTupg.png","width":637,"height":397},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/pdb-upgrade-from-12c-to-18c\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PDB upgrade from 12c to 18c"}]},{"@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\/10991","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=10991"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/10991\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/10992"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=10991"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=10991"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=10991"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=10991"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}