This content has been marked as final. Show 3 replies
The same process will also work for 11gR2 (or any other release). Patch up to the latest patchset and CPU release, then run dbca to create your database.
Patch up to the latest patchset and CPU release, then run dbca to create your database.It depends on WHAT exactly you are doing with DBCA. As long as you are creating a database which has NO datafiles included (e.g. will be created with "create database" rather than using a template with datafiles already shipped) everything is fine. If you choose DBCA to use a template with datafiles shipped you have to apply at least the PSU/CPU patch instructions again.
The reason behind this is when installing a PSU or CPU or interim patch this patch does not update your dbca template datafiles. Only a patchset (i.e. 10.2.0.4.0 patchset or 126.96.36.199.0 patchset) will do.
My Blog: http://blog.ronnyegner-consulting.de
Thank you very much for prompt and complete relpy! I am trying to avoid patching of database software with database already created.
I am no fan of 'seed' databases, always creating custom one, so there should be no problem with CPU/PSU sql script not being part of template. I will check if data dictionary changes related to PSU were incorporated. At least it used to work in 9i, I wanted to know if same aplpiers to 11gR2.