19c Database Upgrade using the Manual Method is an essential process for enterprises that need greater control and reliability during their transition. With Oracle ending support for older releases like 11.2.0.4, many organizations are now upgrading directly from 11.2.0.4 to 19c, the long-term release that offers enhanced stability, extended support, and improved performance. This blog provides a step-by-step guide to performing the upgrade through the manual method, ensuring administrators can manage pre-upgrade checks, address compatibility issues, and achieve a smooth migration to Oracle 19c in production environments.
A manual database upgrade involves executing SQL scripts and Oracle utilities from the command line to transition an existing database to the latest Oracle release. This approach gives administrators full control over the upgrade process and allows them to handle pre- and post-upgrade tasks with precision.
Supported Oracle Database Releases for Direct Upgrade
Oracle supports direct upgrades to the latest release from the following database versions:
- 11.2.0.4
- 12.1.0.1
- 12.1.0.2
- 12.2.0.1
Before beginning, it is important to confirm that your source database is running one of these supported releases to ensure a smooth and reliable upgrade.
Prepare the Environment
Install 19c Software:
- Install Oracle 19c binaries in a new ORACLE_HOME (software-only installation).
- Do not create a new database during installation.
- Oracle Support Note: 19c Upgrade Paths (Doc ID 742060.1)
RMAN full backups before upgrade
rman target /
run {
backup database plus archivelog;
}Ensure backup is complete before upgrade.
Run Pre-Upgrade Checks:
The preupgrade.jar Pre-Upgrade Information Tool, introduced with Oracle Database 18c, is included with newer Oracle releases. This utility resides in the new Oracle home directory and is used to analyze the current database, generate upgrade readiness reports, and create fix-up scripts.
cd $ORACLE_HOME/rdbms/admin
java -jar preupgrade.jar TERMINAL TEXT DIR /tmp/preupgrade
Example
/u01/app/oracle/product/11.2.0/dbhome_1/jdk/bin/java -jar /u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/preupgrade.jar FILE DIR /u01/preupgrade/- This generates reports (
preupgrade.log,preupgrade_fixups.sql,postupgrade_fixups.sql). - Execute the generated fixup scripts in the 11g database:
SQL> @/u01/preupgrade/preupgrade_fixups.sql
Executing Oracle PRE-Upgrade Fixup Script
Auto-Generated by: Oracle Preupgrade Script
Version: 19.0.0.0.0 Build: 13
Generated on: 2025-07-23 21:54:29
For Source Database: TEST
Source Database Version: 11.2.0.4.0
For Upgrade to Version: 19.0.0.0.0
Preup Preupgrade
Action Issue Is
Number Preupgrade Check Name Remedied Further DBA Action
------ ------------------------ ---------- --------------------------------
1. ols_sys_move YES None.
2. em_present NO Manual fixup recommended.
3. invalid_objects_exist NO Manual fixup recommended.
4. streams_setup NO Manual fixup recommended.
5. tde_in_use NO Manual fixup recommended.
6. dictionary_stats YES None.
7. trgowner_no_admndbtrg YES None.
8. pre_fixed_objects YES None.
9. component_info NO Informational only.
Further action is optional.
10. exf_rul_exists NO Informational only.
Further action is optional.
11. rman_recovery_version NO Informational only.
Further action is optional.
12. invalid_all_obj_info NO Informational only.
Further action is optional.
The fixup scripts have been run and resolved what they can. However,
there are still issues originally identified by the preupgrade that
have not been remedied and are still present in the database.
Depending on the severity of the specific issue, and the nature of
the issue itself, that could mean that your database is not ready
for upgrade. To resolve the outstanding issues, start by reviewing
the preupgrade_fixups.sql and searching it for the name of
the failed CHECK NAME or Preupgrade Action Number listed above.
There you will find the original corresponding diagnostic message
from the preupgrade which explains in more detail what still needs
to be done.
PL/SQL procedure successfully completed.
For detailed guidance on resolving the issues identified during the pre-upgrade checks, you can refer to the step-by-step instructions provided in this blog: 19c Database Upgrade from 11.2.0.4 to 19c Using DBUA
Check Timezone version :
Verify whether the target database’s time zone version is older than the source database’s time zone version.
SQL> SELECT version FROM v$timezone_file;
VERSION
-------
14
SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value
FROM DATABASE_PROPERTIES
WHERE PROPERTY_NAME LIKE 'DST_%'
ORDER BY PROPERTY_NAME; 2 3 4
PROPERTY_NAME VALUE
------------------------ -----
DST_PRIMARY_TT_VERSION 14
DST_SECONDARY_TT_VERSION 0
DST_UPGRADE_STATE NONE11.2.0.4 to 19c Upgrade
Shutdown 11g version database
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.Copy the initialization parameter file and the password file from the 11g Oracle home to the new 19c Oracle home.
[oracle@test ~]$ cp /u01/app/oracle/product/11.2.0/dbhome_1/dbs/spfileorcl.ora /u01/app/oracle/product/19.0.0/dbhome_1/dbs
[oracle@test ~]$ cp /u01/app/oracle/product/11.2.0/dbhome_1/dbs/orapworcl /u01/app/oracle/product/19.0.0/dbhome_1/dbsUpdate the ORACLE_HOME to point to the 19c installation directory and start the database in UPGRADE mode:
[oracle@test ~]$ export ORACLE_SID=orcl
[oracle@test ~]$ export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1
[oracle@test ~]$ export PATH=/u01/app/oracle/product/19.0.0/dbhome_1:$PATH
[oracle@test ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Mar 21 21:33:54 2019
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 1543500136 bytes
Fixed Size 8896872 bytes
Variable Size 939524096 bytes
Database Buffers 587202560 bytes
Redo Buffers 7876608 bytes
Database mounted.
Database opened.Perform the database upgrade using the dbupgrade utility.
[oracle@test bin]$ export ORACLE_SID=orcl
[oracle@test bin]$ ./dbupgrade
Argument list for [/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/catctl.pl]
For Oracle internal use only A = 0
Run in c = 0
Do not run in C = 0
Input Directory d = 0
Echo OFF e = 1
Simulate E = 0
Forced cleanup F = 0
Log Id i = 0
Child Process I = 0
Log Dir l = 0
Priority List Name L = 0
Upgrade Mode active M = 0
SQL Process Count n = 0
SQL PDB Process Count N = 0
Open Mode Normal o = 0
Start Phase p = 0
End Phase P = 0
Reverse Order r = 0
AutoUpgrade Resume R = 0
Script s = 0
Serial Run S = 0
RO User Tablespaces T = 0
Display Phases y = 0
Debug catcon.pm z = 0
Debug catctl.pl Z = 0
catctl.pl VERSION: [19.0.0.0.0]
STATUS: [Production]
BUILD: [RDBMS_19.2.0.0.0_LINUX.X64_190204]
/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/orahome = [/u01/app/oracle/product/19.0.0/dbhome_1]
/u01/app/oracle/product/19.0.0/dbhome_1/bin/orabasehome = [/u01/app/oracle/product/19.0.0/dbhome_1]
catctlGetOraBaseLogDir = [/u01/app/oracle/product/19.0.0/dbhome_1]
Analyzing file /u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/catupgrd.sql
Log file directory = [/tmp/cfgtoollogs/upgrade20190321214707]
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/tmp/cfgtoollogs/upgrade20190321214707/catupgrd_catcon_9390.lst]
catcon::set_log_file_base_path: catcon: See [/tmp/cfgtoollogs/upgrade20190321214707/catupgrd*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/tmp/cfgtoollogs/upgrade20190321214707/catupgrd_*.lst] files for spool files, if any
Number of Cpus = 1
Database Name = orcl
DataBase Version = 11.2.0.4.0
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/orcl/upgrade20190321214709/catupgrd_catcon_9390.lst]
catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/orcl/upgrade20190321214709/catupgrd*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/orcl/upgrade20190321214709/catupgrd_*.lst] files for spool files, if any
Log file directory = [/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/orcl/upgrade20190321214709]
Components in [orcl]
Installed [APEX APS CATALOG CATJAVA CATPROC CONTEXT EM JAVAVM ORDIM OWM SDO XDB XML XOQ]
Not Installed [DV MGW ODM OLS RAC WK]
Parallel SQL Process Count = 4
------------------------------------------------------
Phases [0-107] Start Time:[2019_03_21 21:47:10]
------------------------------------------------------
*********** Executing Change Scripts ***********
Serial Phase #:0 [orcl] Files:1 [oracle@test bin]$ export ORACLE_SID=orcl
[oracle@test bin]$ ./dbupgrade
Argument list for [/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/catctl.pl]
For Oracle internal use only A = 0
Run in c = 0
Do not run in C = 0
Input Directory d = 0
Echo OFF e = 1
Simulate E = 0
Forced cleanup F = 0
Log Id i = 0
Child Process I = 0
Log Dir l = 0
Priority List Name L = 0
Upgrade Mode active M = 0
SQL Process Count n = 0
SQL PDB Process Count N = 0
Open Mode Normal o = 0
Start Phase p = 0
End Phase P = 0
Reverse Order r = 0
AutoUpgrade Resume R = 0
Script s = 0
Serial Run S = 0
RO User Tablespaces T = 0
Display Phases y = 0
Debug catcon.pm z = 0
Debug catctl.pl Z = 0
catctl.pl VERSION: [19.0.0.0.0]
STATUS: [Production]
BUILD: [RDBMS_19.2.0.0.0_LINUX.X64_190204]
/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/orahome = [/u01/app/oracle/product/19.0.0/dbhome_1]
/u01/app/oracle/product/19.0.0/dbhome_1/bin/orabasehome = [/u01/app/oracle/product/19.0.0/dbhome_1]
catctlGetOraBaseLogDir = [/u01/app/oracle/product/19.0.0/dbhome_1]
Analyzing file /u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/catupgrd.sql
Log file directory = [/tmp/cfgtoollogs/upgrade20190321214707]
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/tmp/cfgtoollogs/upgrade20190321214707/catupgrd_catcon_9390.lst]
catcon::set_log_file_base_path: catcon: See [/tmp/cfgtoollogs/upgrade20190321214707/catupgrd*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/tmp/cfgtoollogs/upgrade20190321214707/catupgrd_*.lst] files for spool files, if any
Number of Cpus = 1
Database Name = orcl
DataBase Version = 11.2.0.4.0
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/orcl/upgrade20190321214709/catupgrd_catcon_9390.lst]
catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/orcl/upgrade20190321214709/catupgrd*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/orcl/upgrade20190321214709/catupgrd_*.lst] files for spool files, if any
Log file directory = [/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/orcl/upgrade20190321214709]
Components in [orcl]
Installed [APEX APS CATALOG CATJAVA CATPROC CONTEXT EM JAVAVM ORDIM OWM SDO XDB XML XOQ]
Not Installed [DV MGW ODM OLS RAC WK]
Parallel SQL Process Count = 4
------------------------------------------------------
Phases [0-107] Start Time:[2019_03_21 21:47:10]
------------------------------------------------------
*********** Executing Change Scripts ***********
Serial Phase #:0 [orcl] Files:1
Time: 68s
*************** Catalog Core SQL ***************
Serial Phase #:1 [orcl] Files:5 Time: 48s
Restart Phase #:2 [orcl] Files:1 Time: 1s
*********** Catalog Tables and Views ***********
Parallel Phase #:3 [orcl] Files:19 Time: 25s
Restart Phase #:4 [orcl] Files:1 Time: 1s
************* Catalog Final Scripts ************
Serial Phase #:5 [orcl] Files:7 Time: 24s
***************** Catproc Start ****************
Serial Phase #:6 [orcl] Files:1 Time: 12s
***************** Catproc Types ****************
Serial Phase #:7 [orcl] Files:2 Time: 10s
Restart Phase #:8 [orcl] Files:1 Time: 0s
**************** Catproc Tables ****************
Parallel Phase #:9 [orcl] Files:67 Time: 42s
Restart Phase #:10 [orcl] Files:1 Time: 1s
************* Catproc Package Specs ************
Serial Phase #:11 [orcl] Files:1 Time: 63s
Restart Phase #:12 [orcl] Files:1 Time: 0s
************** Catproc Procedures **************
Parallel Phase #:13 [orcl] Files:94 Time: 12s
Restart Phase #:14 [orcl] Files:1 Time: 1s
Parallel Phase #:15 [orcl] Files:120 Time: 21s
Restart Phase #:16 [orcl] Files:1 Time: 0s
Serial Phase #:17 [orcl] Files:22 Time: 3s
Restart Phase #:18 [orcl] Files:1 Time: 1s
***************** Catproc Views ****************
Parallel Phase #:19 [orcl] Files:32 Time: 28s
Restart Phase #:20 [orcl] Files:1 Time: 1s
Serial Phase #:21 [orcl] Files:3 Time: 11s
Restart Phase #:22 [orcl] Files:1 Time: 0s
Parallel Phase #:23 [orcl] Files:25 Time: 197s
Restart Phase #:24 [orcl] Files:1 Time: 1s
Parallel Phase #:25 [orcl] Files:12 Time: 106s
Restart Phase #:26 [orcl] Files:1 Time: 0s
Serial Phase #:27 [orcl] Files:1 Time: 0s
Serial Phase #:28 [orcl] Files:3 Time: 4s
Serial Phase #:29 [orcl] Files:1 Time: 0s
Restart Phase #:30 [orcl] Files:1 Time: 0s
*************** Catproc CDB Views **************
Serial Phase #:31 [orcl] Files:1 Time: 1s
Restart Phase #:32 [orcl] Files:1 Time: 1s
Serial Phase #:34 [orcl] Files:1 Time: 0s
***************** Catproc PLBs *****************
Serial Phase #:35 [orcl] Files:293 Time: 22s
Serial Phase #:36 [orcl] Files:1 Time: 0s
Restart Phase #:37 [orcl] Files:1 Time: 0s
Serial Phase #:38 [orcl] Files:6 Time: 5s
Restart Phase #:39 [orcl] Files:1 Time: 0s
*************** Catproc DataPump ***************
Serial Phase #:40 [orcl] Files:3 Time: 51s
Restart Phase #:41 [orcl] Files:1 Time: 1s
****************** Catproc SQL *****************
Parallel Phase #:42 [orcl] Files:13 Time: 117s
Restart Phase #:43 [orcl] Files:1 Time: 1s
Parallel Phase #:44 [orcl] Files:11 Time: 17s
Restart Phase #:45 [orcl] Files:1 Time: 0s
Parallel Phase #:46 [orcl] Files:3 Time: 2s
Restart Phase #:47 [orcl] Files:1 Time: 0s
************* Final Catproc scripts ************
Serial Phase #:48 [orcl] Files:1 Time: 9s
Restart Phase #:49 [orcl] Files:1 Time: 1s
************** Final RDBMS scripts *************
Serial Phase #:50 [orcl] Files:1 Time: 20s
************ Upgrade Component Start ***********
Serial Phase #:51 [orcl] Files:1 Time: 1s
Restart Phase #:52 [orcl] Files:1 Time: 0s
********** Upgrading Java and non-Java *********
Serial Phase #:53 [orcl] Files:2 Time: 587s
***************** Upgrading XDB ****************
Restart Phase #:54 [orcl] Files:1 Time: 1s
Serial Phase #:56 [orcl] Files:3 Time: 28s
Serial Phase #:57 [orcl] Files:3 Time: 4s
Parallel Phase #:58 [orcl] Files:10 Time: 3s
Parallel Phase #:59 [orcl] Files:25 Time: 4s
Serial Phase #:60 [orcl] Files:4 Time: 7s
Serial Phase #:61 [orcl] Files:1 Time: 0s
Serial Phase #:62 [orcl] Files:32 Time: 4s
Serial Phase #:63 [orcl] Files:1 Time: 0s
Parallel Phase #:64 [orcl] Files:6 Time: 6s
Serial Phase #:65 [orcl] Files:2 Time: 22s
Serial Phase #:66 [orcl] Files:3 Time: 80s
**************** Upgrading ORDIM ***************
Restart Phase #:67 [orcl] Files:1 Time: 1s
Serial Phase #:69 [orcl] Files:1 Time: 1s
Parallel Phase #:70 [orcl] Files:2 Time: 56s
Restart Phase #:71 [orcl] Files:1 Time: 0s
Parallel Phase #:72 [orcl] Files:2 Time: 1s
Serial Phase #:73 [orcl] Files:2 Time: 1s
***************** Upgrading SDO ****************
Restart Phase #:74 [orcl] Files:1 Time: 0s
Serial Phase #:76 [orcl] Files:1 Time: 85s
Serial Phase #:77 [orcl] Files:2 Time: 2s
Restart Phase #:78 [orcl] Files:1 Time: 1s
Serial Phase #:79 [orcl] Files:1 Time: 19s
Restart Phase #:80 [orcl] Files:1 Time: 0s
Parallel Phase #:81 [orcl] Files:3 Time: 82s
Restart Phase #:82 [orcl] Files:1 Time: 1s
Serial Phase #:83 [orcl] Files:1 Time: 5s
Restart Phase #:84 [orcl] Files:1 Time: 0s
Serial Phase #:85 [orcl] Files:1 Time: 11s
Restart Phase #:86 [orcl] Files:1 Time: 0s
Parallel Phase #:87 [orcl] Files:4 Time: 142s
Restart Phase #:88 [orcl] Files:1 Time: 1s
Serial Phase #:89 [orcl] Files:1 Time: 1s
Restart Phase #:90 [orcl] Files:1 Time: 0s
Serial Phase #:91 [orcl] Files:2 Time: 9s
Restart Phase #:92 [orcl] Files:1 Time: 0s
Serial Phase #:93 [orcl] Files:1 Time: 1s
Restart Phase #:94 [orcl] Files:1 Time: 1s
******* Upgrading ODM, WK, EXF, RUL, XOQ *******
Serial Phase #:95 [orcl] Files:1 Time: 31s
Restart Phase #:96 [orcl] Files:1 Time: 0s
*********** Final Component scripts ***********
Serial Phase #:97 [orcl] Files:1 Time: 2s
************* Final Upgrade scripts ************
Serial Phase #:98 [orcl] Files:1 Time: 24s
******************* Migration ******************
Serial Phase #:99 [orcl] Files:1 Time: 48s
*** End PDB Application Upgrade Pre-Shutdown ***
Serial Phase #:100 [orcl] Files:1 Time: 1s
Serial Phase #:101 [orcl] Files:1 Time: 0s
Serial Phase #:102 [orcl] Files:1 Time: 44s
***************** Post Upgrade *****************
Serial Phase #:103 [orcl] Files:1 Time: 38s
**************** Summary report ****************
Serial Phase #:104 [orcl] Files:1 Time: 2s
*** End PDB Application Upgrade Post-Shutdown **
Serial Phase #:105 [orcl] Files:1 Time: 0s
Serial Phase #:106 [orcl] Files:1 Time: 0s
Serial Phase #:107 [orcl] Files:1 Time: 32s
------------------------------------------------------
Phases [0-107] End Time:[2019_03_21 22:25:49]
------------------------------------------------------
Grand Total Time: 2320s
LOG FILES: (/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/orcl/upgrade20190321214709/catupgrd*.log)
Upgrade Summary Report Located in:
/u01/app/oracle/product/19.0.0/dbhome_1/cfgtoollogs/orcl/upgrade20190321214709/upg_summary.log
Grand Total Upgrade Time: [0d:0h:38m:40s]Post Upgrade Activities
Startup the database once the upgrade is finished.
SQL> startup
ORACLE instance started.
Total System Global Area 1543500136 bytes
Fixed Size 8896872 bytes
Variable Size 939524096 bytes
Database Buffers 587202560 bytes
Redo Buffers 7876608 bytes
Database mounted.
Database opened.After starting the database in OPEN mode, run the catuppst.sql script to complete the post-upgrade steps.
SQL> @catuppst.sql
Compile Invalid objects
SQL> @utlrp.sqlCheck list of Valid Components Database Registry
SELECT comp_id,
version,
status,
namespace,
schema
FROM dba_registry
ORDER BY comp_id;
Change COMPATIBLE parameter :
SQL> show parameter compatible;
NAME TYPE VALUE
----------------- -------- ---------
compatible string 11.2.0.4.0
noncdb_compatible boolean FALSE
SQL> ALTER SYSTEM SET COMPATIBLE = '19.0.0' SCOPE=SPFILE;
System altered.Restart 19c Database
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 2516580184 bytes
Fixed Size 8660824 bytes
Variable Size 671088640 bytes
Database Buffers 1828716544 bytes
Redo Buffers 8114176 bytes
Database mounted.
Database opened.
SQL> show parameter compatible;
NAME TYPE VALUE
----------------- -------- ---------
compatible string 19.0.0
noncdb_compatible boolean FALSEGather Fixed Objects Stats
SQL> EXECUTE DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;
PL/SQL procedure successfully completed.
Upgrade Timezone version
Time zone file.
sqlplus / as sysdba <<EOF
-- Check current settings.
SELECT * FROM v$timezone_file;
SHUTDOWN IMMEDIATE;
STARTUP UPGRADE;
-- Begin upgrade to the latest version.
SET SERVEROUTPUT ON
DECLARE
l_tz_version PLS_INTEGER;
BEGIN
l_tz_version := DBMS_DST.get_latest_timezone_version;
DBMS_OUTPUT.put_line('l_tz_version=' || l_tz_version);
DBMS_DST.begin_upgrade(l_tz_version);
END;
/
SHUTDOWN IMMEDIATE;
STARTUP;
-- Do the upgrade.
SET SERVEROUTPUT ON
DECLARE
l_failures PLS_INTEGER;
BEGIN
DBMS_DST.upgrade_database(l_failures);
DBMS_OUTPUT.put_line('DBMS_DST.upgrade_database : l_failures=' || l_failures);
DBMS_DST.end_upgrade(l_failures);
DBMS_OUTPUT.put_line('DBMS_DST.end_upgrade : l_failures=' || l_failures);
END;
/
-- Check new settings.
SELECT * FROM v$timezone_file;
FILENAME VERSION CON_ID
-------------------- ---------- ----------
timezlrg_32.dat 32 0
COLUMN property_name FORMAT A30
COLUMN property_value FORMAT A20
SELECT property_name, property_value
FROM database_properties
WHERE property_name LIKE 'DST_%'
ORDER BY property_name;
PROPERTY_NAME PROPERTY_VALUE
-------------------------- ---------------
DST_PRIMARY_TT_VERSION 32
DST_SECONDARY_TT_VERSION 0
DST_UPGRADE_STATE NONERun postupgrade fixups
QL> @/u01/preupgrade/postupgrade_fixups.sql
Session altered.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Package created.
No errors.
Package body created.
PL/SQL procedure successfully completed.
No errors.
Package created.
No errors.
Package body created.
No errors.
Executing Oracle POST-Upgrade Fixup Script
Auto-Generated by: Oracle Preupgrade Script
Version: 19.0.0.0.0 Build: 1
Generated on: 2019-03-21 21:12:30
For Source Database: orcl
Source Database Version: 11.2.0.4.0
For Upgrade to Version: 19.0.0.0.0
Preup Preupgrade
Action Issue Is
Number Preupgrade Check Name Remedied Further DBA Action
------ ------------------------ ---------- ----------------------------
11. old_time_zones_exist YES None.
12. dir_symlinks YES None.
13. post_dictionary YES None.
14. post_fixed_objects NO Informational only.
Further action is optional.
15. upg_by_std_upgrd NO Informational only.
Further action is optional.
The fixup scripts have been run and resolved what they can. However,
there are still issues originally identified by the preupgrade that
have not been remedied and are still present in the database.
Depending on the severity of the specific issue, and the nature of
the issue itself, that could mean that your database upgrade is not
fully complete. To resolve the outstanding issues, start by reviewing
the postupgrade_fixups.sql and searching it for the name of
the failed CHECK NAME or Preupgrade Action Number listed above.
There you will find the original corresponding diagnostic message
from the preupgrade which explains in more detail what still needs
to be done.
PL/SQL procedure successfully completed.
Session altered.
Comments 2