My Oracle Support Banner

13.4: OMS Upgrade Fails During MDS Schema Configuration with Error: Failed to create OPSS schema (Doc ID 2658454.1)

Last updated on APRIL 13, 2020

Applies to:

Enterprise Manager Base Platform - Version 13.4.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Upgrading to OMS 13.4 fails during the MDS schema configuration, with the error:

OMS_HOME/cfgtoollogs/cfgfw/CfmLogger_<timestamp>.log

INFO: oracle.sysman.top.oms:The plug-in MDS Schema Configuration is running
INFO: oracle.sysman.top.oms:Internal PlugIn Class: oracle.sysman.oms.MDSSchemaConfiguration
INFO: oracle.sysman.top.oms:BaseConfiguration:invoke:Starting BaseConfiguration invoke method on an aggregate=oracle.sysman.top.oms for Action=configuration in step=8:microstep=0
INFO: oracle.sysman.top.oms:JUSTCHECK: b_stackUpgrade has got a default value
INFO: oracle.sysman.top.oms:enableBIP true
INFO: oracle.sysman.top.oms:shareLocationForBIP false
INFO: oracle.sysman.top.oms:__________________________DUMPING PARAMETERS______________________________________________
INFO: oracle.sysman.top.oms:OracleHome: <OMS_HOME>
INFO: oracle.sysman.top.oms:Connect String: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname>)(PORT=<port>)))(CONNECT_DATA=(SERVICE_NAME=<service_name>)))
INFO: oracle.sysman.top.oms:SYS User: SYS
INFO: oracle.sysman.top.oms:Debug: SCRIPT_HOME: null
INFO: oracle.sysman.top.oms:________________________________________________________________________
INFO: oracle.sysman.top.oms:Renaming the file usermessaging.xml to usermessaging.xml
INFO: oracle.sysman.top.oms:File is moved successful!
INFO: oracle.sysman.top.oms:mgmtTabLoc for upgrade null
INFO: oracle.sysman.top.oms:MDS Schema Creation status: COMPLETED
INFO: oracle.sysman.top.oms:MDS Schema Creation is successful
INFO: oracle.sysman.top.oms:_______________________________________________________________________
INFO: oracle.sysman.top.oms:Starting opss Schema Creation.
INFO: oracle.sysman.top.oms:Debug: SCRIPT_HOME: null
INFO: oracle.sysman.top.oms:oldDomainHome=<OMS_INSTANCE_HOME>/user_projects/domains/GCDomain
INFO: oracle.sysman.top.oms:Failed to create OPSS schema
INFO: oracle.sysman.top.oms:_______________________________________________________________________
INFO: oracle.sysman.top.oms:Starting ServiceTable Schema Creation
INFO: oracle.sysman.top.oms:Debug: SCRIPT_HOME: <OMS_HOME>/oracle_common/common/sql
INFO: oracle.sysman.top.oms:Failed to create ServiceTable schema
INFO: oracle.sysman.top.oms:ServiceTable Schema Creation completed with status=false
INFO: oracle.sysman.top.oms:Renaming the file usermessaging.xml.bk to usermessaging.xml
INFO: oracle.sysman.top.oms:File is moved successful!
INFO: oracle.sysman.top.oms:The plug-in MDS Schema Configuration has failed its perform method

 

 

OMS_HOME/cfgtoollogs/cfgfw/emsecrepmgr.log

2020-04-02 10:26:39,050 [Thread-127] WARN opss.EMSecuritySchemaManager gotError.1391 - Ignorable error when running RCU
2020-04-02 10:26:39,051 [Thread-127] ERROR opss.EMSecuritySchemaManager handleFatalError.1398 - Number of errors = 1
2020-04-02 10:26:39,051 [Thread-127] ERROR opss.EMSecuritySchemaManager handleFatalError.1401 - ERROR:EMSecuritySchemaManager: ORA-28003: password verification for the specified password failed
ORA-20003: Password should contain at least one digit, one character and one punctuation
File:<OMS_HOME>/oracle_common/../oracle_common/common/sql/svctbl/sql/create_user.sql
Statement:CREATE USER SYSMAN_STB IDENTIFIED BY ****** DEFAULT TABLESPACE MGMT_TABLESPACE TEMPORARY TABLESPACE TEMP

2020-04-02 10:26:39,454 [Thread-128] WARN opss.EMSecuritySchemaManager gotError.1391 - Ignorable error when running RCU
2020-04-02 10:26:39,454 [Thread-128] ERROR opss.EMSecuritySchemaManager handleFatalError.1398 - Number of errors = 1
2020-04-02 10:26:39,454 [Thread-128] ERROR opss.EMSecuritySchemaManager handleFatalError.1401 - ERROR:EMSecuritySchemaManager: ORA-01918: user 'SYSMAN_STB' does not exist

2020-04-02 10:26:39,456 [Thread-114] ERROR opss.EMSecuritySchemaManager createOrDropSchema.663 - Error in creation of stb schema

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


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