Re: Installing 19c from scratch

Hi Thomas,

for 19c you don't need to run datapatch (is already part of dbca create database).

See here in more detail
https://mikedietrichde.com/2018/04/19/do-you-have-to-execute-datapatch-when-you-create-a-new-database/

M

ut 16. 11. 2021 o 14:05 Thomas Kellerer <dmarc-noreply_at_freelists.org> napísal(a):

> Hello,
>
> I am not a DBA, but frequently I have to install an Oracle database for
> development and test environments.
>
> So far I used the following approach to setup 19c from scratch:
>
> 1) runInstaller with "software only"
> 2) apply DB RU patch (e.g. 19.11)
> 3) apply the OJVM patch (e.g. 19.11)
> 4) run dbca to create the instance
>
> I always thought (assumed) that if I apply the patches _before_ creating
> the database, running datapatch wouldn't be necessary (because the database
> was created with the patched software).
>
> But at least in one occasion, this approach resulted in a PDB that would
> only start up in "RESTRICTED" mode.
> Only after running "datapatch -verbose" this was fixed.
>
> So my question is: is my assumption wrong, that I can skip the datapatch
> step if I install all patches prior to creating the database?
>
> Do I need to run "datapatch -verbose" after applying the RU and then after
> applying the OJVM patch despite the fact that I don't have a database yet?
>
> Regards
> Thomas
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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