After a patch has been applied, there will be things that will change. It is a good idea to perform a backup after the patch has been applied and keep it in a safe place in case the Oracle Home or the Oracle Inventory get compromised due to a media failure or accidental deletion in future.
Oracle databases can still be created using DBCA, but if the patch modified the structure or contents of the database dictionary, then you must be aware that these changes are not replicated against the seed databases. So if you are using DBCA to create a new database using the current seeds, the scripts or other post apply procedures must be manually applied against the new database. If you create a new database using the CREATE DATABASE
command, there is no need to apply the scripts that modify the database dictionary. These are already considered when the catproc.sql
or catalog.sql
scripts are run.
You should have a test plan so that after applying a patch you ensure...