LCM Deployment Tool Failing On "Preconfigure" Phase - Unable To Create Schema Using RCU (Doc ID 2221176.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle IDM Tools - Version 11.1.2.3.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.2.3.0 version, Compact Installer for IDM

LCM deployment tool failing on "Preconfigure" phase - Unable to create schema using RCU

ERROR
-----------------------
[2016/11/04 15:43:32.036, PDT] Repository Creation Utility - Creating Tablespaces
[2016/11/04 15:43:32.036, PDT] Validating and Creating Tablespaces
[2016/11/04 15:43:32.921, PDT] ORA-01119: error in creating database file '/uxyz/oradata/pxyz/EDGIGD_iastemp.dbf'
[2016/11/04 15:43:32.921, PDT] ORA-27038: created file already exists
[2016/11/04 15:43:32.921, PDT] Additional information: 1
[2016/11/04 15:43:32.962, PDT] RCU-6093:Skipping Main operation: Failed in SchemaTablespace step validation


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the LCM or RCU previously
2. Leave some of the DB files for the schema alone and do not delete them
3. Run LCM again and select the checkbox to make LCM run the RCU utility to create the schemas
4. When LCM runs, it detects that one or more of the DB files for the specified schema already exist and reports a failure

Changes

When dropping the Schemas from previous LCM or RCU runs, if the RCU tool itself is not used to perform the schema drops, then it's easy to forget and leave some of the existing files in tact, rather than cascading the drop and removing all of the DB files.

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