Opatch utility is used to apply patch to the database so before applying the patch you must check whether the existing Opatch is supported for the patch or not. You must use the OPatch utility version 12.2.0.1.14 or later to apply this patch. Oracle recommends that you use the latest rel...
To apply psu patch on physical standby database setup, 1st patch need to be applied on standby, and then on primary. Below are the steps.Download patch from oracle support. 1.Check the database_role for both dbs PRIMARY> select database_role from v$database; DATABASE_ROLE --- PRIMARY ...
To patch DBCS with Data Guard. We need to first apply the patch on the standby database then the primary. Follow below steps for applying the patch. Step -1Run the precheck for the patch on the standby database. Go to the standby database console and click on Updates on Resources tab...
Each guest domain that runs Oracle Database should have a minimum of 16 CPUs (2 CPU cores) and 4 GB of memory. Each control domain that provides virtual devices (virtual disk and virtual network) to an Oracle Database single-instance guest domain should have a minimum of 8 CPUs (1 CPU...
In this article I will explain how to install/upgrade OPatch utility in grid_home and oracle_home in a RAC infrastructure. Opatch utility is used while applying patches to the database. Every readme file (that comes with patch), mention the recommended opatch version. If your existing opatch...
I downloaded the "Critical Patch Update (CPU) Program July 2018 Patch Availability Document (PAD) (Doc ID 2394520.1)". (See the attached picture called "Oracle Patch Availability".) This document identifies a patch for my "Oracle Database Client home" and provides a link topatch 25171037. ...
Version requirements may also come into play here. PTFs were added in Oracle Database 18c, whereas table SQL macros are first available in 19.6. But this should pose little concern.Support has ended for 18c, so if you're using this you should be moving to an up-to-date patch of 19c ...
Oracle Database Cloud Schema Service - Version N/A and later Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later Information in this document applies to any platform. GOAL How to reload DATAPUMP utility? This may be required in different situations...
But please be aware those pre-11g Oracle databases require a patch to work properly with V11 Gateways. The patch can be found on My Oracle Support by performing a simple search under the 'Patches & Updates' tab at the top of the page. Choose 'Simple Search' and enter 5965763 in the ...
How to Deinstall and Reinstall XML Database (XDB) [ID 243554.1] Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 10.2.0.5 Oracle Server - Personal Edition - Version: 9.2.0.1 to 10.2.0.5 Oracle Server - Standard Edition - Version: 9.2.0.1 to 10.2.0.5 ...