Is it neccesary to shut down the Database instance before applying Oracle DB Patches?
Hello all,
I am hoping for a little clarification on the topic of applying Security bundle patches to the Oracle Database. I am currently trying to create an automation script that will perform the prerequisite steps needed to apply Oracle patches. The basic breakdown of what my automation script does is the following:
-Stop all Oracle related services, as well as Distributed transaction coordinator, and Windows Management Instrumentation
-Check the OPatch version, and upgrade to the latest if it is outdated
-Check the Oracle Database version (since we patch 12c and 19c instances)
-Extract the apporpirate DB version's patch zip file, and call opatch from the patch directory