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

Last updated on JULY 17, 2016

Applies to:

Oracle Database Configuration Assistant - Version 12.1.0.2 and later
Information in this document applies to any platform.
***Checked for relevance on 17-Jul-2016***

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms