The whole process is straightforward, but we can still see big difference between CPU patch and Upgrade in those post-installation script executions:
For CPU patch, we have to re-run those scripts if we:
* Using DBCA (Database Configuration Assistant) to select a sample database (General, Data Warehouse, Transaction Processing)
* Using a script that was created by DBCA that creates a database from a sample database
* Cloning a database that was created by either of the two preceding methods.
For upgrade, DBCA is part of upgrade, so only cloning database without applied post-installation scripts need redo actions.