Re: Installing 19c from scratch

I always thought the same, if I create a "custom database" via DBCA, then it creates the database via scripts (not a clone of a pre-created database) so it should pick up the latest objects, etc. Now I recommend following the guidance of the CPU's readme file. Run datapatch after creating the new database. It's quick and hopefully saves me headaches down the road.

"3.4 Patch Post-Installation Instructions for Databases Created or Upgraded after Installation of this patch in the Oracle Home

On Oracle Database server, you must execute the steps in Section 3.3.2, "Loading Modified SQL Files into the Database" for any new database. There are no actions required for databases that have been upgraded. This is not required on Oracle Database client."

Mike

On 11/16/21, 8:33 AM, "Thomas Kellerer" <dmarc-noreply_at_freelists.org> wrote:

    Hi Marian,

    thanks for the link. That leads to https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmikedietrichde.com%2F2017%2F05%2F25%2Fdbca-execute-datapatch-oracle-database-12-2%2F&amp;data=04%7C01%7Cmikejp%40buffalo.edu%7C572aab35d27a426e214208d9a9056ba8%7C96464a8af8ed40b199e25f6b50a20250%7C0%7C0%7C637726663921058686%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=x4MovwmThH0Drq%2B0Lf2Uoj%2FmB7%2BeOhCf5qIUmJOGjwE%3D&amp;reserved=0 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://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fmikedietrichde.com%2F2018%2F04%2F19%2Fdo-you-have-to-execute-datapatch-when-you-create-a-new-database%2F&amp;data=04%7C01%7Cmikejp%40buffalo.edu%7C572aab35d27a426e214208d9a9056ba8%7C96464a8af8ed40b199e25f6b50a20250%7C0%7C0%7C637726663921058686%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=ACeOlotRjhLN1NCjJf6LkGaMlcZBZgoBtKPgpLSsj4w%3D&amp;reserved=0
>
> 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
> --
> https://nam12.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.freelists.org%2Fwebpage%2Foracle-l&amp;data=04%7C01%7Cmikejp%40buffalo.edu%7C572aab35d27a426e214208d9a9056ba8%7C96464a8af8ed40b199e25f6b50a20250%7C0%7C0%7C637726663921058686%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=x4EMMJeeDdMOZlGaf%2Br0%2Bu0pqheWEcX7a2SoTCP96PU%3D&amp;reserved=0
>
>
    --
    https://nam12.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.freelists.org%2Fwebpage%2Foracle-l&amp;data=04%7C01%7Cmikejp%40buffalo.edu%7C572aab35d27a426e214208d9a9056ba8%7C96464a8af8ed40b199e25f6b50a20250%7C0%7C0%7C637726663921058686%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&amp;sdata=x4EMMJeeDdMOZlGaf%2Br0%2Bu0pqheWEcX7a2SoTCP96PU%3D&amp;reserved=0

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




application/pkcs7-signature attachment: smime.p7s