This video is to mention high levels steps for applying psu patch on 12c database. Oracle12c clusterwaregrid oct 2017 psu patching step by step apply psu patch to cluster 12c. Icf hiring oracle dba in washington, district of columbia. Step by step apply rolling psu patch in oracle database. The type is generally specified in the patch metadata. Oracle rac patch 27107360 oracle grid infrastructure psu. In this article we are going to see oracle12cstep by step how to applying psu patch on oracle dataguard environment high level steps for applying the patch primary site disable the log shipping to the standby database and stop mrp on standby site shutdown standby database and listener apply psu patch on standby site shutdown primary database and listener. So before applying patch, we need to check whether the existing opatch version is supported for the patch or not. How to apply patch in oracle database ed chen logic. Keeping your database running with the newest release software might be a critical job for dba to implement.
How to apply psu patches on 2 node rac oracle community. Managing oracle software and applying patches oracle docs. Below are the steps for applying quarterly psu patch on oracle 11g database. For actual steps, always refer to readme file which is.
Applying psu in a data guard physical standby configuration. Applying crs psu, crs bundle, gi psu, windows bundles 10. In this example, systems a,b, and c are nodes in this oracle rac. To apply a patch set you use the oracle universal installer oui. To manage oracle software and apply patches in oracle real application clusters oracle rac environments, you use oracle. Since the first patch for oracle 12c has been made available i was of course keen to see how to apply it. When you apply a patch set, many different files and utilities are modified. Interim patch 19849140 is a superset of the patches 17077442 in the oracle home opatch will roll back the subset patches and apply the. This is the most efficient mode of applying an interim patch to an oracle rac setup because this results in no downtime. Stepbystep applying psu patch in oracle 12c for singleinstance check c urrent version of opatch tool. In this post, i will talk about the steps that we apply patch. Oracle rac applying and removing psus in grid infrastructure. To apply psu patch on physical standby database setup, 1st patch need to be applied on standby, and then on primary 1.
Step by step apply rolling psu patch in oracle database 12c rac environment step 5. The file should then be distributed to all rac nodes in your cluster. Maybe because theres no bash shell in your server due to some reason, or you just want to avoid any complications by opatchauto, or simply you like a more granular control over the patching process. Hi, i would like to know the all types of procedures auto, manual, rolling in order to apply psu patches on 2 node rac and how to apply patches in different homes in the cluster as well. For actual steps, always refer to readme file which is provided with patch.
Applying psu patch in a dataguard physical standby. Generic psu patching considerations helmuts rac jee blog. Stepbystep applying psu patch in oracle 12c for single. Rac dba interview questions on voting disk with live demo duration. A step by step manual psu patching october 2016 without using opatchauto why would you want to not use opatchauto. Oracle12cstep by step how to applying psu patch on oracle. I have a rac 12c standard cluster installed with 3 nodes. This results in a version change for your oracle software, for example, from oracle database 10. Steps to apply psu patch on oracle 11g database dbaclass. Icf is hiring an experienced oracle dba with knowledge of the oracle 11g, 12c multitenant, and rac for a key client in washington, dc.
852 1610 1127 425 1155 954 663 327 901 603 44 1323 55 132 1277 1102 334 306 1486 1362 1688 378 262 1339 1658 1643 1076 1654 1378 1209 1401 447 307 940 1368 139 664 1163 1365 392 416 680 790