Do you have to execute “datapatch” when you create a new database?

Thanks to Connor McDonald (Mr. AskTom) I learned today that one topic is not clear from our patches readmes: Do you have to execute “datapatch” when you create a new database? And it’s true. It does not get explained in the readme anywhere. Do you have to execute “datapatch” when you create a new database? If you never applied an Oracle patch bundles you may ask now: What is “datapatch” doing. And the answer is very simple. When you apply a patch bundle usually the patch does not include only binary files but also SQL changes, for instance a new…

Use your own templates in DBCA to create databases

Another advice regarding database creation: Use your own templates in DBCA to create databases. This way you can configure not only the options and components to create but also redo log layout, your set of parameters and much more. And it is less error prone than a “create database” script. Use your own template in DBCA Creating your own template in DBCA (Database Configuration Assistant) is quite easy and straight forward. In DBCA select “Manage Templates”: and create a new template: from an existing database template: Choose the “Custom Database” template as blueprint: Choose the components you’d like to have…