Apr 28, 2019 applying database patch opatch below are the steps for applying quarterly psu patch on oracle 11g database. The following solutions apply to problems with patching and rollback operations on. Psu contains many proactive and stabilization fixes for issues that you may have already encountered or will encounter in the near future. To patch the primary and the standby database, follow these steps. Portuguese brazil starting at october 2014, all the db psu come along with the ojvm psu option on the main download page doc id 756671. One of the most important document is the readme that comes with the patch or patchset for this writeup, i will be patching grid home version 12. Opatch tool replaces software files but does not modify database catalog. How to apply psu patch on standby database dbaclass. Oracle 12c makes use of a new utility opatchauto to apply the patches unlike the opatch used in prior 12c versions. Sep 07, 2015 steps for apply patches in oracle 11gr2 11. When you apply a patch bundle usually the patch does not include only binary files but also sql changes, for instance a new package.
Check the operating system bit version 32 bit or 64 bit. To apply psu patch on physical standby database setup, 1st patch need to be applied on standby, and then on primary. The name of these bundle patches was changed to database proactive bundle patch in april 2016. Sep 20, 2012 here is a brief explanation on how to apply psu patch set update in a dataguard environment in this demo, i am applying psu 11. Applying psu apr 2017 patch on oracle 11gr2 two node rac. Applying database patch opatch below are the steps for applying quarterly psu patch on oracle 11g database. Patching can be cumbersome if you do not follow the procedure. I am applying the patch on a 2node rac in a rolling mode. Applying psu patch in an oracle 12c dataguard environment. Applying cpu patch on dataguard physical standby configuration. Query the last patch applied on database 11g, 12cr1, 12cr2 and. Apply psu patch on rac database linkedin slideshare.
Apply psu patch on rac database slideshare uses cookies to improve functionality and performance, and to provide you with relevant advertising. When you apply a patch set, many different files and utilities are modified. So before applying patch, we need to check whether the existing opatch version is supported for the patch or. Psu patch on oracle rac 11g opatch is an oraclesupplied utility that assists you with the process of applying interim patches to oracles software and rolling back interim patches from oracles software. Pdbdev patch 22291127 database patch set update 12. 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. An oracle psu contains recommended bug fixes and proactive cumulative patches, a nice change that makes it simple for the dba to chose to apply priority.
Oracle recommends to install both, as well as the generic jdbc patch that is also available there in this tutorial, i will show how to install the ojvm psu, db psu and jdbc patch in a 11. Steps to apply psu patch on oracle 12c database orahow. Do you have to execute datapatch when you create a new database. This results in a version change for your oracle software, for example, from oracle database 10. This is similar to till 11g and 12c they changed the process for loading the sql into database and we will be using another utility called datapatch. Patch set updates psu are the same cumulative patches that include both the security fixes and priority fixes. Apr 29, 2015 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. If you continue browsing the site, you agree to the use of cookies on this website. How to check which psu is installed on your database or.
Below are the steps for applying oracle jvm patch in 12c database. In this tutorial, i will show how to install the ojvm psu, db psu and jdbc patch in a 11. Customize the database patching deployment procedure as described in customizing patching deployment procedure to include additional steps to handle stopping and starting of log shipping with or without a broker. 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.
In this article we are going to see oracle12cstepbystep applying psu patch in oracle 12c for singleinstance. For binaries backup login with db owner with root accessuse sudo if sudo access available for this command. For actual steps, always refer to readme file which. Take backup of opatch folder on both gi and rdbms homes and keep recommended opatch folder as per document. That is, the content of all previous psus is included in the latest psu patch. Applying a patch set update requires modifying the catalog. This post discuss about how to upgrade rman catalog in 11gr2 after applying a psu patch note. Standby is in maximum performance mode with data broker enabled.
Apply july psu 12c grid and db to an oracle 12c 2 node rac cluster. Here is a brief explanation on how to apply psu patch set update in a dataguard environment in this demo, i am applying psu 11. Dec 09, 2015 steps for apply psu6 on oracle 11g database and grid home. Oct 10, 2012 how to check which psu is installedif any. Unfortunately they do not change version numbers in the oracle binaries, product banners and such though see mos 861152. This is not the database upgrade, this post provides information on the rman catalog upgrade for an database after a psu patch has been applied in the database server. Applying cpu patch in a dataguard physical standby database configuration. Following my previous post, here we will be applying the july 2016 psu patch. It can be used for container database pdb, cdb and standalone. Stepbystep applying psu patch in oracle 12c for single. Jun 28, 2016 the name of these bundle patches was changed to database proactive bundle patch in april 2016.
Apply 12c grid and db psu to oracle 12c 2 node rac. I will be sharing only the tested steps and not the outputs. Steps are the same, only difference is we will be apply an psu on top of another psu. It means that oracle is a software and it is hard to hear, but oracle database has bugs. If it is aix server then use below command to check the bit version. Apply july psu 12c grid and db to an oracle 12c 2 node. These fixes will have the information learned from issues that have been encountered by oracle customers. If you never applied an oracle patch bundles you may ask now. Nov 03, 2017 applying oracle psu patch on aix server with oracle 12.
Below are the steps for applying quarterly psu patch on oracle 11g database. Step by step apply rolling psu patch in oracle database 19c rac. For this writeup, i will be patching grid home version 12. High level steps for applying the patch in windows. This operation is used to apply a set of patches at a time. In order to apply a psu you need to have the opatch utility.
Oracle rac applying psu to grid home and db home mustak. Oracle database plsql training program at sterlite tech elitecore. Patching primary and standby databases configured with oracle. Oracle clusterware installed real application clusters components. Howto apply ojvm psu, db psu and generic jdbc patch in 11. The key with psus is they are minor version upgrades e. How can i determine the obiee version after applying a bundle patch or critical patch update. In this blog post, i will show you the way and methodology for installing db psu and ojvm psu to a single instance 11. This video is to mention high levels steps for applying psu patch on 12c database. How to apply psu patch in oracle 12c database steps to. How to apply psu patch in oracle and patch apply steps. Apr 19, 2018 do you have to execute datapatch when you create a new database. I seen lot of questions in otn on patching of dataguard, recently i have applied cpu patch on production database, i like to give stepbystep procedure how to apply cpujan2012343244 standby is in maximum performance mode with data broker enabled.
First lets see how we can find psu and ojvm patches. A step by step manual psu patching october 2016 without using opatchauto. Do you have to execute datapatch when you create a new. How to upgrade rman catalog in 11gr2 after applying a psu. Oracle patch set update psu tips burleson consulting. 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. Oracle psus patch set updates are referenced by their 5place version number. May 23, 2016 patch set updates psu are the same cumulative patches that include both the security fixes and priority fixes. Steps to apply ojvm psu patch in oracle 12c database. I am documenting this as easy reference for people looking for steps. Patching my databases with the april 2018 psu, bp and ru.
This document will explain how to apply psu patch april2017 on oracle 11. Applying psu patch in a dataguard physical standby. I would be using lsinventory command because it shows many more details apart from database version. There are various method to check the database version. Every patch is different from another, so there is no rule for applying a patch. May 26, 2012 applying cpu patch in a dataguard physical standby database configuration i seen lot of questions in otn on patching of dataguard, recently i have applied cpu patch on production database, i like to give stepbystep procedure how to apply cpujan2012343244. Check the oracle database version where we have to apply the patch. Step by step applying psu patch in oracle 11gr2 in windows. Applying cpu patch on primary database server environment. Patching oracle 12c multitenant to latest psu now known as. So, on version 11g, after apply a psu patch on database, after run the script. Oracle12cstep by step how to applying psu patch on oracle.
To apply a patch set you use the oracle universal installer oui. In this article we will see how to apply the psu patch in oracle database 11gr2 in windows server. Dont follow this tutorial without reading the readme files inside patch folders. My attempt to roll back the april 2015 patch set update apr 2015 psu fails. Steps to apply psu patch on oracle 11g database dbaclass. Dec 10, 2016 this video is to mention high levels steps for applying psu patch on 12c database. Control connecting remotely to the database by using oracle sql developer. Psu also includes critical patch update cpu along with proactive stabilization fixes. Oracle recommends to install both, as well as the generic jdbc patch that is also available there. How can i determine the obiee version after applying a bundle.
How to enabledisable archivelog mode in oracle 11g 12c. Oracle database upgrades and migrations 3,850 views 6. How to check patches applied in oracle database orahow. To bookmark click on the star to the left of the title. Patching oracle 12c multitenant to latest psu now known. Once a psu is applied, only psus can be applied in future quarters until the database is upgraded to a new base version.
One of the most important document is the readme that comes with the patch or patchset. Applying oracle psu patch on aix server with oracle 12. Jul 18, 2018 oracle database upgrades and migrations 3,850 views 6. Nov 18, 2016 in this blog post, i will show you the way and methodology for installing db psu and ojvm psu to a single instance 11. Applying psu patch in a dataguard physical standby environment. To assist in locating an article of interest for future reference, consider adding a bookmark. As a sysdba you can also execute below command from the sql prompt to get the patch detail. 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. How can i determine the obiee version after applying a. Now we are going to apply april 2017 psu patch in oracle database version 11.