Re: Installing 19c from scratch

OK, it makes sense, I have created "template db" only few times...

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

> 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
>
>
>

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