Upgrade 11g to 19c

Manually Upgrading to Oracle Database 19c (Non-CDB) - 11g to 19c

Reference : https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/upgrade-scenarios-non-cdb-oracle-databases.html#GUID-D6F6D375-B021-47E0-B0C8-B2C0B191AC0D
You can perform a direct upgrade to the new release from the following releases:• 11.2.0.4• 12.1.0.1 and 12.1.0.2• 12.2.0.1

Preupgrade Steps

1. Take a full backup of database2. Ensure backup is complete before upgrade.SELECT * FROM v$backup WHERE status != 'NOT ACTIVE';3. Empty Recycle bin.PURGE DBA_RECYCLEBIN ;4. Run Gather statistics to finish upgrade soon.EXEC DBMS_STATS.GATHER_DICTIONARY_STATS;5. Install Oracle database 19.3( Download --> https://www.oracle.com/in/database/technologies/oracle-database-software-downloads.html )Once you unzip, go to database folder -> Create a new O_H location as this will be used in installation -> ./runInstaller -> In "Installation Option" use, "Install database software only" -> In "Installation Location" give thew new O_H path in "Software Location". Oracle home can be outside or inside this Oracle base6. Run the Pre-Upgrade Information Tool $ORACLE_HOME/jdk/bin/java -jar /opt/oracle/product/19.0.0/rdbms/admin/preupgrade.jar FILE TEXT 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/

PREUPGRADE SUMMARY--------------------------/u01/preupgrade/preupgrade.log/u01/preupgrade/preupgrade_fixups.sql/u01/preupgrade/postupgrade_fixups.sql
Execute fixup scripts as indicated below:
Before upgrade:
Log into the database and execute the preupgrade fixups@/u01/preupgrade/preupgrade_fixups.sql
After the upgrade:
Log into the database and execute the postupgrade fixups@/u01/preupgrade/postupgrade_fixups.sql
7. Run preupgrade_fixups.sql and fix the issues.
8. Check Timezone version SELECT version FROM v$timezone_file;SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME LIKE 'DST_%' ORDER BY PROPERTY_NAME;
9. (Conditional) For Oracle RAC environments only, enter the following commands to set the initialization parameter value for CLUSTER_DATABASE to FALSE:ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=SPFILE;
10. Shut down the database.SHUTDOWN IMMEDIATE

Upgrade Steps

1. Copy the parameter and password file from the 11g home to the new 19c home.
2. Set new ORACLE_HOME for 19c location and startup database in upgrade mode :cd $ORACLE_HOME/rdbms/adminpwd/u01/app/oracle/product/19.0.0/dbhome_1/rdbms/adminsqlplusconnect / as sysdba
3. Start the non-CDB Oracle Database in upgrade mode:startup upgrade
If errors appear listing desupported initialization parameters, then make a note of the desupported initialization parameters and continue with the upgrade. Remove the desupported initialization parameters the next time you shut down the database.
4. Exit SQL*Plus.
5. Check env parameters$ORACLE_HOME should point to new 19c home$ORACLE_SID should point to the same database id.
6. Run the Parallel Upgrade Utility
You can run the Parallel Upgrade Utility (catctl.pl) as a command-line shell command by using the dbupgrade shell command, which is located in Oracle_home/bin. If you set the PATH environment variable to include Oracle_home/bin, then you can run the command directly from your command line. For example:
dbupgrade -d /u01/app/oracle/19.1.0/dbhome_1
Note: Use the -l option to specify the directory that you want to use for spool log files.
Example :-dbupgrade -d /u01/app/oracle/19.1.0/dbhome_1 -d /u01/dbupgrade/
7. Restart the instance so that you reinitialize the system parameters for normal operation. The database is shut down after a successful upgrade.
STARTUP

Post Upgrade Steps

1. Run catcon.pl to start utlrp.sql, and to recompile any remaining invalid objects.$ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b utlrp -d '''.''' utlrp.sql
Because you run the command using -b utlrp, the log file utlrp0.log is generated as the script is run. The log file provides results of the recompile.
2. Run postupgrade_fixups.sql.@postupgrade_fixups.sql
3. Run utlusts.sqlThe script verifies that all issues are fixed.@$ORACLE_HOME/rdbms/admin/utlusts.sql
The log file utlrp0.log is generated as the script is run, which provides the upgrade results. You can also review the upgrade report in upg_summary.log.You can run this script multiple times.
4. Ensure that the time zone data files are current by using the DBMS_DST PL/SQL package to upgrade the time zone file. You can also adjust the time zone data files after the upgrade.
5. Exit from SQL*Plus
Additional reference:-https://oracledbwr.com/oracle-19c-database-upgrade-from-11-2-0-4-to-19-2-0-0-using-manual-method/https://oracle-base.com/articles/19c/upgrading-to-19c

Install 19.3 software only

Download Oracle 19.3 software from https://www.oracle.com/in/database/technologies/oracle-database-software-downloads.html
Installation :-
yum install -y oracle-database-preinstall-19c
mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1mkdir -p /u02/oradatachown -R oracle:oinstall /u01 /u02chmod -R 775 /u01 /u02
cd /u01/app/oracle/product/19.0.0unzip /media/LINUX_X64_193000_db_home.zip
You will find files zipped under 19.0.0
Run installer her
./runInstaller
Select "Set up software only"Enterprise editionSet Oracle Base. Inventory directory
Resolve any missing package missing
Check install

Page updated

Google Sites

Report abuse