Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center