IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
Hi,
I will explain Oracle 18c RAC Database Upgrade From 12c (12.1.0.2) to 18c (18.7.0.0.0) on Full Rack Exadata in this article.
I will explain Upgrade from Oracle 12.1.0.2 to Oracle 18.3.0.0 ( 18c ), so you should install Oracle 18c database software before upgrade.
If you don’t know how to install Oracle 18c RAC Database software, you should read following article.
I will show Upgrade Database process on Eight Nodes RAC database.
https://ittutorial.org/oracle-real-application-cluster-rac-database-18c-step-by-step-installation-on-full-rack-exadata-x7/
Before upgrade database, I will apply 29757256 patch to the Oracle 18c RAC Home, thus our version will be 18.7 instead of 18.3. Latest Oracle database 18c patch is 29757256 for now.
So if you will use Oracle 18c database, you should apply 29757256 patch before upgrade or after Oracle 18c installation.
Download 29757256 patch and then upload it to the Exadata nodes.
Unzip patch and download latest OPatch tool to apply this patch.
You can apply this patch like following.
[DEVECI1]/u01/app18c/patch/29757256 $ /u01/app18c/OPatch/opatch apply Oracle Interim Patch Installer version 12.2.0.1.17 Copyright (c) 2019, Oracle Corporation. All rights reserved. Oracle Home : /u01/app18c Central Inventory : /u01/app/oraInventory from : /u01/app18c/oraInst.loc OPatch version : 12.2.0.1.17 OUI version : 12.2.0.4.0 Log file location : /u01/app18c/cfgtoollogs/opatch/opatch2019-08-02_21-39-06PM_1.log Verifying environment and performing prerequisite checks... -------------------------------------------------------------------------------- Start OOP by Prereq process. Launch OOP... Oracle Interim Patch Installer version 12.2.0.1.17 Copyright (c) 2019, Oracle Corporation. All rights reserved. Oracle Home : /u01/app18c Central Inventory : /u01/app/oraInventory from : /u01/app18c/oraInst.loc OPatch version : 12.2.0.1.17 OUI version : 12.2.0.4.0 Log file location : /u01/app18c/cfgtoollogs/opatch/opatch2019-08-02_21-39-17PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 29757256 Do you want to proceed? [y|n] Y (auto-answered by -silent) User Responded with: Y All checks passed. Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app18c') Is the local system ready for patching? [y|n] Y (auto-answered by -silent) User Responded with: Y Backing up files... Applying interim patch '29757256' to OH '/u01/app18c' ApplySession: Optional component(s) [ oracle.assistants.server.oui, 18.0.0.0.0 ] , [ oracle.has.crs, 18.0.0.0.0 ] , [ oracle.network.gsm, 18.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 18.0.0.0.0 ] , [ oracle.network.cman, 18.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 18.0.0.0.0 ] , [ oracle.net.cman, 18.0.0.0.0 ] , [ oracle.assistants.asm, 18.0.0.0.0 ] , [ oracle.crs, 18.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 18.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 18.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 18.0.0.0.0 ] , [ oracle.assistants.usm, 18.0.0.0.0 ] , [ oracle.ons.daemon, 18.0.0.0.0 ] , [ oracle.tfa, 18.0.0.0.0 ] , [ oracle.options.olap, 18.0.0.0.0 ] , [ oracle.jdk, 1.8.0.211.12 ] not present in the Oracle Home or a higher version is found. Patching component oracle.rdbms, 18.0.0.0.0... Patching component oracle.rdbms.rsf, 18.0.0.0.0... Patching component oracle.assistants.acf, 18.0.0.0.0... Patching component oracle.assistants.server, 18.0.0.0.0... Patching component oracle.ctx, 18.0.0.0.0... Patching component oracle.dbjava.ic, 18.0.0.0.0... Patching component oracle.dbjava.jdbc, 18.0.0.0.0... Patching component oracle.dbjava.ucp, 18.0.0.0.0... Patching component oracle.javavm.client, 18.0.0.0.0... Patching component oracle.ldap.owm, 18.0.0.0.0... Patching component oracle.ldap.rsf, 18.0.0.0.0... Patching component oracle.ldap.security.osdt, 18.0.0.0.0... Patching component oracle.network.rsf, 18.0.0.0.0... Patching component oracle.rdbms.dbscripts, 18.0.0.0.0... Patching component oracle.rdbms.install.common, 18.0.0.0.0... Patching component oracle.rdbms.install.plugins, 18.0.0.0.0... Patching component oracle.rdbms.oci, 18.0.0.0.0... Patching component oracle.sdo, 18.0.0.0.0... Patching component oracle.sdo.locator.jrf, 18.0.0.0.0... Patching component oracle.sqlplus, 18.0.0.0.0... Patching component oracle.oracore.rsf, 18.0.0.0.0... Patching component oracle.xdk.parser.java, 18.0.0.0.0... Patching component oracle.network.client, 18.0.0.0.0... Patching component oracle.install.deinstalltool, 18.0.0.0.0... Patching component oracle.ctx.atg, 18.0.0.0.0... Patching component oracle.oraolap, 18.0.0.0.0... Patching component oracle.rdbms.util, 18.0.0.0.0... Patching component oracle.rdbms.deconfig, 18.0.0.0.0... Patching component oracle.ons, 18.0.0.0.0... Patching component oracle.nlsrtl.rsf, 18.0.0.0.0... Patching component oracle.sqlplus.ic, 18.0.0.0.0... Patching component oracle.precomp.rsf, 18.0.0.0.0... Patching component oracle.xdk, 18.0.0.0.0... Patching component oracle.assistants.deconfig, 18.0.0.0.0... Patching component oracle.rdbms.rman, 18.0.0.0.0... Patching component oracle.duma, 18.0.0.0.0... Patching component oracle.server, 18.0.0.0.0... Patching component oracle.xdk.rsf, 18.0.0.0.0... Patching component oracle.network.listener, 18.0.0.0.0... Patching component oracle.ctx.rsf, 18.0.0.0.0... Patching component oracle.rdbms.crs, 18.0.0.0.0... Patching component oracle.rdbms.hsodbc, 18.0.0.0.0... Patching component oracle.oraolap.dbscripts, 18.0.0.0.0... Patching component oracle.ldap.rsf.ic, 18.0.0.0.0... Patching component oracle.sdo.locator, 18.0.0.0.0... Patching component oracle.nlsrtl.rsf.core, 18.0.0.0.0... Patching component oracle.rdbms.rsf.ic, 18.0.0.0.0... Patching component oracle.precomp.common, 18.0.0.0.0... Patching component oracle.precomp.lang, 18.0.0.0.0... Patch 29757256 successfully applied. Sub-set patch [27908644] has become inactive due to the application of a super-set patch [29757256]. Sub-set patch [28090523] has become inactive due to the application of a super-set patch [29757256]. Please refer to Doc ID 2161861.1 for any possible further required actions. Log file location: /u01/app18c/cfgtoollogs/opatch/opatch2019-08-02_21-39-17PM_1.log OPatch succeeded. [DEVECI1]/u01/app18c/patch/29757256 $
You should perform same steps on all nodes in the Exadata. I show for first node’s log, but you should apply this patch to all nodes on RAC environment.
I will continue to explain Oracle RAC database 18c upgrade in the next article.
Do you want to learn Oracle Database Performance Tuning detailed, then read the following articles.
https://ittutorial.org/oracle-database-performance-tuning-tutorial-12-what-is-the-automatic-sql-tuning-and-how-to-automated-sql-tuning/
