Oracle database administrator resume example indiana state. Application of quarterly cpu and psu patches for oracle databases. To install this psu, the oracle home must have the 11. Step by step apply rolling psu patch in oracle database 12c rac. Once a psu is applied, only psus can be applied in future quarters until the database is upgraded to a new base version. They are associated with particular releases and versions of oracle products.
The installation of new drivers requires a node reboot to continue the install. How to create an ocm response file for opatch silent installation. Apply psu patch to standard cluster 12c in this article, we will see how to apply psu patch to the standard cluster. Download oracle asm oneoff patch and apply it to oracle grid infrastructure using the opatch utility. One of the most important document is the readme that comes with the patch or patchset. He recently served as oracle database administrator. But the path to apply them is the same as for later bundles. The new opatch utility should be updated in all the oracle rac database homes and the gi. This is mainly oracle dba blog which also cover performance tuning, oracle cloud dbaas, oracle rac dataguard,active dataguard,rman and other topics like linux,aws,cassandra and other databases. Starting with introducing the oracle 12c rac architecture, this course will take you all the away from creating oracle 12c twonode rac databases on a linux platform of any type. February 11, 2016 february 22, 2016 mustak apps dba rac dba. Dec 10, 2016 this video is to mention high levels steps for applying psu patch on 12c database. Dba blog on oracle, oracle cloud,devops,postgresql and other databases.
Step by step apply rolling psu patch in oracle database 12c rac environment step 5. This patch allows you to apply patch to live database i. Following my previous post, here we will be applying the july 2016 psu patch. The opatch utility has automated the patch application for the oracle grid infrastructure gi home and the oracle rac. Vulnerabilities affecting oracle database and oracle fusion middleware may affect oracle fusion applications, so oracle customers should refer to oracle fusion applications critical patch update knowledge document, my oracle support note 1967316. Jan 26, 2017 applying psu patch on 12c database duration. Patch apply depends on the location where you need to apply patch, like grid home or oracle home. 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. Performed datapump for schema refresh, and rman for database refresh and for backing up databases.
Feb 11, 2016 mustak ahmed apps dba rac dba oracle application database administrator. Startup and shutdown of rac database oracle rac administration. Apr 03, 2012 ans you cannot use opatch auto to patch as oracle user, but you can patch it manually. Mar 08, 2015 apply psu patch on rac database slideshare uses cookies to improve functionality and performance, and to provide you with relevant advertising. Jan 20, 2018 psu patch on oracle rac 11g opatch is an oracle supplied utility that assists you with the process of applying interim patches to oracle s software and rolling back interim patches from oracle s software. This operation is used to apply a set of patches at a time.
About sher khan senior oracle dba, oracle 10g, oracle 11g oce, oracle 12c and oracle 11g opn certified specialist, ocp certified in oracle 9i,10g, 11g and 12c. Why opatch auto is not applying psu on database home. Applying psu apr 2017 patch on oracle 11gr2 two node rac. Apr 29, 2015 in order to apply a psu you need to have the opatch utility. Apply july psu 12c grid and db to an oracle 12c 2 node rac cluster. Server administration getting error while applying psu. Steps to apply psu patch on oracle 11g database below are the steps for applying quarterly psu patch on oracle 11g database. Jun 22, 2012 online patching is new feature introduced in 11. Stepbystep applying psu patch in oracle 12c for single.
Oracle 12c makes use of a new utility opatchauto to apply the patches unlike the opatch used in prior 12c versions. Step by step apply rolling psu patch in oracle database 19c rac environment. This article is aimed at showing the issues and resolution while applying the psu patch 11. Oct 29, 2014 in this post im demonstrating on the startegies involved in applying a psu patch on the grid home and the database home using a rolling fashion. Sep 03, 2011 dear gurus actually last time i applied a psu patch which i could apply as rolling patch but i shutdown database and all services and on node 1 of my rac i applied the patch. Jul 14, 2014 applying cpu patch on primary database server environment. Sep 10, 2015 cluster psu patch applying cluster psu patch 11. 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.
However you will have to ask root user to run the rootcrs. Grid and oracle psu patching using opatch 11gr2 rac. Adding patches to installation queue and performing prereq checks. Sep 22, 2012 about sher khan senior oracle dba, oracle 10g, oracle 11g oce, oracle 12c and oracle 11g opn certified specialist, ocp certified in oracle 9i,10g, 11g and 12c. Again, i wont copypaste all steps as the output is similar to the above. Read on to see how to create a process that preserves the original home. Oracles opatch utility enables the user to apply the patch successively to the different instances of the rac installation. Applying a psu patch in a large, complex cluster env. Step by step apply rolling psu patch in oracle database 19c rac. Apply july psu 12c grid and db to an oracle 12c 2 node.
Step by step apply rolling psu patch in oracle database. Applying the psu patch every quarterly for every prod and lower environment in the database and yearly on cluster using rolling fashion. Opatch will patch the local system then propagate the patch to the remote nodes. The example was on linux but steps are the same for other platforms. Applying psu apr 2017 patch on oracle 11gr2 two node rac this document will explain how to apply psu patch april2017 on oracle 11. Applying a psu patch on the gi home and the database home. I am documenting this as easy reference for people looking for steps. We have option to download and apply gi psu patch to both gi and rdbms homes as well because gi psu contains patch for both homes. 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. Jun 14, 2018 patching an oracle installation can be interesting, especially if the patch needs to be backed out. That is, the content of all previous psus is included in the latest psu patch. Apply 12c grid and db psu to oracle 12c 2 node rac. I would like to know whether its better to apply the april 2011 psu or july release.
Could any one please clarify these two questions of mine. Jul 14, 2014 applying cpu patch in a dataguard physical standby environment here is a brief explanation on how to apply cpucritical patch update in a dataguard environment in this demo, i am applying psu 11. If you continue browsing the site, you agree to the use of cookies on this website. May 31, 2019 in rac environment or oracle restart environment single node grid infrastructure installation, we would need to download gi psu to patch the grid infrastructure home. Applying psu patch on 12c rac in solaris oraclehelp. Patching can be cumbersome if you do not follow the procedure. Steps to apply psu patch on oracle 11g database dbaclass. Oracle dba interview questions and answers patching,cloning. If patch is for grid home then surely services will need to be stopped running from grid home. Apply psu patches to rac and single instance oracle db servers cruglobalansibleoraclepsu.
Depending on the psu you are applying this will dictate which version of opatch you need to use, please check the accompanying documentation in the psu folder. Patching all my environments with the january 2020 patch bundles. A step by step manual psu patching october 2016 without using opatchauto why would you want to not use opatchauto. Masking the critical sensitive data using oracle masking process and implement the fully automation of masking process using emcli tool. December 6, 2016 leave a comment on installing psu patch to oracle 12. I have a rac 12c standard cluster installed with 3 nodes. Ola festus okoh oracle database administrator charter. The opatch utility has automated the patch application for the oracle grid. Provide database implementation solutions, high availability solution, infrastructure and. This psu includes the fixes listed in bugs fixed by this patch.
Oracle issues product fixes for its software called patches. When opatchauto apply is run, it will first patch the rac homes. Below are the steps for applying psu patch on 12c rac in solaris. List of patches that have been applied on the grid home. For actual steps, always refer to readme file which is provided with patch. After downloading the patch, copy it to your both the nodes and unzip there. This node is part of an oracle real application cluster. Dec 26, 2019 oracle database enterprise edition version 12. Patching steps are different for different operating systems. The patching cycle involves downloading patches, applying patches, and verifying the applied patch to ensure that the bug fixes present in the patch reflect appropriately.
This feature is only available for rdbms home and can be installedenabled using opatch. How to apply psu patches on 2 node rac oracle community. Applying psu patch in an oracle 12c dataguard environment. So refer the readme file of the patch for the minimum supported version. Execute post installation scripts datapatch startup the database and listener. If the patch is related to oracle home there is no need to stop any service for grid home. Recently i had opportunity to apply psu to a rac environment in 12cr1 not pluggable database architecture on aix7. Think of these basics after successfully applying the latest psu 7 patch in two nonproduction and one production 11gr2 cluster environments, now its time to get ourselves more tougher and stronger.
367 1530 856 1100 452 1505 607 35 1512 1273 1175 267 1477 1084 642 972 424 1410 330 610 1067 1394 700 1366 1450 466 672 900 1166 90 160 1035 757 1374 1042 1220 1512 762 1276 980 680 166 375 937 6 711 381 379 1344