{"id":4714,"date":"2020-08-27T15:57:40","date_gmt":"2020-08-27T18:57:40","guid":{"rendered":"https:\/\/dev.dbarj.com.br\/?p=4714"},"modified":"2020-08-27T18:20:37","modified_gmt":"2020-08-27T21:20:37","slug":"dbms_pdb-arriving-on-11-2-0-4","status":"publish","type":"post","link":"https:\/\/dev.dbarj.com.br\/en\/2020\/08\/dbms_pdb-arriving-on-11-2-0-4\/","title":{"rendered":"DBMS_PDB arriving on 11.2.0.4!"},"content":{"rendered":"

If you follow my CPU cycle dissect articles<\/a>, you will note that a new package appeared on 11.2.0.4 on the EXA Bundle Patch (still not available with the PSU). DBMS_PDB<\/strong><\/span>!<\/p>\n

Until today, the only way to upgrade 11g to any 12+ PDB using the “plug way” would be following this approach:<\/p>\n

\"Database<\/p>\n

Of course there are many other approaches using expdp, transportable database, etc..<\/p>\n

Checking Mike Dietrich blog post for 12.2 upgrade: https:\/\/mikedietrichde.com\/2019\/07\/24\/database-migration-from-non-cdb-to-pdb-plug-in-upgrade-convert\/<\/a>, we have this picture:<\/p>\n

\"Database<\/p>\n

And he states:<\/p>\n

I can\u2019t do this exercise with my 11.2.0.4 databases, as\u00a0DBMS_PDB.DESCRIBE<\/code> does not exist in this release. And even Oracle 12.1.0.2 does not support the following operation unless I create my CDB with shared UNDO.<\/p><\/blockquote>\n

Well.. not anymore..<\/strong><\/span> =]<\/strong><\/p>\n

So it seems that Oracle is planning to do 11g non-cdb to pdb migratio<\/strong>n using the same flow of the second chart above, doing the upgrade after plugging the 11g on the target database<\/span>.<\/p>\n

Let’s check the DBMS_PDB contents.. describing it:<\/p>\n

\n
[oracle@localhost ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 11.2.0.4.0 Production on Thu Aug 27 12:48:04 2020\r\n\r\nCopyright (c) 1982, 2013, Oracle.  All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production\r\nWith the Partitioning, Oracle Label Security, OLAP, Data Mining\r\nand Real Application Testing options\r\n\r\nSQL> desc DBMS_PDB\r\nPROCEDURE DESCRIBE\r\n Argument Name                  Type                    In\/Out Default?\r\n ------------------------------ ----------------------- ------ --------\r\n DIRNAME                        VARCHAR2                IN\r\n FILENAME                       VARCHAR2                IN\r\nFUNCTION GETRELEASELEVEL RETURNS NUMBER\r\n\r\nSQL><\/pre>\n<\/div>\n
Reading SYS.DBMS_PDB<\/strong> package code:<\/p>\n
0a1,19\r\n> package dbms_pdb authid current_user is\r\n>   --\r\n>   --  PROCEDURES AND FUNCTIONS\r\n>   --\r\n>   procedure describe(dirName IN VARCHAR2, fileName IN VARCHAR2);\r\n>   -- Generate an XML file which describes tablespaces and datafiles that\r\n>   --  belong to the non-CDB\r\n>   --  Input arguments:\r\n>   --    dirName  - Directory location of file to be created. This string is a\r\n>   --               directory object name and must be specified in upper case.\r\n>   --               User invoking this procedure must have READ and WRITE\r\n>   --               privileges on this directory\r\n>   --    fileName - name of the XML file which will contain description of the\r\n>   --               non-CDB\r\n> \r\n>   -- this function returns a numeric representation of \"compatible\" parameter\r\n>   function getReleaseLevel return NUMBER;\r\n> end;\r\n> \r\n<\/pre>\n
Let’s see if it works..<\/h3>\n
So there is nothing (yet) documented about how to use it for a 11g.. maybe this package shouldn’t even be called by us (users) but by the AutoUpgrade tool or something.<\/p>\n
But since I’m an adventurer, let’s see what I can do or how far I can go with it..<\/p>\n
First calling the DESCRIBE procedure to create the xml file.<\/p>\n
\n
SQL> shutdown immediate;\r\nDatabase closed.\r\nDatabase dismounted.\r\nORACLE instance shut down.\r\n\r\nSQL> startup open read only;\r\nORACLE instance started.\r\n\r\nTotal System Global Area  835104768 bytes\r\nFixed Size\t\t    2257840 bytes\r\nVariable Size\t\t  553651280 bytes\r\nDatabase Buffers\t  272629760 bytes\r\nRedo Buffers\t\t    6565888 bytes\r\nDatabase mounted.\r\nDatabase opened.\r\n\r\nSQL> create directory PDB_DIR as '\/external\/11g\/';\r\n\r\nDirectory created.\r\n\r\nSQL> BEGIN\r\n  2    DBMS_PDB.DESCRIBE(\r\n  3      DIRNAME => 'PDB_DIR',\r\n  4      FILENAME => 'db11g.xml');\r\n  5  END;\r\n  6  \/\r\n\r\nPL\/SQL procedure successfully completed.\r\n\r\n<\/pre>\n
Checking the file contents.<\/p>\n
<?xml version=\"1.0\"?>\r\n<PDB>\r\n  <xmlversion>1<\/xmlversion>\r\n  <pdbname>orcl<\/pdbname>\r\n  <cid>0<\/cid>\r\n  <byteorder>1<\/byteorder>\r\n  <vsn>186647552<\/vsn>\r\n  <vsns>\r\n    <vsnnum>11.2.0.4.0<\/vsnnum>\r\n    <cdbcompt>11.2.0.4.0<\/cdbcompt>\r\n    <pdbcompt>11.2.0.4.0<\/pdbcompt>\r\n    <vsnlibnum>0.0.0.0.22<\/vsnlibnum>\r\n    <vsnsql>22<\/vsnsql>\r\n    <vsnbsv>8.0.0.0.0<\/vsnbsv>\r\n  <\/vsns>\r\n  <dbid>1456375571<\/dbid>\r\n  <ncdb2pdb>1<\/ncdb2pdb>\r\n  <cdbid>1456375571<\/cdbid>\r\n  <guid>ADDFB4D44D5938EFE055000000000001<\/guid>\r\n  <uscnbas>1131194<\/uscnbas>\r\n  <uscnwrp>0<\/uscnwrp>\r\n  <undoscn>7<\/undoscn>\r\n  <rdba>4194824<\/rdba>\r\n  <tablespace>\r\n    <name>SYSTEM<\/name>\r\n    <type>0<\/type>\r\n    <tsn>0<\/tsn>\r\n    <status>1<\/status>\r\n    <issft>0<\/issft>\r\n    <isnft>0<\/isnft>\r\n    <encts>0<\/encts>\r\n    <flags>0<\/flags>\r\n    <bmunitsize>8<\/bmunitsize>\r\n    <file>\r\n      <path>\/u01\/app\/oracle\/oradata\/orcl\/system01.dbf<\/path>\r\n      <afn>1<\/afn>\r\n      <rfn>1<\/rfn>\r\n      <createscnbas>7<\/createscnbas>\r\n      <createscnwrp>0<\/createscnwrp>\r\n      <status>1<\/status>\r\n      <fileblocks>101120<\/fileblocks>\r\n      <blocksize>8192<\/blocksize>\r\n      <vsn>186647552<\/vsn>\r\n      <fdbid>1456375571<\/fdbid>\r\n      <fcpsb>1131193<\/fcpsb>\r\n      <fcpsw>0<\/fcpsw>\r\n      <frlsb>925702<\/frlsb>\r\n      <frlsw>0<\/frlsw>\r\n      <frlt>928594837<\/frlt>\r\n      <autoext>1<\/autoext>\r\n      <maxsize>4194302<\/maxsize>\r\n      <incsize>1280<\/incsize>\r\n      <plugscn>0<\/plugscn>\r\n      <plugafn>0<\/plugafn>\r\n      <plugdbid>0<\/plugdbid>\r\n    <\/file>\r\n  <\/tablespace>\r\n  <tablespace>\r\n    <name>SYSAUX<\/name>\r\n    <type>0<\/type>\r\n    <tsn>1<\/tsn>\r\n    <status>1<\/status>\r\n    <issft>0<\/issft>\r\n    <isnft>0<\/isnft>\r\n    <encts>0<\/encts>\r\n    <flags>0<\/flags>\r\n    <bmunitsize>8<\/bmunitsize>\r\n    <file>\r\n      <path>\/u01\/app\/oracle\/oradata\/orcl\/sysaux01.dbf<\/path>\r\n      <afn>2<\/afn>\r\n      <rfn>2<\/rfn>\r\n      <createscnbas>1834<\/createscnbas>\r\n      <createscnwrp>0<\/createscnwrp>\r\n      <status>1<\/status>\r\n      <fileblocks>65280<\/fileblocks>\r\n      <blocksize>8192<\/blocksize>\r\n      <vsn>186647552<\/vsn>\r\n      <fdbid>1456375571<\/fdbid>\r\n      <fcpsb>1131193<\/fcpsb>\r\n      <fcpsw>0<\/fcpsw>\r\n      <frlsb>925702<\/frlsb>\r\n      <frlsw>0<\/frlsw>\r\n      <frlt>928594837<\/frlt>\r\n      <autoext>1<\/autoext>\r\n      <maxsize>4194302<\/maxsize>\r\n      <incsize>1280<\/incsize>\r\n      <plugscn>0<\/plugscn>\r\n      <plugafn>0<\/plugafn>\r\n      <plugdbid>0<\/plugdbid>\r\n    <\/file>\r\n  <\/tablespace>\r\n  <tablespace>\r\n    <name>UNDOTBS1<\/name>\r\n    <type>2<\/type>\r\n    <tsn>2<\/tsn>\r\n    <status>1<\/status>\r\n    <issft>0<\/issft>\r\n    <isnft>0<\/isnft>\r\n    <encts>0<\/encts>\r\n    <flags>0<\/flags>\r\n    <bmunitsize>8<\/bmunitsize>\r\n    <file>\r\n      <path>\/u01\/app\/oracle\/oradata\/orcl\/undotbs01.dbf<\/path>\r\n      <afn>3<\/afn>\r\n      <rfn>3<\/rfn>\r\n      <createscnbas>923328<\/createscnbas>\r\n      <createscnwrp>0<\/createscnwrp>\r\n      <status>1<\/status>\r\n      <fileblocks>8960<\/fileblocks>\r\n      <blocksize>8192<\/blocksize>\r\n      <vsn>186647552<\/vsn>\r\n      <fdbid>1456375571<\/fdbid>\r\n      <fcpsb>1131193<\/fcpsb>\r\n      <fcpsw>0<\/fcpsw>\r\n      <frlsb>925702<\/frlsb>\r\n      <frlsw>0<\/frlsw>\r\n      <frlt>928594837<\/frlt>\r\n      <autoext>1<\/autoext>\r\n      <maxsize>4194302<\/maxsize>\r\n      <incsize>640<\/incsize>\r\n      <plugscn>0<\/plugscn>\r\n      <plugafn>0<\/plugafn>\r\n      <plugdbid>0<\/plugdbid>\r\n    <\/file>\r\n  <\/tablespace>\r\n  <tablespace>\r\n    <name>TEMP<\/name>\r\n    <type>1<\/type>\r\n    <tsn>3<\/tsn>\r\n    <status>1<\/status>\r\n    <issft>0<\/issft>\r\n    <isnft>0<\/isnft>\r\n    <encts>0<\/encts>\r\n    <flags>0<\/flags>\r\n    <bmunitsize>128<\/bmunitsize>\r\n    <file>\r\n      <path>\/u01\/app\/oracle\/oradata\/orcl\/temp01.dbf<\/path>\r\n      <afn>1<\/afn>\r\n      <rfn>1<\/rfn>\r\n      <createscnbas>925786<\/createscnbas>\r\n      <createscnwrp>0<\/createscnwrp>\r\n      <status>1<\/status>\r\n      <fileblocks>9472<\/fileblocks>\r\n      <blocksize>8192<\/blocksize>\r\n      <vsn>186647552<\/vsn>\r\n      <autoext>1<\/autoext>\r\n      <maxsize>4194302<\/maxsize>\r\n      <incsize>80<\/incsize>\r\n      <plugscn>0<\/plugscn>\r\n      <plugafn>0<\/plugafn>\r\n      <plugdbid>0<\/plugdbid>\r\n    <\/file>\r\n  <\/tablespace>\r\n  <tablespace>\r\n    <name>USERS<\/name>\r\n    <type>0<\/type>\r\n    <tsn>4<\/tsn>\r\n    <status>1<\/status>\r\n    <issft>0<\/issft>\r\n    <isnft>0<\/isnft>\r\n    <encts>0<\/encts>\r\n    <flags>0<\/flags>\r\n    <bmunitsize>8<\/bmunitsize>\r\n    <file>\r\n      <path>\/u01\/app\/oracle\/oradata\/orcl\/users01.dbf<\/path>\r\n      <afn>4<\/afn>\r\n      <rfn>4<\/rfn>\r\n      <createscnbas>16143<\/createscnbas>\r\n      <createscnwrp>0<\/createscnwrp>\r\n      <status>1<\/status>\r\n      <fileblocks>8320<\/fileblocks>\r\n      <blocksize>8192<\/blocksize>\r\n      <vsn>186647552<\/vsn>\r\n      <fdbid>1456375571<\/fdbid>\r\n      <fcpsb>1131193<\/fcpsb>\r\n      <fcpsw>0<\/fcpsw>\r\n      <frlsb>925702<\/frlsb>\r\n      <frlsw>0<\/frlsw>\r\n      <frlt>928594837<\/frlt>\r\n      <autoext>1<\/autoext>\r\n      <maxsize>4194302<\/maxsize>\r\n      <incsize>160<\/incsize>\r\n      <plugscn>0<\/plugscn>\r\n      <plugafn>0<\/plugafn>\r\n      <plugdbid>0<\/plugdbid>\r\n    <\/file>\r\n  <\/tablespace>\r\n  <recover>0<\/recover>\r\n  <optional>\r\n    <ncdb2pdb>1<\/ncdb2pdb>\r\n    <csid>178<\/csid>\r\n    <ncsid>2000<\/ncsid>\r\n    <options>\r\n      <option>AMD=11.2.0.4.0<\/option>\r\n      <option>APS=11.2.0.4.0<\/option>\r\n      <option>CATALOG=11.2.0.4.0<\/option>\r\n      <option>CATJAVA=11.2.0.4.0<\/option>\r\n      <option>CATPROC=11.2.0.4.0<\/option>\r\n      <option>CONTEXT=11.2.0.4.0<\/option>\r\n      <option>DV=11.2.0.4.0<\/option>\r\n      <option>EM=11.2.0.4.0<\/option>\r\n      <option>JAVAVM=11.2.0.4.0<\/option>\r\n      <option>OLS=11.2.0.4.0<\/option>\r\n      <option>ORDIM=11.2.0.4.0<\/option>\r\n      <option>OWM=11.2.0.4.0<\/option>\r\n      <option>RAC=11.2.0.4.0<\/option>\r\n      <option>SDO=11.2.0.4.0<\/option>\r\n      <option>XDB=11.2.0.4.0<\/option>\r\n      <option>XML=11.2.0.4.0<\/option>\r\n      <option>XOQ=11.2.0.4.0<\/option>\r\n    <\/options>\r\n    <dv>0<\/dv>\r\n    <APEX>3.2.1.00.12:0<\/APEX>\r\n    <parameters>\r\n      <parameter>processes=150<\/parameter>\r\n      <parameter>memory_target=838860800<\/parameter>\r\n      <parameter>db_block_size=8192<\/parameter>\r\n      <parameter>compatible=&apos;11.2.0.4.0&apos;<\/parameter>\r\n      <parameter>recyclebin=&apos;OFF&apos;<\/parameter>\r\n      <parameter>os_roles=FALSE<\/parameter>\r\n      <parameter>open_cursors=300<\/parameter>\r\n      <parameter>sql92_security=TRUE<\/parameter>\r\n    <\/parameters>\r\n    <sqlpatches\/>\r\n    <tzvers>\r\n      <tzver>primary version:14<\/tzver>\r\n      <tzver>secondary version:0<\/tzver>\r\n    <\/tzvers>\r\n    <walletkey>0<\/walletkey>\r\n    <services>\r\n      <service>SYS$BACKGROUND<\/service>\r\n      <service>SYS$USERS<\/service>\r\n      <service>seeddataXDB<\/service>\r\n      <service>seeddata<\/service>\r\n      <service>orclXDB<\/service>\r\n      <service>orcl<\/service>\r\n    <\/services>\r\n    <opatches\/>\r\n    <hasclob>1<\/hasclob>\r\n    <awr\/>\r\n    <hardvsnchk>0<\/hardvsnchk>\r\n    <localundo>1<\/localundo>\r\n    <apps\/>\r\n    <dbedition>0<\/dbedition>\r\n    <dvopsctl>2<\/dvopsctl>\r\n    <clnupsrcpal>1<\/clnupsrcpal>\r\n  <\/optional>\r\n<\/PDB>\r\n<\/pre>\n
Now trying to import on the target environment:<\/p>\n
SQL> CREATE PLUGGABLE DATABASE ora11g USING '\/external\/11g\/db11g.xml'\r\n  2   COPY\r\n  3   FILE_NAME_CONVERT = ('\/external\/11g\/', '\/u01\/app\/oracle\/oradata\/ORCL\/ora11g\/');\r\nCREATE PLUGGABLE DATABASE ora11g USING '\/external\/11g\/db11g.xml'\r\n*\r\nERROR at line 1:\r\nORA-65346: The PDB version is lower and components (AMD, EM) are missing in CDB.<\/pre>\n
Damn it! Requirement errors..<\/p>\n
As I’m a bit lazy today and this is a lab environment,\u00a0 I will simply remove the entries from .xml to try again:<\/p>\n
\"\"<\/p>\n
Now running it again:<\/p>\n
SQL> CREATE PLUGGABLE DATABASE ora11g USING '\/external\/11g\/db11g.xml'\r\n  2   COPY\r\n  3   FILE_NAME_CONVERT = ('\/external\/11g\/', '\/u01\/app\/oracle\/oradata\/ORCL\/ora11g\/');\r\n\r\nPluggable database created.\r\n<\/pre>\n
We have the PDB!<\/p>\n
SQL> show pdbs\r\n\r\n    CON_ID CON_NAME                       OPEN MODE  RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n         2 PDB$SEED                       READ ONLY  NO\r\n         3 PDB01                          READ WRITE NO\r\n         4 ORA11G                         MOUNTED<\/pre>\n
Now let’s try to convert the noncdb to pdb<\/strong><\/span>!<\/p>\n
SQL> set timing on\r\nSQL> set serverout on\r\nSQL> set echo on\r\nSQL> set termout on\r\nSQL> spool \/external\/11g\/db11g_noncdbtopdb.log\r\nSQL> start ?\/rdbms\/admin\/noncdb_to_pdb.sql<\/pre>\n
And it fails with:<\/p>\n
13:32:48 SQL> alter pluggable database \"&pdbname\" open upgrade;\r\nalter pluggable database \"ORA11G\" open upgrade\r\n*\r\nERROR at line 1:\r\nORA-00604: error occurred at recursive SQL level 1\r\nORA-00942: table or view does not exist\r\n<\/pre>\n
As I couldn’t find the offending SQL, I’ve just enabled events ‘942 trace name ERRORSTACK level 3’<\/strong><\/em> and tried again. Then on the logs I got:<\/p>\n
...\r\nabout to signal 942\r\nName: CDB_FILE$\r\n...\r\n----- Current SQL Statement for this session (sql_id=azbb7v8wa64x9) -----\r\ndelete from cdb_file$\r\n...<\/pre>\n
The new PDB needs to be upgraded at first.. let me try the dbupdate utily..<\/p>\n
[oracle@localhost 11g]$ dbupgrade -l \/media\/sf_Patch\/11g\/logs -c \"ORA11G\"\r\n\r\nArgument list for [\/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\/rdbms\/admin\/catctl.pl]\r\nFor Oracle internal use only A = 0\r\nRun in                       c = ORA11G\r\nDo not run in                C = 0\r\nInput Directory              d = 0\r\nEcho OFF                     e = 1\r\nSimulate                     E = 0\r\nForced cleanup               F = 0\r\nLog Id                       i = 0\r\nChild Process                I = 0\r\nLog Dir                      l = \/media\/sf_Patch\/11g\/logs\r\nPriority List Name           L = 0\r\nUpgrade Mode active          M = 0\r\nSQL Process Count            n = 0\r\nSQL PDB Process Count        N = 0\r\nOpen Mode Normal             o = 0\r\nStart Phase                  p = 0\r\nEnd Phase                    P = 0\r\nReverse Order                r = 0\r\nAutoUpgrade Resume           R = 0\r\nScript                       s = 0\r\nSerial Run                   S = 0\r\nRO User Tablespaces          T = 0\r\nDisplay Phases               y = 0\r\nDebug catcon.pm              z = 0\r\nDebug catctl.pl              Z = 0\r\n\r\ncatctl.pl VERSION: [19.0.0.0.0]\r\n           STATUS: [Production]\r\n            BUILD: [RDBMS_19.8.0.0.0DBRU_LINUX.X64_200702]\r\n\r\n\r\n\/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\/rdbms\/admin\/orahome = [\/u01\/app\/oracle\/product\/19.0.0\/dbhome_1]\r\n\/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\/bin\/orabasehome = [\/u01\/app\/oracle\/homes\/OraDB19Home1]\r\ncatctlGetOraBaseLogDir = [\/u01\/app\/oracle\/homes\/OraDB19Home1]\r\n\r\nAnalyzing file \/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\/rdbms\/admin\/catupgrd.sql\r\n\r\nLog file directory = [\/media\/sf_Patch\/11g\/logs]\r\n\r\ncatcon::set_log_file_base_path: ALL catcon-related output will be written to [\/media\/sf_Patch\/11g\/logs\/catupgrd_catcon_27217.lst]\r\n\r\ncatcon::set_log_file_base_path: catcon: See [\/media\/sf_Patch\/11g\/logs\/catupgrd*.log] files for output generated by scripts\r\n\r\ncatcon::set_log_file_base_path: catcon: See [\/media\/sf_Patch\/11g\/logs\/catupgrd_*.lst] files for spool files, if any\r\n\r\n\r\nNumber of Cpus        = 4\r\nDatabase Name         = orcl\r\nDataBase Version      = 19.0.0.0.0\r\nParallel SQL Process Count (PDB)      = 2\r\nParallel SQL Process Count (CDB$ROOT) = 4\r\nConcurrent PDB Upgrades               = 2\r\nGenerated PDB Inclusion:[ORA11G]\r\nCDB$ROOT  Open Mode = [OPEN]\r\nConcurrent PDB Upgrades Reset           = 1\r\nDataBase Version      = 19.0.0.0.0\r\n\r\nStart processing of PDBs (ORA11G)\r\n[\/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\/perl\/bin\/perl \/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\/rdbms\/admin\/catctl.pl -l \/media\/sf_Patch\/11g\/logs -c 'ORA11G' -I -i ora11g -n 2 \/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\/rdbms\/admin\/catupgrd.sql]\r\n\r\nArgument list for [\/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\/rdbms\/admin\/catctl.pl]\r\nFor Oracle internal use only A = 0\r\nRun in                       c = ORA11G\r\nDo not run in                C = 0\r\nInput Directory              d = 0\r\nEcho OFF                     e = 1\r\nSimulate                     E = 0\r\nForced cleanup               F = 0\r\nLog Id                       i = ora11g\r\nChild Process                I = 1\r\nLog Dir                      l = \/media\/sf_Patch\/11g\/logs\r\nPriority List Name           L = 0\r\nUpgrade Mode active          M = 0\r\nSQL Process Count            n = 2\r\nSQL PDB Process Count        N = 0\r\nOpen Mode Normal             o = 0\r\nStart Phase                  p = 0\r\nEnd Phase                    P = 0\r\nReverse Order                r = 0\r\nAutoUpgrade Resume           R = 0\r\nScript                       s = 0\r\nSerial Run                   S = 0\r\nRO User Tablespaces          T = 0\r\nDisplay Phases               y = 0\r\nDebug catcon.pm              z = 0\r\nDebug catctl.pl              Z = 0\r\n\r\ncatctl.pl VERSION: [19.0.0.0.0]\r\n           STATUS: [Production]\r\n            BUILD: [RDBMS_19.8.0.0.0DBRU_LINUX.X64_200702]\r\n\r\n\r\n\/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\/rdbms\/admin\/orahome = [\/u01\/app\/oracle\/product\/19.0.0\/dbhome_1]\r\n\/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\/bin\/orabasehome = [\/u01\/app\/oracle\/homes\/OraDB19Home1]\r\ncatctlGetOraBaseLogDir = [\/u01\/app\/oracle\/homes\/OraDB19Home1]\r\n\r\nAnalyzing file \/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\/rdbms\/admin\/catupgrd.sql\r\n\r\nLog file directory = [\/media\/sf_Patch\/11g\/logs]\r\n\r\ncatcon::set_log_file_base_path: ALL catcon-related output will be written to [\/media\/sf_Patch\/11g\/logs\/catupgrdora11g_catcon_27516.lst]\r\n\r\ncatcon::set_log_file_base_path: catcon: See [\/media\/sf_Patch\/11g\/logs\/catupgrdora11g*.log] files for output generated by scripts\r\n\r\ncatcon::set_log_file_base_path: catcon: See [\/media\/sf_Patch\/11g\/logs\/catupgrdora11g_*.lst] files for spool files, if any\r\n\r\n\r\nNumber of Cpus        = 4\r\nDatabase Name         = orcl\r\nDataBase Version      = 19.0.0.0.0\r\nORA11G Open Mode = [MOUNTED]\r\nGenerated PDB Inclusion:[ORA11G]\r\nCDB$ROOT  Open Mode = [OPEN]\r\nComponents in [ORA11G]\r\n    Installed [None]\r\nNot Installed [APEX APS CATALOG CATJAVA CATPROC CONTEXT DV EM JAVAVM MGW ODM OLS ORDIM OWM RAC SDO WK XDB XML XOQ]\r\nDataBase Version      = 19.0.0.0.0\r\ncatcon::exec_reset_pdb_mode_stmts: error reported while attempting to reset PDB modes:\r\n\r\ncatcon::exec_reset_pdb_mode_stmts:   output produced by ALTER PDB statements:\r\n\r\ncatcon::exec_reset_pdb_mode_stmts:\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \tSQL*Plus: Release 19.0.0.0.0 - Production on Thu Aug 27 16:51:34 2020\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \tVersion 19.8.0.0.0\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts:\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \tCopyright (c) 1982, 2020, Oracle.  All rights reserved.\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts:\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \tSQL> set newpage 1#LF#\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \tset pagesize 14#LF#\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \tconnect \/ AS sysdba#LF#\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \tConnected.\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \talter session set \"_oracle_script\"=TRUE#LF#\/#LF#\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts:\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \tSession altered.\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts:\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \talter pluggable database \"ORA11G\" open UPGRADE services=NONE#LF#\/#LF#\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \talter pluggable database \"ORA11G\" open UPGRADE services=NONE\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \t*\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \tERROR at line 1:\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \tORA-00604: error occurred at recursive SQL level 1\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \tORA-00942: table or view does not exist\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts:\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts:\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \tSQL> SQL>\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \tSQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \tVersion 19.8.0.0.0\r\n\r\n\r\ncatcon::reset_pdb_modes: some ALTER PDB OPEN <one or more PDBs>\r\n    statements executed by exec_reset_pdb_mode_stmts resulted in errors.\r\n    Will try to execute ALTER PDB OPEN <PDB> statements for all PDBs\r\n    that are still not open in the requested mode\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: error reported while attempting to reset PDB modes:\r\n\r\ncatcon::exec_reset_pdb_mode_stmts:   output produced by ALTER PDB statements:\r\n\r\ncatcon::exec_reset_pdb_mode_stmts:\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \tSQL*Plus: Release 19.0.0.0.0 - Production on Thu Aug 27 16:51:39 2020\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \tVersion 19.8.0.0.0\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts:\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \tCopyright (c) 1982, 2020, Oracle.  All rights reserved.\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts:\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \tSQL> set newpage 1#LF#\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \tset pagesize 14#LF#\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \tconnect \/ AS sysdba#LF#\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \tConnected.\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \talter session set \"_oracle_script\"=TRUE#LF#\/#LF#\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts:\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \tSession altered.\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts:\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \talter pluggable database \"ORA11G\" open UPGRADE services=NONE#LF#\/#LF#\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \talter pluggable database \"ORA11G\" open UPGRADE services=NONE\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \t*\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \tERROR at line 1:\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \tORA-00604: error occurred at recursive SQL level 1\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \tORA-00942: table or view does not exist\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts:\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts:\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \tSQL> SQL>\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \tSQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\r\n\r\n\r\ncatcon::exec_reset_pdb_mode_stmts: \tVersion 19.8.0.0.0\r\n\r\n\r\ncatcon::reset_pdb_modes: some ALTER PDB statements executed by exec_reset_pdb_mode_stmts resulted in errors\r\n\r\ncatcon::force_pdb_modes: PDB ORA11G will not be processed because it could not be opened in\r\n    requested mode (UPGRADE) on the instance orcl.\r\n    It will be added to the list of PDBs which will be ignored\r\n\r\n\r\n\r\n------------------------------------------------------\r\nPhases [0-107]         Start Time:[2020_08_27 16:51:45]\r\nContainer Lists Inclusion:[ORA11G] Exclusion:[NONE]\r\n------------------------------------------------------\r\n***********   Executing Change Scripts   ***********\r\nSerial   Phase #:0    [ORA11G] Files:1 catcon::validate_con_names: ORA11G is not open\r\n\r\ncatcon::catconQuery: ORA11G does not refer to an existing and open PDB\r\n\r\nUse of uninitialized value in concatenation (.) or string at \/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\/rdbms\/admin\/catctl.pl line 5797.\r\ncatcon::catconExec: start executing scripts\/SQL statements\r\n\r\ncatcon::catconExec: \tScript names\/SQL statements:\r\n\r\ncatcon::catconExec: \t\t@catupstr.sql\r\n\r\ncatcon::catconExec: \tSingleThreaded        = 1\r\n\r\ncatcon::catconExec: \tRootOnly              = 0\r\n\r\ncatcon::catconExec: \tIssuePerProcStmts     = 0\r\n\r\ncatcon::catconExec: \tConNamesIncl          = ORA11G\r\n\r\ncatcon::catconExec: \tConNamesExcl            undefined\r\n\r\ncatcon::catconExec: \tCustomErrLoggingIdent   undefined\r\n\r\ncatcon::catconExec: \tskipProcQuery   undefined\r\n\r\ncatcon::catconExec: \t(2020-08-27 16:51:46)\r\n\r\ncatcon::catconExec: Container names specified for a non-CDB\r\n\r\n\r\n\r\nUnexpected error encountered in catconExec; exiting\r\n No child processes\r\n\r\nUnexpected error encountered in catctlMain; Error Stack Below; exiting\r\nDied at \/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\/rdbms\/admin\/catctl.pl line 9188.\r\n at \/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\/rdbms\/admin\/catctl.pl line 9188.\r\n\tmain::catctlDie(\"\\x{a}Unexpected error encountered in catconExec; exiting\\x{a} No chil\"...) called at \/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\/rdbms\/admin\/catctl.pl line 5650\r\n\tmain::catctlExecutePhaseFiles(0, 1, \"ORA11G\", \"\", undef) called at \/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\/rdbms\/admin\/catctl.pl line 2035\r\n\tmain::catctlRunPhase(0, 1, \"ORA11G\", \"\", undef) called at \/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\/rdbms\/admin\/catctl.pl line 2197\r\n\tmain::catctlRunPhases(0, 108, 108, \"ORA11G\", \"\", undef) called at \/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\/rdbms\/admin\/catctl.pl line 2816\r\n\tmain::catctlRunMainPhases() called at \/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\/rdbms\/admin\/catctl.pl line 1463\r\n\tmain::catctlMain() called at \/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\/rdbms\/admin\/catctl.pl line 1370\r\n\teval {...} called at \/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\/rdbms\/admin\/catctl.pl line 1368\r\n\r\n------------------------------------------------------\r\nCATCTL FATAL ERROR\r\n------------------------------------------------------\r\n\r\n LOG FILES: (\/media\/sf_Patch\/11g\/logs\/catupgrdora11g*.log)\r\nTRACE FILE: (\/media\/sf_Patch\/11g\/logs\/catupgrdora11g_trace.log)\r\n\r\ncatcon: See [\/media\/sf_Patch\/11g\/logs\/catupgrdora11g*.log] files for output generated by scripts\r\n\r\ncatcon: See [\/media\/sf_Patch\/11g\/logs\/catupgrdora11g_*.lst] files for spool files, if any\r\n\r\n\r\n!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!\r\n\r\ncatcon version: \/st_rdbms_19\/16\r\n\tcatconInit2: start logging catcon output at 2020-08-27 16:50:47\r\n\r\n!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!\r\n\r\n\r\n\r\n(...)\r\n\r\nGrand Total Time: 0s [ORA11G]\r\n\r\n LOG FILES: (\/media\/sf_Patch\/11g\/logs\/catupgrdora11g*.log)\r\ncatcon::catconWrapUp: (PID=27516) about to free up all resources\r\n\r\ncatcon::end_processes: will end processes 0 to 1\r\n\r\ncatcon::end_processes: check if process 0 (id=27683) is alive\r\n\r\ncatcon::end_processes: process 0 (id=27683) is alive\r\n\r\ncatcon::end_processes: write EXIT to process 0 (id=27683)\r\n\r\ncatcon::end_processes: close file handle for process 0 (id=27683)\r\n\r\n\r\ncatcon::end_processes: setting FileHandle[0] to undef\r\n\r\ncatcon::end_processes: check if process 1 (id=27684) is alive\r\n\r\ncatcon::end_processes: process 1 (id=27684) is alive\r\n\r\ncatcon::end_processes: write EXIT to process 1 (id=27684)\r\n\r\ncatcon::end_processes: close file handle for process 1 (id=27684)\r\n\r\n\r\ncatcon::end_processes: setting FileHandle[1] to undef\r\n\r\ncatcon::end_processes: done with processes 0 to 1\r\n\r\ncatcon::clean_up_compl_files: FileNameBase = \/media\/sf_Patch\/11g\/logs\/catupgrdora11g, FirstProc =0, LastProc = 1\r\n\r\ncatcon::clean_up_compl_files: call sureunlink to remove \/media\/sf_Patch\/11g\/logs\/catupgrdora11g_catcon_27683.done\r\n\r\ncatcon::sureunlink: unlink(\/media\/sf_Patch\/11g\/logs\/catupgrdora11g_catcon_27683.done) succeeded after 1 attempt(s)\r\n\r\ncatcon::sureunlink: verify that the file really no longer exists\r\n\r\ncatcon::sureunlink: confirmed that \/media\/sf_Patch\/11g\/logs\/catupgrdora11g_catcon_27683.done no longer exists after 1 attempts\r\n\r\ncatcon::clean_up_compl_files: removed \/media\/sf_Patch\/11g\/logs\/catupgrdora11g_catcon_27683.done\r\n\r\ncatcon::clean_up_compl_files: call sureunlink to remove \/media\/sf_Patch\/11g\/logs\/catupgrdora11g_catcon_27684.done\r\n\r\ncatcon::sureunlink: unlink(\/media\/sf_Patch\/11g\/logs\/catupgrdora11g_catcon_27684.done) succeeded after 1 attempt(s)\r\n\r\ncatcon::sureunlink: verify that the file really no longer exists\r\n\r\ncatcon::sureunlink: confirmed that \/media\/sf_Patch\/11g\/logs\/catupgrdora11g_catcon_27684.done no longer exists after 1 attempts\r\n\r\ncatcon::clean_up_compl_files: removed \/media\/sf_Patch\/11g\/logs\/catupgrdora11g_catcon_27684.done\r\n\r\ncatcon::end_processes: ended processes 0 to 1\r\n\r\ncatcon::delete_idle_logs: Deleting log file \/media\/sf_Patch\/11g\/logs\/catupgrdora11g1.log because SQL*Plus process for which\r\n  it was created did no work\r\n\r\n\r\ncatcon::sureunlink: unlink(\/media\/sf_Patch\/11g\/logs\/catupgrdora11g1.log) succeeded after 1 attempt(s)\r\n\r\ncatcon::sureunlink: verify that the file really no longer exists\r\n\r\ncatcon::sureunlink: confirmed that \/media\/sf_Patch\/11g\/logs\/catupgrdora11g1.log no longer exists after 1 attempts\r\n\r\ncatcon::sureunlink: unlink(\/media\/sf_Patch\/11g\/logs\/catupgrdora11g_catcon_kill_sess_27516_ALL.sql) succeeded after 1 attempt(s)\r\n\r\ncatcon::sureunlink: verify that the file really no longer exists\r\n\r\ncatcon::sureunlink: confirmed that \/media\/sf_Patch\/11g\/logs\/catupgrdora11g_catcon_kill_sess_27516_ALL.sql no longer exists after 1 attempts\r\n\r\ncatcon::catconWrapUp: done\r\n\r\n\r\n     Time: 108s For PDB(s)\r\n\r\nGrand Total Time: 108s\r\n\r\n LOG FILES: (\/media\/sf_Patch\/11g\/logs\/catupgrd*.log)\r\n\r\nPdb Upgrades With Errors\r\n------------------------------------------------------\r\nError In [ORA11G] Status is [1] Check Log Files\r\n    [\/media\/sf_Patch\/11g\/logs\/catupgrdora11g*.log]\r\n<\/pre>\n
And the same error again when running: alter pluggable database “ORA11G” open UPGRADE services=NONE<\/strong><\/em><\/span><\/p>\n
As I said, probably this is still something Oracle is working on and is not fully developed..<\/p>\n
As there are probably thousands of customers still using 11.2.0.4, having a simpler way to upgrade to latest 19c will be amazing! So, nothing I can do right now.. even though 11.2 is being “prepared” to export, seems my 19.8 is not prepared to plug it.<\/p>\n
That’s it! Let’s see what is coming on the next months.<\/p>\nHave you enjoyed? Please leave a comment or give a ?!<\/b>\n<\/div>\n
Continue reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-4714","post","type-post","status-publish","format-standard","hentry","category-database-en","item-wrap"],"yoast_head":"\nDBMS_PDB arriving on 11.2.0.4! - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/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:\/\/dev.dbarj.com.br\/en\/2020\/08\/dbms_pdb-arriving-on-11-2-0-4\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DBA RJ\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"22 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2020\\\/08\\\/dbms_pdb-arriving-on-11-2-0-4\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2020\\\/08\\\/dbms_pdb-arriving-on-11-2-0-4\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"DBMS_PDB arriving on 11.2.0.4!\",\"datePublished\":\"2020-08-27T18:57:40+00:00\",\"dateModified\":\"2020-08-27T21:20:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2020\\\/08\\\/dbms_pdb-arriving-on-11-2-0-4\\\/\"},\"wordCount\":434,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"image\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2020\\\/08\\\/dbms_pdb-arriving-on-11-2-0-4\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i1.wp.com\\\/mikedietrichde.com\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/upgrade_plugin_noncdbtopdb.jpg?resize=740%2C332&ssl=1\",\"articleSection\":[\"Oracle Database General\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2020\\\/08\\\/dbms_pdb-arriving-on-11-2-0-4\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2020\\\/08\\\/dbms_pdb-arriving-on-11-2-0-4\\\/\",\"url\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2020\\\/08\\\/dbms_pdb-arriving-on-11-2-0-4\\\/\",\"name\":\"DBMS_PDB arriving on 11.2.0.4! - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2020\\\/08\\\/dbms_pdb-arriving-on-11-2-0-4\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2020\\\/08\\\/dbms_pdb-arriving-on-11-2-0-4\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i1.wp.com\\\/mikedietrichde.com\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/upgrade_plugin_noncdbtopdb.jpg?resize=740%2C332&ssl=1\",\"datePublished\":\"2020-08-27T18:57:40+00:00\",\"dateModified\":\"2020-08-27T21:20:37+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2020\\\/08\\\/dbms_pdb-arriving-on-11-2-0-4\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2020\\\/08\\\/dbms_pdb-arriving-on-11-2-0-4\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2020\\\/08\\\/dbms_pdb-arriving-on-11-2-0-4\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i1.wp.com\\\/mikedietrichde.com\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/upgrade_plugin_noncdbtopdb.jpg?resize=740%2C332&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i1.wp.com\\\/mikedietrichde.com\\\/wp-content\\\/uploads\\\/2019\\\/07\\\/upgrade_plugin_noncdbtopdb.jpg?resize=740%2C332&ssl=1\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/2020\\\/08\\\/dbms_pdb-arriving-on-11-2-0-4\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"DBMS_PDB arriving on 11.2.0.4!\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/\",\"name\":\"DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"description\":\"Blog about Databases, Security and High Availability\",\"publisher\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\",\"name\":\"DBA RJ\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"url\":\"https:\\\/\\\/dev.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"contentUrl\":\"https:\\\/\\\/dev.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"width\":712,\"height\":712,\"caption\":\"DBA RJ\"},\"logo\":{\"@id\":\"https:\\\/\\\/dev.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"DBMS_PDB arriving on 11.2.0.4! - DBA - Rodrigo Jorge - Oracle Tips and Guides","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:\/\/dev.dbarj.com.br\/en\/2020\/08\/dbms_pdb-arriving-on-11-2-0-4\/","twitter_misc":{"Written by":"DBA RJ","Est. reading time":"22 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dev.dbarj.com.br\/en\/2020\/08\/dbms_pdb-arriving-on-11-2-0-4\/#article","isPartOf":{"@id":"https:\/\/dev.dbarj.com.br\/en\/2020\/08\/dbms_pdb-arriving-on-11-2-0-4\/"},"author":{"name":"DBA RJ","@id":"https:\/\/dev.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"DBMS_PDB arriving on 11.2.0.4!","datePublished":"2020-08-27T18:57:40+00:00","dateModified":"2020-08-27T21:20:37+00:00","mainEntityOfPage":{"@id":"https:\/\/dev.dbarj.com.br\/en\/2020\/08\/dbms_pdb-arriving-on-11-2-0-4\/"},"wordCount":434,"commentCount":3,"publisher":{"@id":"https:\/\/dev.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"image":{"@id":"https:\/\/dev.dbarj.com.br\/en\/2020\/08\/dbms_pdb-arriving-on-11-2-0-4\/#primaryimage"},"thumbnailUrl":"https:\/\/i1.wp.com\/mikedietrichde.com\/wp-content\/uploads\/2019\/07\/upgrade_plugin_noncdbtopdb.jpg?resize=740%2C332&ssl=1","articleSection":["Oracle Database General"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dev.dbarj.com.br\/en\/2020\/08\/dbms_pdb-arriving-on-11-2-0-4\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dev.dbarj.com.br\/en\/2020\/08\/dbms_pdb-arriving-on-11-2-0-4\/","url":"https:\/\/dev.dbarj.com.br\/en\/2020\/08\/dbms_pdb-arriving-on-11-2-0-4\/","name":"DBMS_PDB arriving on 11.2.0.4! - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/dev.dbarj.com.br\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dev.dbarj.com.br\/en\/2020\/08\/dbms_pdb-arriving-on-11-2-0-4\/#primaryimage"},"image":{"@id":"https:\/\/dev.dbarj.com.br\/en\/2020\/08\/dbms_pdb-arriving-on-11-2-0-4\/#primaryimage"},"thumbnailUrl":"https:\/\/i1.wp.com\/mikedietrichde.com\/wp-content\/uploads\/2019\/07\/upgrade_plugin_noncdbtopdb.jpg?resize=740%2C332&ssl=1","datePublished":"2020-08-27T18:57:40+00:00","dateModified":"2020-08-27T21:20:37+00:00","breadcrumb":{"@id":"https:\/\/dev.dbarj.com.br\/en\/2020\/08\/dbms_pdb-arriving-on-11-2-0-4\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dev.dbarj.com.br\/en\/2020\/08\/dbms_pdb-arriving-on-11-2-0-4\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dev.dbarj.com.br\/en\/2020\/08\/dbms_pdb-arriving-on-11-2-0-4\/#primaryimage","url":"https:\/\/i1.wp.com\/mikedietrichde.com\/wp-content\/uploads\/2019\/07\/upgrade_plugin_noncdbtopdb.jpg?resize=740%2C332&ssl=1","contentUrl":"https:\/\/i1.wp.com\/mikedietrichde.com\/wp-content\/uploads\/2019\/07\/upgrade_plugin_noncdbtopdb.jpg?resize=740%2C332&ssl=1"},{"@type":"BreadcrumbList","@id":"https:\/\/dev.dbarj.com.br\/en\/2020\/08\/dbms_pdb-arriving-on-11-2-0-4\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dev.dbarj.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"DBMS_PDB arriving on 11.2.0.4!"}]},{"@type":"WebSite","@id":"https:\/\/dev.dbarj.com.br\/en\/#website","url":"https:\/\/dev.dbarj.com.br\/en\/","name":"DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Blog about Databases, Security and High Availability","publisher":{"@id":"https:\/\/dev.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dev.dbarj.com.br\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/dev.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9","name":"DBA RJ","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","url":"https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","contentUrl":"https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","width":712,"height":712,"caption":"DBA RJ"},"logo":{"@id":"https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png"}}]}},"_links":{"self":[{"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/4714","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/comments?post=4714"}],"version-history":[{"count":5,"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/4714\/revisions"}],"predecessor-version":[{"id":4771,"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/4714\/revisions\/4771"}],"wp:attachment":[{"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/media?parent=4714"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/categories?post=4714"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.dbarj.com.br\/en\/wp-json\/wp\/v2\/tags?post=4714"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}