Re: Installing 19c from scratch

Hi Marian,

thanks for the link. That leads to https://mikedietrichde.com/2017/05/25/dbca-execute-datapatch-oracle-database-12-2/ which states:

> please make sure you ALWAYS create a CUSTOM DATABASE. If you “create” a DWH or OLTP database it just copies a precreated database.
> It will have all options in it, and you’ll have to execute database -verbose manually.

I run dbca with "-templateName General_Purpose.dbc" which apparently is not a "custom database", so that's the reason I need to run datapatch after DBCA.

Thomas

Marián Bednár schrieb am 16.11.2021 um 14:19:
> 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 <mailto: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