DBCA Deletes All Files Specified In Template If the Database Creation Has Failed (Doc ID 1506166.1)

Last updated on DECEMBER 28, 2016

Applies to:

Oracle Database Configuration Assistant - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 29-DEC-2016***

Symptoms

When creating the database creation scripts using the DBCA in silent mode from a template, if the path for a single datafile does not physically exist, the following error will be logged :

 

Changes

If the DBCA template is referencing a certain datafile and this datafile does not currently exist in the ORACLE_HOME where DBCA is running from, then the following actions will occur:

  1. the error message : Incorrect variables format. Use <variable_name> format to define variables

  2. DBCA will delete all datafiles specified in the template


This can occur if you first create a template from an existing database, then the physical structure of the database is changed by dropping a datafile or tablespace, and then you try to create the database creation scripts from this template.

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