Upgrade Grid Infrastructure to 18.2 by applying RU

Database 18c Patch As of the Release date (17-Apr-2018), the only Oracle Database 18 software that is available is 18.1.0 for on-premise Exadata. Therefore, the following patches for Oracle Database 18 are only for on-premise Exadata systems that are running Oracle Database 18.1.0. More Info: Database 18 Proactive Patch Information (Doc ID 2369376.1) OPatch Utility Information You must […]

Read More

Upgrade Version to 18.2 from Oracle 18c by applying RU

Database 18c Patch As of the Release date (17-Apr-2018), the only Oracle Database 18 software that is available is 18.1.0 for on-premise Exadata. Therefore, the following patches for Oracle Database 18 are only for on-premise Exadata systems that are running Oracle Database 18.1.0. More Info: Database 18 Proactive Patch Information (Doc ID 2369376.1) OPatch Utility Information […]

Read More

Upgrading to Oracle Database 12cR2 Using Transient Logical Standby Method

Rolling upgrade with Transient Logical Standby is known as a MAA (Maximum Availability Architecture) technique, to minimize downtime during upgrade of Oracle database.  This note will document the steps for performing the Advanced Data Guard method of Transient Logical Rolling Upgrade. The following picture provides the general flow for an example migration of on-premise database […]

Read More

Upgrading Oracle Grid Infrastructure 11gR2 to 18c

Here I would be discussing how to upgrade Oracle 11gR2 (11.2.0.4) Grid Infrastructure to Oracle 18c (18.0.0.0) on the same server. This upgrade process was done on Linux 7 (x86_64). Before the GI upgrade backup the OCR manually. This could be used in downgrading the GI from 18.0.0.0 to 11.2.0.4 later one. If you want […]

Read More

Manual upgrading Oracle database 11gR2 to 18c

Manual upgrading Oracle database 11gR2 to 18c If you want to know how we upgrade an 11.2.0.4 database to 18.0.0.0.0 using DBUA, click here. This article explains how to upgrade 11.2.0.3 and above, and 12.1.0.1, 12.2.0.1 to 18.0.0.0.0 manually. Manually upgrading to 18c There are many DBAs who don’t want to follow the recommended way of an upgrade […]

Read More

Tablespaces Info for upgrading to 18c

To help you keep track of your tablespace allocations, the following AUTOEXTEND tablespaces are expected to successfully EXTEND during the upgrade process.

Minimum tablespace sizes for upgrade are estimates. Only Solution is to extend the tablespace.

Stay tuned for more articles on Oracle 18c  Thank you for giving your valuable time to read the […]

Read More

Upgrade Database from Oracle 11gR2 to Oracle 18c

Here I would be discussing how to upgrade Oracle 11gR2 (11.2.0.4) database to Oracle 18c(18.0.0.0.0) on the same server. This upgrade process was done on Linux 7 (x86_64). I used DBUA (Database Upgrade Assistant) to perform this upgrade. DBUA is also a recommended way to perform the upgrade as it would automate almost everything for you. You should be able to use the […]

Read More

Upgrade Apex for Oracle 18c

Starting with Oracle Database Release 18, APEX has not upgraded automatically as part of the database upgrade. Refer to My Oracle Support Note 1088970.1 for information about APEX installation and upgrades. To download the latest APEX: Click Here

Stay tuned for more articles on Oracle 18c  Thank you for giving your valuable time to read […]

Read More

Compile Fixed Objects

To upgrade from Oracle 11gR2 to Oracle 18c, we need to gather stat for fixed objects

Stay tuned for more articles on Oracle 18c  Thank you for giving your valuable time to read the above information. If you want to be updated with all our articles send us the Invitation or Follow us: Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/ […]

Read More

Remove OLAP for Oracle 18c

To upgrade from Oracle 11gR2 to Oracle 18c, we need remove OLAP. Remove OLAP Catalog by running the 11.2.0.4.0 SQL script $ORACLE_HOME/olap/admin/catnoamd.sql script.

Stay tuned for more articles on Oracle 18c  Thank you for giving your valuable time to read the above information. If you want to be updated with all our articles send us […]

Read More