# Oracle Database 19c AutoUpgrade Config File Generator > Source: https://netray.co/tools/oracle-database-19c-autoupgrade-config-generator > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Fill in homes, SID and options to get a working AutoUpgrade config file and the analyze, fixups and deploy commands for a 12c to 19c upgrade. ## Category developer ## Erp Oracle Database ## Audience - Oracle DBA - ERP administrator ## Tool **Kind:** template **Output:** code **Language:** text **Fields:** #### Log directory **Key:** logdir **Type:** text **Default:** /u01/app/oracle/autoupgrade #### Source Oracle home **Key:** source_home **Type:** text **Default:** /u01/app/oracle/product/12.2.0/dbhome_1 #### Target Oracle home (19c, latest RU applied) **Key:** target_home **Type:** text **Default:** /u01/app/oracle/product/19.0.0/dbhome_1 #### Database SID **Key:** sid **Type:** text **Default:** ERPPRD #### Start time **Key:** start_time **Type:** text **Default:** NOW **Help:** NOW, a delay such as +1h30m, or a date in dd/mm/yyyy hh:mm:ss format. #### Create guaranteed restore point **Key:** restoration **Type:** select **Options:** - yes - no **Default:** yes #### Upgrade time zone file **Key:** tz **Type:** select **Options:** - yes - no **Default:** yes #### Target CDB for non-CDB to PDB conversion (optional) **Key:** target_cdb **Type:** text **Default:** CDB1 #### Config file name **Key:** cfg **Type:** text **Default:** up.cfg **Blocks:** #### Config file ({{cfg}}) **Body:** # AutoUpgrade configuration for {{sid}} global.autoupg_log_dir={{logdir}} upg1.source_home={{source_home}} upg1.target_home={{target_home}} upg1.sid={{sid}} upg1.start_time={{start_time}} upg1.log_dir={{logdir}} upg1.upgrade_node=localhost upg1.restoration={{restoration}} upg1.timezone_upg={{tz}} # Non-CDB to PDB conversion: remove the # to plug {{sid}} into an existing 19c CDB #upg1.target_cdb={{target_cdb}} #### Run sequence **Body:** # Use the Java in the 19c target home and the latest autoupgrade.jar from My Oracle Support export ORACLE_HOME={{target_home}} $ORACLE_HOME/jdk/bin/java -jar autoupgrade.jar -version # 1. Analyze only: no changes to the database $ORACLE_HOME/jdk/bin/java -jar autoupgrade.jar -config {{cfg}} -mode analyze # 2. Run pre-upgrade fixups (still no upgrade) $ORACLE_HOME/jdk/bin/java -jar autoupgrade.jar -config {{cfg}} -mode fixups # 3. Full run: analyze, fixups, upgrade, post-upgrade fixups $ORACLE_HOME/jdk/bin/java -jar autoupgrade.jar -config {{cfg}} -mode deploy #### Console commands while a job runs **Body:** upg> lsj # list jobs and their stage upg> status -job 100 # detail for one job (first job number is usually 100) upg> resume -job 100 # resume after fixing a stopped job upg> abort -job 100 # stop a job upg> exit #### Where the logs are **Body:** {{logdir}}/cfgtoollogs/upgrade/auto/ # global AutoUpgrade logs and status {{logdir}}/{{sid}}//prechecks/ # {{sid}}_preupgrade.html and .log from analyze {{logdir}}/{{sid}}//prefixups/ # pre-upgrade fixup results {{logdir}}/{{sid}}//dbupgrade/ # catupgrd logs from the upgrade itself {{logdir}}/{{sid}}//postfixups/ # post-upgrade fixup results {{logdir}}/{{sid}}/temp/ # generated scripts and temporary files **Notes:** Always download the latest autoupgrade.jar from My Oracle Support; the copy in a 19c home is often old. Check parameter names against the AutoUpgrade documentation for your jar version (java -jar autoupgrade.jar -create_sample_file config writes a current sample). restoration=yes needs archivelog mode, a fast recovery area with space and Enterprise Edition (Flashback Database is not available on SE2). Non-CDB to PDB conversion is one way: the guaranteed restore point cannot roll back the plug in. For Oracle E-Business Suite, follow the EBS interoperability note for Database 19c, which defines the supported upgrade method and extra EBS steps; for JD Edwards and PeopleSoft, confirm 19c certification for your tools release first. ## Content **Intro:** This generator writes an AutoUpgrade configuration file for upgrading an Oracle 12c database to 19c, with the guaranteed restore point, time zone upgrade and optional non-CDB to PDB conversion settings, and the commands to run analyze, fixups and deploy. Fill in your homes and SID and copy the result. **Sections:** #### How to use it **Body:** Install the 19c software into a new home and apply the latest Release Update before upgrading, so you only take one outage. Enter the log directory, the source 12c home, the target 19c home, the SID and a start time. Keep restoration=yes on Enterprise Edition so AutoUpgrade creates a guaranteed restore point you can flash back to. Leave timezone_upg=yes unless an application vendor requires a fixed time zone file version. Only uncomment target_cdb if you are converting a non-CDB into a PDB of an existing 19c CDB. Save the config as up.cfg next to autoupgrade.jar and run analyze first. **Bullets:** - analyze: read-only checks, writes the preupgrade HTML report. - fixups: runs the pre-upgrade fixups the analysis found. - deploy: the full upgrade, including post-upgrade fixups. - upgrade mode exists for when the database is already started in the new home. #### Supported paths and the non-CDB decision **Body:** Direct upgrade to 19c is supported from 11.2.0.4, 12.1.0.2, 12.2.0.1 and 18c. 19c still supports the non-CDB architecture, which was deprecated in 12.1.0.2 and is desupported from 21c, so many teams stay non-CDB for the 19c upgrade and convert later. From 19c you can run up to three user PDBs per CDB without the Multitenant option, so a single ERP PDB needs no extra licence. Converting with target_cdb moves the database into a PDB in one AutoUpgrade run, but it cannot be undone with the restore point; take an RMAN backup first. #### AutoUpgrade and DBUA **Body:** Oracle recommends AutoUpgrade as the preferred upgrade method for 19c. The Database Upgrade Assistant (DBUA) is still documented in the 19c Upgrade Guide, but Oracle lists DBUA and manual upgrades as deprecated in later releases. AutoUpgrade can upgrade many databases from one config file, resume after a failure, run unattended at a start time and produce consistent logs, which is what most ERP teams need for rehearsals. Manual upgrade with dbupgrade remains possible when an ERP note requires it. #### Checking the result **Body:** After deploy, lsj should show the job as FINISHED. Then check SELECT comp_id, version, status FROM dba_registry for VALID components at 19, SELECT * FROM v$timezone_file for the new time zone version, and DBA_REGISTRY_SQLPATCH for the RU of the target home. Count invalid objects against the baseline you took before the upgrade. Keep COMPATIBLE at the old value until the ERP has run a full business cycle, because raising it removes the option to flash back to the restore point. Drop the guaranteed restore point once you are committed, or the fast recovery area fills. **Cta:** If you want your DBAs to ask upgrade logs and preupgrade reports questions in plain English across all your databases on your own servers, we can set that up. **Faq:** #### Where is the Oracle database upgrade log location with AutoUpgrade? **Answer:** Under the log directory in the config. Global logs are in /cfgtoollogs/upgrade/auto. Each database job has /// with prechecks, prefixups, dbupgrade (the catupgrd logs) and postfixups subfolders. The prechecks folder holds the _preupgrade.html report from analyze. #### What are the steps to upgrade Oracle 12c to 19c with AutoUpgrade? **Answer:** Install 19c in a new home and apply the latest RU, download the latest autoupgrade.jar, write the config file, run -mode analyze and review the preupgrade report, fix the issues it reports, take a backup, then run -mode deploy in the outage window and validate the registry, time zone, patch level and application. #### Is DBUA still supported for 19c? **Answer:** DBUA is documented and usable for 19c upgrades, but Oracle recommends AutoUpgrade and has deprecated DBUA and manual upgrade in later releases. For new upgrade projects, and especially for repeatable rehearsals across test and production, AutoUpgrade is the better fit. #### Can I roll back an AutoUpgrade upgrade? **Answer:** With restoration=yes on Enterprise Edition, AutoUpgrade creates a guaranteed restore point and you can restore to it while COMPATIBLE is still at the old value and no non-CDB to PDB conversion happened. On SE2, or after a conversion, rollback means an RMAN restore of the pre-upgrade backup. ## Search terms oracle database upgrade from 12c to 19c, oracle upgrade 12c to 19c steps, oracle database upgrade assistant, upgrade oracle database from 12c to 19c, oracle database upgrade log location, oracle database 19c upgrade guide, autoupgrade config file example, autoupgrade.jar analyze deploy --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json