Hi,
I will explain Oracle 19c Database Upgrade From 18.9 to 19.8.0.0 on Exadata X7 in this article.
Oracle database 19c RAC installation is as follows, you can read it.
Oracle 19c Real Application Cluster (RAC) Step by Step Installation on Full Rack Exadata X7
I will use Manual Upgrade method while upgrading Oracle 19c.
If you don’t know Oracle database Upgrade methods and how to upgrade Oracle database, you should read following article.
Oracle Database Upgrade Guide and How to Upgrade Oracle Database
Manual upgrade steps should be as follows.
- Take Full backup
- Gather dictionary stats
- Purge Recycle bin
- Check Timezone
- Run Preupgrade
- Shutdown 18c Database and Open 19c instance in upgrade mode
- Upgrade database
- Run Post Upgrade steps
- Compile Invalid Objects.
- Start all Oracle 19c instances and check
Steps -1 : Take a Full backup via RMAN Tool. If you don’t know RMAN Backup, read following article.
https://ittutorial.org/oracle-rman-recovery-manager-backup-tutorials-3-full-backup-in-online-and-offline-mode-via-rman/
Steps -2: Gather dictionary stats like following.
SQL> EXEC DBMS_STATS.GATHER_DICTIONARY_STATS; PL/SQL procedure successfully completed.
Steps -3: Purge recycle bin.
SQL> PURGE DBA_RECYCLEBIN ; DBA Recyclebin purged.
Steps -4: Check Timezone before upgrade.
SQL> SELECT version FROM v$timezone_file; VERSION ---------- 18 SQL> SQL> SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) value 2 FROM DATABASE_PROPERTIES 3 WHERE PROPERTY_NAME LIKE 'DST_%' 4 ORDER BY PROPERTY_NAME; PROPERTY_NAME -------------------------------------------------------------------------------------------------------------------------------- VALUE ------------------------------------------------------------------------------------------------------------------------ DST_PRIMARY_TT_VERSION 18 DST_SECONDARY_TT_VERSION 14 DST_UPGRADE_STATE DATAPUMP(9)
Step -5: Run Preupgrade to check database if it is suitable for upgrade or not.
Preupgrade.jar is available under new 19c Oracle Home. You can run it like following.
java -jar /u01/app/oracle/product/19.0/dbhome_1/rdbms/admin/preupgrade.jar FILE DIR /u01/patch/ [DEVECI1]/u01/app/oracle/product/19.0/dbhome_1/jdk/bin $ java -jar /u01/app/oracle/product/19.0/dbhome_1/rdbms/admin/preupgrade.jar FILE DIR /u01/patch/ -================== PREUPGRADE SUMMARY ================== /u01/patch/preupgrade.log /u01/patch/preupgrade_fixups.sql /u01/patch/postupgrade_fixups.sql Execute fixup scripts as indicated below: Before upgrade: Log into the database and execute the preupgrade fixups @/u01/patch/preupgrade_fixups.sql After the upgrade: Log into the database and execute the postupgrade fixups @/u01/patch/postupgrade_fixups.sql Preupgrade complete: 2020-08-14T16:44:57 You have new mail in /var/spool/mail/oracle [DEVECI1]/u01/app/oracle/product/19.0/dbhome_1/jdk/bin $
You should run preupgrade_fixups.sql after preupgrade.jar.
SQL> @@/u01/patch/preupgrade_fixups.sql Executing Oracle PRE-Upgrade Fixup Script Preup Preupgrade Action Issue Is Number Preupgrade Check Name Remedied Further DBA Action ------ ------------------------ ---------- -------------------------------- 1. pending_dst_session NO Manual fixup required. 2. parameter_obsolete NO Manual fixup recommended. 3. invalid_objects_exist NO Manual fixup recommended. 4. apex_manual_upgrade NO Manual fixup recommended. 5. trgowner_no_admndbtrg NO Informational only. Further action is optional. 6. tablespaces_info NO Informational only. Further action is optional. 7. parameter_deprecated 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. SQL> SQL>
Step -6: Set cluster_database parameter to False, then shutdown all Instances via srvctl command.
Then set Oracle 19c bash profile and open Oracle 19c instance in upgrade mode.
SQL> alter system set cluster_database=false scope=spfile sid='*'; System altered. [DEVECI1] $ srvctl stop database -d DEVECI SQL> startup upgrade ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE instance started. Total System Global Area 1.0573E+11 bytes Fixed Size 29906232 bytes Variable Size 4.6976E+10 bytes Database Buffers 5.8519E+10 bytes Redo Buffers 207720448 bytes Database mounted. Database opened. SQL> SQL>
Step -7: After open database in upgrade mode, run catctl.pl and catupgrd.sql to upgrade database.
[DEVECI1] $ nohup $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catctl.pl -d $ORACLE_HOME/rdbms/admin -l /home/oracle/ -n 96 catupgrd.sql & Argument list for [/u01/app/oracle/product/19.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 = /u01/app/oracle/product/19.0/dbhome_1/rdbms/admin Echo OFF e = 1 Simulate E = 0 Forced cleanup F = 0 Log Id i = 0 Child Process I = 0 Log Dir l = /home/oracle/ Priority List Name L = 0 Upgrade Mode active M = 0 SQL Process Count n = 96 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.8.0.0.0DBRU_LINUX.X64_200702] /u01/app/oracle/product/19.0/dbhome_1/rdbms/admin/orahome = [/u01/app/oracle/product/19.0/dbhome_1] /u01/app/oracle/product/19.0/dbhome_1/bin/orabasehome = [/u01/app/oracle/product/19.0/dbhome_1] catctlGetOraBaseLogDir = [/u01/app/oracle/product/19.0/dbhome_1] Analyzing file /u01/app/oracle/product/19.0/dbhome_1/rdbms/admin/catupgrd.sql Log file directory = [/home/oracle/] catcon::set_log_file_base_path: ALL catcon-related output will be written to [/home/oracle/catupgrd_catcon_336997.lst] catcon::set_log_file_base_path: catcon: See [/home/oracle/catupgrd*.log] files for output generated by scripts catcon::set_log_file_base_path: catcon: See [/home/oracle/catupgrd_*.lst] files for spool files, if any Number of Cpus = 96 Database Name = DEVECI DataBase Version = 18.0.0.0.0 Parallel SQL Process Count = 8 Components in [DEVECI] Installed [APEX APS CATALOG CATJAVA CATPROC CONTEXT JAVAVM ORDIM OWM RAC SDO XDB XML XOQ] Not Installed [DV EM MGW ODM OLS WK] DataBase Version = 18.0.0.0.0 ------------------------------------------------------ Phases [0-107] Start Time:[2020_08_15 10:09:58] ------------------------------------------------------ *********** Executing Change Scripts *********** Serial Phase #:0 [DEVECI] Files:1 Time: 31s *************** Catalog Core SQL *************** Serial Phase #:1 [DEVECI] Files:5 Time: 19s Restart Phase #:2 [DEVECI] Files:1 Time: 6s *********** Catalog Tables and Views *********** Parallel Phase #:3 [DEVECI] Files:19 Time: 6s Restart Phase #:4 [DEVECI] Files:1 Time: 8s ************* Catalog Final Scripts ************ Serial Phase #:5 [DEVECI] Files:7 Time: 8s ***************** Catproc Start **************** Serial Phase #:6 [DEVECI] Files:1 Time: 9s ***************** Catproc Types **************** Serial Phase #:7 [DEVECI] Files:2 Time: 9s Restart Phase #:8 [DEVECI] Files:1 Time: 7s **************** Catproc Tables **************** Parallel Phase #:9 [DEVECI] Files:67 Time: 7s Restart Phase #:10 [DEVECI] Files:1 Time: 8s ************* Catproc Package Specs ************ Serial Phase #:11 [DEVECI] Files:1 Time: 33s Restart Phase #:12 [DEVECI] Files:1 Time: 8s ************** Catproc Procedures ************** Parallel Phase #:13 [DEVECI] Files:94 Time: 4s Restart Phase #:14 [DEVECI] Files:1 Time: 7s Parallel Phase #:15 [DEVECI] Files:121 Time: 5s Restart Phase #:16 [DEVECI] Files:1 Time: 8s Serial Phase #:17 [DEVECI] Files:22 Time: 3s Restart Phase #:18 [DEVECI] Files:1 Time: 5s ***************** Catproc Views **************** Parallel Phase #:19 [DEVECI] Files:32 Time: 7s Restart Phase #:20 [DEVECI] Files:1 Time: 7s Serial Phase #:21 [DEVECI] Files:3 Time: 8s Restart Phase #:22 [DEVECI] Files:1 Time: 7s Parallel Phase #:23 [DEVECI] Files:25 Time: 81s Restart Phase #:24 [DEVECI] Files:1 Time: 8s Parallel Phase #:25 [DEVECI] Files:12 Time: 52s Restart Phase #:26 [DEVECI] Files:1 Time: 8s Serial Phase #:27 [DEVECI] Files:1 Time: 0s Serial Phase #:28 [DEVECI] Files:3 Time: 3s Serial Phase #:29 [DEVECI] Files:1 Time: 0s Restart Phase #:30 [DEVECI] Files:1 Time: 7s *************** Catproc CDB Views ************** Serial Phase #:31 [DEVECI] Files:1 Time: 2s Restart Phase #:32 [DEVECI] Files:1 Time: 8s Serial Phase #:34 [DEVECI] Files:1 Time: 0s ***************** Catproc PLBs ***************** Serial Phase #:35 [DEVECI] Files:294 Time: 14s Serial Phase #:36 [DEVECI] Files:1 Time: 0s Restart Phase #:37 [DEVECI] Files:1 Time: 7s Serial Phase #:38 [DEVECI] Files:6 Time: 5s Restart Phase #:39 [DEVECI] Files:1 Time: 7s *************** Catproc DataPump *************** Serial Phase #:40 [DEVECI] Files:3 Time: 43s Restart Phase #:41 [DEVECI] Files:1 Time: 7s ****************** Catproc SQL ***************** Parallel Phase #:42 [DEVECI] Files:13 Time: 49s Restart Phase #:43 [DEVECI] Files:1 Time: 6s Parallel Phase #:44 [DEVECI] Files:11 Time: 7s Restart Phase #:45 [DEVECI] Files:1 Time: 8s Parallel Phase #:46 [DEVECI] Files:3 Time: 3s Restart Phase #:47 [DEVECI] Files:1 Time: 7s ************* Final Catproc scripts ************ Serial Phase #:48 [DEVECI] Files:1 Time: 32s Restart Phase #:49 [DEVECI] Files:1 Time: 8s ************** Final RDBMS scripts ************* Serial Phase #:50 [DEVECI] Files:1 Time: 5s ************ Upgrade Component Start *********** Serial Phase #:51 [DEVECI] Files:1 Time: 2s Restart Phase #:52 [DEVECI] Files:1 Time: 7s ********** Upgrading Java and non-Java ********* Serial Phase #:53 [DEVECI] Files:2 Time: 491s ***************** Upgrading XDB **************** Restart Phase #:54 [DEVECI] Files:1 Time: 5s Serial Phase #:56 [DEVECI] Files:3 Time: 8s Serial Phase #:57 [DEVECI] Files:3 Time: 5s Parallel Phase #:58 [DEVECI] Files:10 Time: 8s Parallel Phase #:59 [DEVECI] Files:25 Time: 9s Serial Phase #:60 [DEVECI] Files:4 Time: 7s Serial Phase #:61 [DEVECI] Files:1 Time: 0s Serial Phase #:62 [DEVECI] Files:32 Time: 6s Serial Phase #:63 [DEVECI] Files:1 Time: 0s Parallel Phase #:64 [DEVECI] Files:6 Time: 8s Serial Phase #:65 [DEVECI] Files:2 Time: 15s Serial Phase #:66 [DEVECI] Files:3 Time: 20s **************** Upgrading ORDIM *************** Restart Phase #:67 [DEVECI] Files:1 Time: 8s Serial Phase #:69 [DEVECI] Files:1 Time: 4s Parallel Phase #:70 [DEVECI] Files:2 Time: 25s Restart Phase #:71 [DEVECI] Files:1 Time: 8s Parallel Phase #:72 [DEVECI] Files:2 Time: 4s Serial Phase #:73 [DEVECI] Files:2 Time: 4s ***************** Upgrading SDO **************** Restart Phase #:74 [DEVECI] Files:1 Time: 8s Serial Phase #:76 [DEVECI] Files:1 Time: 111s Serial Phase #:77 [DEVECI] Files:2 Time: 4s Restart Phase #:78 [DEVECI] Files:1 Time: 8s Serial Phase #:79 [DEVECI] Files:1 Time: 32s Restart Phase #:80 [DEVECI] Files:1 Time: 8s Parallel Phase #:81 [DEVECI] Files:3 Time: 22s Restart Phase #:82 [DEVECI] Files:1 Time: 8s Serial Phase #:83 [DEVECI] Files:1 Time: 6s Restart Phase #:84 [DEVECI] Files:1 Time: 8s Serial Phase #:85 [DEVECI] Files:1 Time: 10s Restart Phase #:86 [DEVECI] Files:1 Time: 8s Parallel Phase #:87 [DEVECI] Files:4 Time: 35s Restart Phase #:88 [DEVECI] Files:1 Time: 8s Serial Phase #:89 [DEVECI] Files:1 Time: 4s Restart Phase #:90 [DEVECI] Files:1 Time: 8s Serial Phase #:91 [DEVECI] Files:2 Time: 9s Restart Phase #:92 [DEVECI] Files:1 Time: 7s Serial Phase #:93 [DEVECI] Files:1 Time: 2s Restart Phase #:94 [DEVECI] Files:1 Time: 7s ******* Upgrading ODM, WK, EXF, RUL, XOQ ******* Serial Phase #:95 [DEVECI] Files:1 Time: 11s Restart Phase #:96 [DEVECI] Files:1 Time: 7s *********** Final Component scripts *********** Serial Phase #:97 [DEVECI] Files:1 Time: 3s ************* Final Upgrade scripts ************ Serial Phase #:98 [DEVECI] Files:1 Time: 331s ******************* Migration ****************** Serial Phase #:99 [DEVECI] Files:1 Time: 2s *** End PDB Application Upgrade Pre-Shutdown *** Serial Phase #:100 [DEVECI] Files:1 Time: 2s Serial Phase #:101 [DEVECI] Files:1 Time: 0s Serial Phase #:102 [DEVECI] Files:1 Time: 80s ***************** Post Upgrade ***************** Serial Phase #:103 [DEVECI] Files:1 Time: 575s **************** Summary report **************** Serial Phase #:104 [DEVECI] Files:1 Time: 3s *** End PDB Application Upgrade Post-Shutdown ** Serial Phase #:105 [DEVECI] Files:1 Time: 2s Serial Phase #:106 [DEVECI] Files:1 Time: 0s Serial Phase #:107 [DEVECI] Files:1 Time: 35s ------------------------------------------------------ Phases [0-107] End Time:[2020_08_15 10:53:23] ------------------------------------------------------ Grand Total Time: 2606s LOG FILES: (/home/oracle//catupgrd*.log) Upgrade Summary Report Located in: /home/oracle//upg_summary.log Grand Total Upgrade Time: [0d:0h:43m:26s]
Step -8: run Post upgrade task on Oracle 19c like following.
SQL> @/u01/patch/postupgrade_fixups.sql
Step -9: Run utlrp.sql to compile all invalid objects.
SQL> @utlrp.sql
Step -10: Start all Oracle 19c instances and check.
Set cluster_database to true again for all instances startup.
SQL> alter system set cluster_database=true scope=spfile sid='*'; System altered. SQL>
After set cluster_database true, then you can startup all Oracle 19c instances.
[DEVECI1] $ srvctl upgrade database -d DEVECI -o /u01/app/oracle/product/19.0/dbhome_1 [DEVECI1] $ srvctl modify database -d DEVECI -o /u01/app/oracle/product/19.0/dbhome_1 [DEVECI1] $ srvctl start database -d DEVECI
Database upgrade is completed now.
Do you want to learn Oracle Database 20c New Features, then read the following articles.
Oracle 20c New Features and Step by Step Installation Oracle Database 20c on Linux