DBCA does not call 'datapatch' for database changes in 12.1.0.X.

DBCA does not call 'datapatch' for database changes in 12.1.0.X.

After creating a new database make sure to check DB register patch set level.

select PATCH_ID, PATCH_UID, VERSION, STATUS, DESCRIPTION
from DBA_REGISTRY_SQLPATCH
order by BUNDLE_SERIES;

no rows selected

whereas opatch lsinventory shows the patch installed

Patch description: “Database Patch Set Update : 12.1.0.2.5 (21359755)”

Solution

DBCA doesn't execute datapatch in Oracle 12.1.0.X. The solution is to apply the SQL changes manually after creating a new Database .

After creating a new database make sure to run:

cd $ORACLE_HOME/OPatch
./datapatch -verbose

then check DBA_REGISTRY_SQLPATCH view

With a multitenant database datapatch is run for all pluggable databases automatically, which are opened for writing, and for the PDB$SEED as well. No need to run datapatch for PDBs that you create afterwards from the template.