Re: Datapatch while users/applications are connected?

It depends :)

When patching the RU and OJVM we do under "startup upgrade" for single instance enviroments. No application processes or users connected at this time.

For single instance RU but no OVJM - run datapatch with application processes and users online after startup of the database.

For RAC environments we shutdown the application processes that use OJVM and do rolling GI + DB binary and then run datapatch "online". This approach has worked well - with the pre-condition that we are able to disconnect any sessions using OJVM prior.

On 15 Dec 2022 at 4:45 AM +1100, Chris Taylor <christopherdtaylor1994_at_gmail.com>, wrote:
> I've got a guy telling me its perfectly fine to run datapatch on a database while users & applications have reconnected.   (In this example, patching from 19.14 to 19.17)
>
> How many of you guys do that?
>
> I understand from reading about it that you _can_ do that.  I don't understand _why_ you would do that?
>
> What if datapatch runs into an exception?
>
> Is it not risky to allow users and applications into the database before the all the steps are finished?
>
> I'm wondering if I'm missing something here I guess?
>
> Thanks,
> Chris
>

--
http://www.freelists.org/webpage/oracle-l