OK, it makes sense, I have created "template db" only few times...
ut 16. 11. 2021 o 14:32 Thomas Kellerer <dmarc-noreply@xxxxxxxxxxxxx>
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” aDWH 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,database).
for 19c you don't need to run datapatch (is already part of dbca create
https://mikedietrichde.com/2018/04/19/do-you-have-to-execute-datapatch-when-you-create-a-new-database/
See here in more detail
<mailto:dmarc-noreply@xxxxxxxxxxxxx>> napísal(a):
M
ut 16. 11. 2021 o 14:05 Thomas Kellerer <dmarc-noreply@xxxxxxxxxxxxx
for development and test environments.
Hello,
I am not a DBA, but frequently I have to install an Oracle database
creating the database, running datapatch wouldn't be necessary (because the
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_
database was created with the patched software).
would only start up in "RESTRICTED" mode.
But at least in one occasion, this approach resulted in a PDB that
Only after running "datapatch -verbose" this was fixed.datapatch step if I install all patches prior to creating the database?
So my question is: is my assumption wrong, that I can skip the
after applying the OJVM patch despite the fact that I don't have a database
Do I need to run "datapatch -verbose" after applying the RU and then
yet?
--
Regards
Thomas
--
//www.freelists.org/webpage/oracle-l
//www.freelists.org/webpage/oracle-l