{"id":16659,"date":"2021-08-23T16:42:02","date_gmt":"2021-08-23T14:42:02","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/"},"modified":"2023-01-06T11:36:08","modified_gmt":"2023-01-06T10:36:08","slug":"auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/","title":{"rendered":"Auto Upgrade of non CDB to PDB with autoupgrade.jar in Oracle 21c"},"content":{"rendered":"<p>Since Oracle 21c it is possible to convert the non CDB database into a PDB directly during the upgrade using the Oracle Autoupgrade Tool.<br \/>\nThis is an important enhancement, because with Oracle 21c the non CDB architecture is desupported, which means that with an upgrade to 21c a conversion is mandatory.<br \/>\nLet&#8217;s test if this new feature really works and what needs to be considered.<\/p>\n<p><strong>Work done by autoupgrade utility<\/strong><\/p>\n<ol>\n<li>Check and Prepare Source non CDB Database<\/li>\n<li>Convert non CDB to PDB in Source Release<\/li>\n<li>Upgrade PDB to Target Release<\/li>\n<li>If the database is running in a cluster configuration, the cluster resources are also automatically adjusted.<\/li>\n<\/ol>\n<p><strong>Requirements on Source and Target DB for auto conversion during upgrade<\/strong><\/p>\n<ul id=\"GUID-D739E4A4-F1B9-45BE-B0E2-F213FE70F665__UL_S3F_LTN_DMB\">\n<li>The target CDB must be created in advance of performing the upgrade with AutoUpgrade.<\/li>\n<li>The PDB created from the non-CDB must continue to use the source non-CDB name. You cannot change the name of the database.<\/li>\n<li>The same set of Oracle Database options are configured for both the source and target.<\/li>\n<li>The endian format of the source and target CDBs are identical.<\/li>\n<li>The source and target CDBs have compatible character sets and national character sets.<\/li>\n<li>The source non-CDB Oracle Database release and operating system platform must be supported for direct upgrade to the target CDB release.<\/li>\n<li>Operating system authentication is enabled for the source and target CDBs<\/li>\n<\/ul>\n<p><strong>Fallback Scenario<\/strong><\/p>\n<ul>\n<li>There is no option to roll back to the non CDB Oracle Database after the upgrade has started. So please create a full backup of your non CDB before starting, that you have the possibility to restore the database in case of any problems!<\/li>\n<\/ul>\n<p><strong>Test Environment and Setup<\/strong><\/p>\n<table style=\"border-collapse: collapse;width: 42.277%;height: 168px\">\n<tbody>\n<tr style=\"height: 24px\">\n<td style=\"width: 22.0756%;height: 24px\"><strong>OS<\/strong><\/td>\n<td style=\"width: 15.876%;height: 24px\">Oracle Linux 8<\/td>\n<\/tr>\n<tr style=\"height: 48px\">\n<td style=\"width: 22.0756%;height: 48px\"><strong>Grid Infrastructure for Standalone Server<\/strong><\/td>\n<td style=\"width: 15.876%;height: 48px\">21.3.0<\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 22.0756%;height: 24px\"><strong>Source non CDB (19.3.0)&nbsp;<\/strong><\/td>\n<td style=\"width: 15.876%;height: 24px\">noncdb1<\/td>\n<\/tr>\n<tr style=\"height: 24px\">\n<td style=\"width: 22.0756%;height: 24px\"><strong>Target CDB (21.3.0)<\/strong><\/td>\n<td style=\"width: 15.876%;height: 24px\">cdb01<\/td>\n<\/tr>\n<tr style=\"height: 48px\">\n<td style=\"width: 22.0756%;height: 48px\"><strong>Database Options&nbsp;<\/strong><\/td>\n<td style=\"width: 15.876%;height: 48px\">All options are installed in both databases<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>Update autoupgrade.jar<br \/>\n<\/strong>Since Oracle 19c, the autoupgrade.jar is part of the oracle binaries and located under $<em>ORACLE_HOME\/rdbms\/admin<\/em>. Since the autoupgrade tool is constantly being developed, it is recommended that you always download and install the latest version. The latest version can be downloaded from Oracle Support (Doc ID 2485457.1).<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">#Copy downloaded autoupgrade.jar to target database home \ncp \/tmp\/autoupgrade.jar \/u01\/app\/oracle\/product\/21.0.0\/dbhome_1\/rdbms\/admin<\/pre>\n<p><strong>Create log directory and Config File<br \/>\n<\/strong>autoupgrade tool works with a config file. In this file you define all necessary parameters for the upgrade. First i create some directories for the upgrade logfiles and afterwards the config file for the upgrade.<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">#create directories for the upgrade\nmkdir \/u01\/app\/oracle\/autoupgrade\n&nbsp;mkdir \/u01\/app\/oracle\/autoupgrade\/noncdb1_to_cdb1\n#create config file&nbsp;\ncat \/u01\/app\/oracle\/autoupgrade\/noncdb1_to_cdb1\/config.txt\nglobal.autoupg_log_dir=\/u01\/app\/oracle\/autoupgrade\nupg1.sid=noncdb1\nupg1.source_home=\/u01\/app\/oracle\/product\/19.0.0\/dbhome_1\nupg1.log_dir=\/u01\/app\/oracle\/autoupgrade\/noncdb_to_pdb\/\nupg1.target_home=\/u01\/app\/oracle\/product\/21.0.0\/dbhome_1\nupg1.target_base=\/u01\/app\/oracle\nupg1.target_version=21.3.0\n# That is the new parameter introduced with 21c to define the target cdb for the new pdb\nupg1.target_cdb=cdb01\n<\/pre>\n<p><strong>Execute Pre Upgrade Tasks<br \/>\n<\/strong>The autoupgrade has to be started always in the target ORACLE_HOME, if not, you get an error. First i start the upgrade only in analyze mode. In this mode only the pre upgrade tasks will be executed and at the end you get a summary if everything is ready and all requirements are met for the upgrade.<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">java -jar $ORACLE_HOME\/rdbms\/admin\/autoupgrade.jar -config config.txt -mode analyze<\/pre>\n<p>You will automatic connected to the autoupgrade cli where you can check the progress of the upgrade activities and list some job details if you want<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">upg&gt; lsj\n+----+-------+---------+---------+-------+--------------+--------+----------------------------+\n|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|\n+----+-------+---------+---------+-------+--------------+--------+----------------------------+\n| 100|noncdb1|PRECHECKS|PREPARING|RUNNING|21\/08\/19 21:37|21:37:03|Loading database information|\n+----+-------+---------+---------+-------+--------------+--------+----------------------------+\nTotal jobs 1\nupg&gt; \/\n+----+-------+---------+---------+-------+--------------+--------+----------------+\n|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|\n+----+-------+---------+---------+-------+--------------+--------+----------------+\n| 100|noncdb1|PRECHECKS|PREPARING|RUNNING|21\/08\/19 21:37|21:38:26|Remaining 83\/104|\n+----+-------+---------+---------+-------+--------------+--------+----------------+\nTotal jobs 1<\/pre>\n<p>At the End you get a summary of the Job and a report in text and html format<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">upg&gt; Job 100 completed\n------------------- Final Summary --------------------\nNumber of databases [ 1 ]\nJobs finished [1]\nJobs failed [0]\nJobs pending [0]\n------------- JOBS FINISHED WITH ERROR -------------\nJob 100 for noncdb1\nPlease check the summary report at:\n\/u01\/app\/oracle\/autoupgrade\/cfgtoollogs\/upgrade\/auto\/status\/status.html\n\/u01\/app\/oracle\/autoupgrade\/cfgtoollogs\/upgrade\/auto\/status\/status.log<\/pre>\n<p>Lets have a look at the summary Report, that look good so far.<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">==========================================\nAutoupgrade Summary Report\n==========================================\n[Date] Thu Aug 19 22:26:13 CEST 2021\n[Number of Jobs] 1\n==========================================\n[Job ID] 101\n==========================================\n[DB Name] noncdb1\n[Version Before Upgrade] 19.3.0.0.0\n[Version After Upgrade] 21.3.0.0.0\n------------------------------------------\n[Stage Name] PRECHECKS\n[Status] SUCCESS\n[Start Time] 2021-08-19 22:24:06\n[Duration] 0:02:07\n[Log Directory] \/u01\/app\/oracle\/autoupgrade\/noncdb_to_pdb\/noncdb1\/101\/prechecks\n[Detail] \/u01\/app\/oracle\/autoupgrade\/noncdb_to_pdb\/noncdb1\/101\/prechecks\/noncdb1_preupgrade.log\nPrecheck passed and no manual intervention needed\n------------------------------------------<\/pre>\n<p>If the status of the report is FAILD you can check the &lt;ORACLE_SID&gt;_preupgrade.log for more information. In my Environment the detail logfile is located in<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">\/u01\/app\/oracle\/autoupgrade\/noncdb_to_pdb\/noncdb1\/100\/prechecks\/noncdb1_preupgrade.log<\/pre>\n<p><strong>Start real upgrade and conversion<br \/>\n<\/strong>So from here there is no way back to the old non cdb database. So check that you have a full backup before you start the upgrade in deploy mode. Deploy mode will execute the pre checks again, then execute the upgrade and conversion and finally the post task like compile invalid objects or register the new pdb in the cluster.<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">java -jar $ORACLE_HOME\/rdbms\/admin\/autoupgrade.jar -config config.txt -mode deploy<\/pre>\n<p>Like in the analyze mode you have the possibility to check the status of your upgrade in the cli. The most important cli commands in the autoupgrade are:<\/p>\n<table style=\"border-collapse: collapse;width: 31.327%\">\n<tbody>\n<tr>\n<td style=\"width: 12.8716%\">lsj<\/td>\n<td style=\"width: 18.4554%\">show current job<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 12.8716%\">lsj -e<\/td>\n<td style=\"width: 18.4554%\">show jobs with errors<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 12.8716%\">status -job &lt;job_id&gt;<\/td>\n<td style=\"width: 18.4554%\">Details for the current job<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 12.8716%\">logs<\/td>\n<td style=\"width: 18.4554%\">Infos about the log directories<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><b>Checks and some adjustments<br \/>\n<\/b>If everything works well, at the end you will provided with a summary report over the upgrade in html and as normal logfile. The report shows the tasks done during the upgrade, the time used and the log directory providing some detail information about the jobs.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Summary_Report.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-22854 alignnone\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Summary_Report.png\" alt=\"\" width=\"300\" height=\"218\"><\/a><\/p>\n<p>Also the Oracle Grid Infrastructure resource was automatically changed during the autoupgrade. The Resource for the old noncdb1 database was removed from the cluster and a new resource for the pdb was added<\/p>\n<p>At the end you will probably do some maintenance work. In my test lab, the database files are stored in ASM. So because the autoupgrade perform the pdb plugin operation with nocopy mode, the source files of the noncdb will be used for the pdb. In this case you have still the old db name in the file path.<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; select file#, name from v$datafile;\nFILE# NAME\n---------- ------------------------------------------------------------------------------------------------------------------------------------------------------\n1 +DATA\/CDB01\/DATAFILE\/system.261.1081002215\n2 +DATA\/CDB01\/C9E99EACD6BE6700E0530A01A8C0DEDD\/DATAFILE\/system.262.1081002217\n3 +DATA\/CDB01\/DATAFILE\/sysaux.263.1081002219\n4 +DATA\/CDB01\/C9E99EACD6BE6700E0530A01A8C0DEDD\/DATAFILE\/sysaux.264.1081002221\n5 +DATA\/CDB01\/DATAFILE\/undotbs1.265.1081002223\n6 +DATA\/CDB01\/C9E99EACD6BE6700E0530A01A8C0DEDD\/DATAFILE\/undotbs1.266.1081002223\n7 +DATA\/CDB01\/DATAFILE\/users.269.1081002235\n12 +DATA\/NONCDB1\/DATAFILE\/system.286.1081018771\n13 +DATA\/NONCDB1\/DATAFILE\/sysaux.276.1081018781\n14 +DATA\/NONCDB1\/DATAFILE\/undotbs1.277.1081018789\n15 +DATA\/NONCDB1\/DATAFILE\/users.278.1081018795<\/pre>\n<p class=\"brush: sql; gutter: true; first-line: 1\">To fix that, you can perform an online move of the datafiles and oracle will change the file names to <em>&lt;CDB_NAME&gt;\/&lt;PDB_ID&gt;\/DATAFILE\/&lt;DBF_NAME&gt;.<br \/>\n<\/em>Yes i know that is a feature of Enterprise Edition and perhaps your databases run only on SE or SE2. For this case you can set the parameter <strong>TARGET_PDB_COPY_OPTION&nbsp;<\/strong>in the config file for autoupgrade. That will also work for SE Customers and will copy the non cdb datafiles during the plugin operation. As Always Mike Dietrich did a great <a href=\"https:\/\/mikedietrichde.com\/2020\/07\/21\/more-information-on-autoupgrades-target_pdb_copy_operation\/\">post<\/a> about this option and how to use it<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; alter session set container=noncdb1;\nSession altered.\nSQL&gt; alter database move datafile 12 to '+DATA';\nDatabase altered.\nSQL&gt; alter database move datafile 13 to '+DATA';\nDatabase altered.\nSQL&gt; alter database move datafile 14 to '+DATA';\nDatabase altered.\nSQL&gt; alter database move datafile 15 to '+DATA';\nDatabase altered.\nSQL&gt; alter session set container=cdb$root;\nSession altered.\nSQL&gt; select file#, name from v$datafile;\nFILE# NAME\n---------- ------------------------------------------------------------------------------------------------------------------------------------------------------\n1 +DATA\/CDB01\/DATAFILE\/system.261.1081002215\n2 +DATA\/CDB01\/C9E99EACD6BE6700E0530A01A8C0DEDD\/DATAFILE\/system.262.1081002217\n3 +DATA\/CDB01\/DATAFILE\/sysaux.263.1081002219\n4 +DATA\/CDB01\/C9E99EACD6BE6700E0530A01A8C0DEDD\/DATAFILE\/sysaux.264.1081002221\n5 +DATA\/CDB01\/DATAFILE\/undotbs1.265.1081002223\n6 +DATA\/CDB01\/C9E99EACD6BE6700E0530A01A8C0DEDD\/DATAFILE\/undotbs1.266.1081002223\n7 +DATA\/CDB01\/DATAFILE\/users.269.1081002235\n12 +DATA\/CDB01\/C9EBB833AB831A02E0530A01A8C090C5\/DATAFILE\/system.272.1081342185\n13 +DATA\/CDB01\/C9EBB833AB831A02E0530A01A8C090C5\/DATAFILE\/sysaux.286.1081342195\n14 +DATA\/CDB01\/C9EBB833AB831A02E0530A01A8C090C5\/DATAFILE\/undotbs1.276.1081342201\n15 +DATA\/CDB01\/C9EBB833AB831A02E0530A01A8C090C5\/DATAFILE\/users.277.108134220<\/pre>\n<p class=\"brush: actionscript3; gutter: true; first-line: 1\">In my tests it was not possible to define the target pdb name after the upgrade. At the moment the name for the pdb will be the same as for the noncdb database. This is no big issue, and we can change the pdb name now. I will change the name from noncdb1 to pdb1.<\/p>\n<pre class=\"brush: sql; gutter: true; first-line: 1\">SQL&gt; alter pluggable database noncdb1 close immediate;\nPluggable database altered.\nSQL&gt; alter pluggable database noncdb1 open restricted;\nPluggable database altered.\nSQL&gt; alter pluggable database noncdb1 rename global_name to pdb1;\nPluggable database altered.\nSQL&gt; alter pluggable database pdb1 close immediate;\nPluggable database altered.\nSQL&gt; alter pluggable database pdb1 open;\nPluggable database altered.\nSQL&gt; alter pluggable database pdb1 save state;<\/pre>\n<p class=\"brush: sql; gutter: true; first-line: 1\"><strong>Conclusion<br \/>\n<\/strong>As you can see the autoupgrade tool works better and better with every release. It is a big change, that the noncdb architecture is desupported now with 21c, but it&#8217;s nice, that you don&#8217;t have to create pdb&#8217;s or perform some plugin operation manually. Every upgrade project is different and it&#8217;s very important to understand, that the tool only helps you to automate most of the tasks of upgrading a database. The three most important things before you upgrade to a new release are test, test and test. This is still the job of the dba and the developers.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Since Oracle 21c it is possible to convert the non CDB database into a PDB directly during the upgrade using the Oracle Autoupgrade Tool. This is an important enhancement, because with Oracle 21c the non CDB architecture is desupported, which means that with an upgrade to 21c a conversion is mandatory. Let&#8217;s test if this [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":16660,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198,59],"tags":[1570,137,66],"type_dbi":[],"class_list":["post-16659","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-database-management","category-oracle","tag-autoupgrade","tag-oracle-21c","tag-pdb"],"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>Auto Upgrade of non CDB to PDB with autoupgrade.jar in Oracle 21c - 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\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Auto Upgrade of non CDB to PDB with autoupgrade.jar in Oracle 21c\" \/>\n<meta property=\"og:description\" content=\"Since Oracle 21c it is possible to convert the non CDB database into a PDB directly during the upgrade using the Oracle Autoupgrade Tool. This is an important enhancement, because with Oracle 21c the non CDB architecture is desupported, which means that with an upgrade to 21c a conversion is mandatory. Let&#8217;s test if this [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-08-23T14:42:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-01-06T10:36:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Summary_Report.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1624\" \/>\n\t<meta property=\"og:image:height\" content=\"1182\" \/>\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\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Auto Upgrade of non CDB to PDB with autoupgrade.jar in Oracle 21c\",\"datePublished\":\"2021-08-23T14:42:02+00:00\",\"dateModified\":\"2023-01-06T10:36:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/\"},\"wordCount\":1086,\"commentCount\":1,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Summary_Report.png\",\"keywords\":[\"autoupgrade\",\"Oracle 21C\",\"PDB\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Database management\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/\",\"name\":\"Auto Upgrade of non CDB to PDB with autoupgrade.jar in Oracle 21c - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Summary_Report.png\",\"datePublished\":\"2021-08-23T14:42:02+00:00\",\"dateModified\":\"2023-01-06T10:36:08+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Summary_Report.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Summary_Report.png\",\"width\":1624,\"height\":1182},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Auto Upgrade of non CDB to PDB with autoupgrade.jar in Oracle 21c\"}]},{\"@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":"Auto Upgrade of non CDB to PDB with autoupgrade.jar in Oracle 21c - 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\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/","og_locale":"en_US","og_type":"article","og_title":"Auto Upgrade of non CDB to PDB with autoupgrade.jar in Oracle 21c","og_description":"Since Oracle 21c it is possible to convert the non CDB database into a PDB directly during the upgrade using the Oracle Autoupgrade Tool. This is an important enhancement, because with Oracle 21c the non CDB architecture is desupported, which means that with an upgrade to 21c a conversion is mandatory. Let&#8217;s test if this [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/","og_site_name":"dbi Blog","article_published_time":"2021-08-23T14:42:02+00:00","article_modified_time":"2023-01-06T10:36:08+00:00","og_image":[{"width":1624,"height":1182,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Summary_Report.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\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Auto Upgrade of non CDB to PDB with autoupgrade.jar in Oracle 21c","datePublished":"2021-08-23T14:42:02+00:00","dateModified":"2023-01-06T10:36:08+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/"},"wordCount":1086,"commentCount":1,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Summary_Report.png","keywords":["autoupgrade","Oracle 21C","PDB"],"articleSection":["Database Administration &amp; Monitoring","Database management","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/","url":"https:\/\/www.dbi-services.com\/blog\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/","name":"Auto Upgrade of non CDB to PDB with autoupgrade.jar in Oracle 21c - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Summary_Report.png","datePublished":"2021-08-23T14:42:02+00:00","dateModified":"2023-01-06T10:36:08+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Summary_Report.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Summary_Report.png","width":1624,"height":1182},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/auto-upgrade-of-non-cdb-to-pdb-with-autoupgrade-jar-in-oracle-21c\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Auto Upgrade of non CDB to PDB with autoupgrade.jar in Oracle 21c"}]},{"@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\/16659","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=16659"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16659\/revisions"}],"predecessor-version":[{"id":21460,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16659\/revisions\/21460"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/16660"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=16659"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=16659"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=16659"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=16659"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}