I have one query regarding applying a patch (interim,psu) in a 4 node RAC in rolling fashion. My question is while applying patch on one node I heard that we should down the instance and we will apply remaining nodes are up and running.
At that time what happens about the running sessions and how to force the new sessions to other node.(hope making changes in TNS entries) is that fine or please let me know any good way to do it. Thank you!