Schema Creator failed with This PACK cannot be installed on the SCHEMA (Doc ID 2807588.1)

Last updated on NOVEMBER 28, 2022

Applies to:

Symptoms

On : 8.1.1 version, Installers

ACTUAL BEHAVIOR
---------------
Schema creator failing during install

Schema Creator message says cannot install BD on the atomic schema.

OFS_BD_OSC_*.log

Log [2021-09-01 16:43:24.851] [SCHEMAUTILITY] [INFO ] - Table space creation file ofs_bd_createtbsp.sql doesn't exist

.............

Log [2021-09-01 16:43:25.581] [SCHEMAUTILITY] [INFO ] - Parsing DIRECTORY tags...
Log [2021-09-01 16:43:25.582] [SCHEMAUTILITY] [DEBUG] - objectMap - {##OFS_BD_PACK_EXTERNAL_DIRECTORY_1-NAME##=Directory@7b993c65}
Log [2021-09-01 16:43:25.582] [SCHEMAUTILITY] [DEBUG] - Executing ...select DISTINCT * from AAI_APP_PACK_AUDIT_TRAIL where UPPER(V_APP_PACK_ID) in ('OFS_AAAI_PACK','OFS_CRM_PACK','OFS_EST_CP_PACK','OFS_CAP_ADQ_PACK','OFS_RRRS_PACK','OFS_TR_PACK','OFS_ALM_PACK','OFS_PM_PACK','OFS_CA_PACK','OFS_PFT_PACK','OFS_BFND_PACK','OFS_DM_PACK','OFS_DI_PACK','OFS_BGRC_PACK','OFS_IFRS_PACK')
Log [2021-09-01 16:43:25.598] [SCHEMAUTILITY] [DEBUG] - Executing ...select DISTINCT db.DBUSERID from db_master db,dsnmaster ds where UPPER(ds.DSNID) in('FCCMINFO') and db.DBNAME=ds.DBNAME and db.DBUSERID='TEST'
Log [2021-09-01 16:43:25.605] [SCHEMAUTILITY] [ERROR] - This PACK cannot be installed on the SCHEMA atomic
Log [2021-09-01 16:43:25.606] [SCHEMAUTILITY] [INFO ] - ===================================================================================
Log [2021-09-01 16:43:25.606] [SCHEMAUTILITY] [INFO ] - Schemas Creation Failed.
Log [2021-09-01 16:43:25.606] [SCHEMAUTILITY] [INFO ] - ===================================================================================

Cause

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