DBCA Fails With Template Data Is Not In The Expected Format (Doc ID 1970157.1)

Symptoms

DBCA fails with "The template data is not in the expected format" (when choosing "Manage templates").

Changes

There are several bugs reported and the following workarounds mentioned in them were tried, however, the problem was not solved Example:

1-Remove <Variables> section manually from template

Referece Bug 19561020: BUG REPORT: VARIABLE SECTION IN TEMPLATE BUG IN DBCA SHIPPED WITH 12.1.0.2

which has been closed as duplicate of Bug 19406694 : DBCA FAILS TO VALIDATE THE CREATED TEMPLATE IF VARIABLES SECTION SPECIFIED fixed in 12.2 Future release

2-Remove this reuse tag from the template:

<ControlfileAttributes id="Controlfile">
   <reuse>true</reuse>                 <<<<<<<<<<<<<<<Remove this one
   <maxDatafiles>100</maxDatafiles>
   <maxLogfiles>127</maxLogfiles>
   <maxLogMembers>2</maxLogMembers>
   <maxLogHistory>100</maxLogHistory>
   <maxInstances>63</maxInstances>
   <image filepath="/oradata" name="control0.ctl"/>
 </ControlfileAttributes

Reference Bug 19596596: INVALID TEMPLATE FILE IN CREATING 12.1.0.2 DATABASE SILENTLY

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.