DBCA (12.2) template for the Enterprise Manager Cloud Control 13c Release 2 repository DB
Enterprise Manager Cloud Control 13c Release requires a repository database, which can be either Oracle 12c Release 1 (12.1.0.2) or Oracle 12c Release 2. Unfortunately, Oracle provides only templates for Oracle 12c Release 1 on Technet (http://www.oracle.com/technetwork/oem/enterprise-manager/downloads/db-templates-3233309.html). So I created my own template from my small Linux-based OEM Repository database (12.2, Non-CDB).
DBCA 12.2 runs datapatch automatically
It was one of the issues with Oracle 12c Release 1 that datapatch was not executed by dbca automatically. So, if you had installed patches to your Oracle home before running dbca, dbca did not take this into consideration and ran datapatch to apply the SQL changes to the databases. In August 2015 Mike Dietrich…