Re: Datapatch while users/applications are connected?
Date: Wed, 14 Dec 2022 18:51:08 -0500
Message-ID: <9d783f66-dece-c4b1-b175-14ac3d4d3c0c_at_gmail.com>
On 12/14/22 13:52, Ilmar Kerm wrote:
> RAC is patched in rolling fashion, so nothing should be down for users
> in any point in time. This includes datapatch.
> Even with single instance - if no/minimal downtime is desired, there
> really is no other option.
> Monitor datapatch execution like any other database session - it has
> happened for me a few times that for example long running
> DBMS_SCHEDULER jobs lock the package while datapatch wants to replace
> the package - so datapatch will start waiting for a lock.
How will you run "opatch" on the running instance? If my memory serves me right, it is necessary to run "opatch" before "datapatch". On a single instance, it is necessary to bring the instance down. There is no rolling upgrade of a single instance DB.
-- Mladen Gogala Database Consultant Tel: (347) 321-1217 https://dbwhisperer.wordpress.com -- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 15 2022 - 00:51:08 CET