Oracle 19c Database Upgrade From 18.9 to 19.8.0.0 on Exadata X7 | Oracle 19c Database Upgrade Manual Method

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.

  1. Take Full backup
  2. Gather dictionary stats
  3. Purge Recycle bin
  4. Check Timezone
  5. Run Preupgrade
  6. Shutdown 18c Database and Open 19c instance in upgrade mode
  7. Upgrade database
  8. Run Post Upgrade steps
  9. Compile Invalid Objects.
  10. 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

 

 855 views last month,  29 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience. I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource. I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks. I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients. If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com. -                                                                                                                                                                                                                                                 - Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

Check Also

blank

enq: TM – contention | TM Contention Wait Events in Oracle

Hi, I will explain enq: TM – contention | TM Contention Wait Events in Oracle …

Leave a Reply