Disclaimer

Friday 16 July 2021

Why unlocking and locking Grid Home during PSU patching in 11g R2

Without Grid ,cluster will not come .if cluster will not come up database too.

So, protection of cluster home is required from external modification.


The clusterware is more critical from a specific point of view.


Oracle Clusterware manage and support  all Oracle Databases, ASM, ACFS, Services, Customizable Applications and Networking.


If clusteware goes down due change on binaries, all these services also goes down.

It's does not mean RAC DATABASE binary is less important. From point of view USERS APPLICATION Database is more important, but DBA/SA view Oracle Clusterware is more important, because if it fail (due a change on GI binary) all services will be offline and whole infrastructure can goes down.


Small Enterprise with Oracle Clusterware and only one RAC installation it can be imperceptible.


Ans : Required unlock to modify the files by stopping the clusterware stack while patching.

 

When you run the rootcrs.pl script with the -unlock flag, it stops the Oracle Clusterware stack and unlocks the files in the Grid home so they can be modified.

 

cd /u01/app/11.2.0/grid/crs/install 
perl rootcrs.pl -unlock -crshome /u01/app/11.2.0/grid

The rootcrs.pl script with the -patch flag locks the Grid home again and restarts the Oracle Clusterware stack.



No comments:

Post a Comment

100 Oracle DBA Interview Questions and Answers

  Here are 100 tricky interview questions tailored for a Senior Oracle DBA role. These questions span a wide range of topics, including perf...