Online patching uses the latest feature of the oracle database 11gr2 which is called. 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. Decide whether you want to patch the nodes one by one, using the rolling methodology, or all at a time, in parallel, using the all nodes methodology. To patch the primary and the standby database, follow these steps. To learn about patching oracle rac nodes individually in online mode, see patching oracle rac. Critical patch updates, security alerts and bulletins. This post describes how to identify the required patches for your oracle products. Oracle dataguard configuration in this article, we are going to discuss about oracle dataguard configuration, to configure oracle dataguard we need to install oracle rdbms software with one database on the primary production server and on standby server need to install only rdbms software without any database. The rolling upgrade refers to upgrading different databases or different instances of the same database in a real application clusters environment one at a time, without stopping the database. A step by step manual psu patching october 2016 without using opatchauto why would you want to not use opatchauto. Oracle 11g to 12c step by step database upgrade 11204 to 12101. How to install oracle 11g r2 step by step on linux. In this article discus about oracle 11g r2 database server for this server minimum 2 gb swap size and selinuxpermissive. The dba must perform all of the seven steps listed above.
Download oracle database software from oracle website, it is download in two parts zip file. Step by step apply rolling psu patch in oracle database. Quarterly psu patching in rac 11gr2 oracle community. Oracle recommends that you use the latest released opatch version for 11. Steps to apply psu patch on oracle 11g database dbaclass. In this article we will see how to apply the psu patch in oracle database 11gr2 in windows server. Now we have to download a cpu patch from my oracle support. Applying psu apr 2017 patch on oracle 11gr2 two node rac. Patch 11gr2 grid infrastructure standalone oracle restart. Quick reference to patchset patch numbers id 753736.
Patching can be cumbersome if you do not follow the procedure. How to apply cpu patch in oracle 11gr2 rac how to apply cpu patch in oracle 11gr2 rac. In case rollback of a patch is required, perform the below rollback steps. Step by step applying psu patch in oracle 11gr2 in windows. Oracle dataguard configuration step by step ocptechnology. Applying 11gr2 database patch tips and tricks for the. If it is aix server then use below command to check the bit version. Performing reinstating a failed oracle 2 node rac primary database step by step oracle 11gr2 rac standby database manual failover step by step oracle 11gr2 rac standby database switchover step by step configuration of oracle 11gr2 two node rac dataguard setup voting disk in oracle rac database oracle cluster registry in rac ocr. Stepbystep one node rac applying psu patch on 12c grid.
Applying psu patch in a dataguard physical standby. But as per our readme document, the minimum opatch utility version shoul be 12. On the main my oracle support page, click patches and updates tab. The new opatch utility should be updated in all the oracle rac database.
Oracle 11g to 12c step by step database upgrade 11204 to 12101 manual upgrade process duration. In this video, you will learn how to apply patch in oracle data guard 11g environment. Apply latest psu patch on oracle 11gr2 hello guys, here are the below step to apply latest psu patch to you databases running on asm file system. Critical patch updates, security alerts and bulletins oracle. Richard niemiec rac one node represents an oracle rac database that runs only one active oracle database and can be managed using server control utility svrctl as any oracle rac database. The grid patch is being installed here is 24436338 this article contains mostly the high level steps. In 11gr2, in order to patch the grid infrastructure, you must first unlock the grid infrastructure home, patch it and then relock it again. The oracle client installation and patching process are now complete. Downloading and installing patch updates oracle help center. This article describes the installation of oracle database 11g release 2 11. 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.
About oracle 11gr2 rac one node and rac patching by. For binaries backup login with db owner with root accessuse sudo if sudo access available for this command. The 11g weblogic patches are applied using the bsu utility. Java project tutorial make login and register form step by step using netbeans and mysql database duration. Patch 11gr2 grid infrastructure standalone oracle restart doc id 1089476. In this article we are going to see oracle12cstepbystep applying psu patch in oracle 12c for singleinstance high level steps. Applying psu apr 2017 patch on oracle 11gr2 two node rac this document will explain how to apply psu patch april2017 on oracle 11. For linux installation see my linux installation post or video. In the patch search group, select product or family advanced. Four outages need to be planned and the dba has to take the risk of patching an oracle home inplace four times.
Scheduling is easy since each oracle home patch is independent of the others. Check the operating system bit version 32 bit or 64 bit. How to apply cpu patch in oracle 11gr2 rac what is cpu patch. 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. Critical patch update cpu patches are cumulative, which means fixes from previous oracle security alerts and critical patch updates are included. Step 4 is where the opatch utilities come into play. To patch a standalone oracle database in offline mode, follow the steps. Oracle asm patching using opatch auto utility is a very common activity for oracle dbas.
Step by step applying psu patch in oracle 11gr2 in windows environment 1 prerequisites to apply patch. This is single instance database with asm file system. During online patching, business application users continue using the oracle application and simultaneously a patch or a sequence of patches can be applied to another. Apply 12c grid and db psu to oracle 12c 2 node rac. Oracle recommends that you use the latest released opatch version for 12. In this post i have tried to capture all the steps need to be performed to patch oracle asmgrid and rdbms homes in one go. Bring down the instance on each node and run the rollback command. We have linux x8664 servers on which oracle 11gr2 was installed and below patches were installed, last year, as follows. Oracle psu patching oracle 11gr2 grid environment 3. Download and unzip patch 7210195 to x drive same drive as your oracle home 5.
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. Oracle asm patching stepbystep approach monishs dba blog. Online patching uses the latest feature of the oracle database 11gr2 which is called edition based redefinition and also uses multiple file systems on the application side. When you perform minimum downtime patching in this cluster, you shut down set 1 and apply a patch to it. 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 identify the primary and standby database. To learn about patching oracle rac in offline mode, see patching oracle rac in offline mode. Stepbystep applying psu patch in oracle 12c for singleinstance. In this example, systems a,b, and c are nodes in this oracle rac. If you are wish to applying rolling cpu patch on rac, then the following steps must be following. I may have skipped some minor step here and there but thats the basic. If the dba uses a cloned gold copy and moves the gold copy to each server, time can be saved. Restart all oracle services and execute iisreset in a command prompt window.
1409 410 15 502 743 428 1238 48 236 1297 527 769 796 109 886 1536 213 816 1110 60 840 956 1054 642 525 1364 407 577 1272 1358 1423 421 799 1475