EM Upgrade From 12.1.0.3 to 12.1.0.5 Failed at The plug-in MDS Schema Configuration has failed its perform method (Doc ID 2067475.1)

Last updated on OCTOBER 18, 2015

Applies to:

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

Symptoms

OEM upgrade from 12.1.0.3 to 12.1.0.5 Failed at 'Repository Upgrade' Step with Error:

The plug-in MDS Schema Configuration has failed its perform method.

$OMS_HOME/cfgtoollogs/cfgfw/oracle.sysman.top.oms_<timestamp>.log

INFO: oracle.sysman.top.oms:__________________________DUMPING PARAMETERS______________________________________________
INFO: oracle.sysman.top.oms:OracleHome: /u01/app/oracle/product/em12c/fmw/oms
INFO: oracle.sysman.top.oms:Connect String: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=igrodandc001-scan.corp.irco.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=oemp)))
INFO: oracle.sysman.top.oms:SYS User: SYS
INFO: oracle.sysman.top.oms:________________________________________________________________________
INFO: oracle.sysman.top.oms:MDS Schema Creation status: FAILURE
SEVERE: oracle.sysman.top.oms:MDS Schema Creation is failed
INFO: oracle.sysman.top.oms:_______________________________________________________________________
INFO: oracle.sysman.top.oms:Starting opss Schema Creation.
INFO: oracle.sysman.top.oms:Failed to create OPSS schema
INFO: oracle.sysman.top.oms:_______________________________________________________________________
INFO: oracle.sysman.top.oms:Starting APM Schema Creation.
INFO: oracle.sysman.top.oms:APM Component is already created
INFO: oracle.sysman.top.oms:The plug-in MDS Schema Configuration has failed its perform method

$OMS_HOME/cfgtoollogs/cfgfw/emmdscreate.err file has the following errors:

Cannot change password for sysman_mds java.sql.SQLSyntaxErrorException: ORA-00922: missing or invalid option

ERROR:MDS java.sql.SQLSyntaxErrorException: ORA-00922: missing or invalid option

java.sql.SQLSyntaxErrorException: ORA-00922: missing or invalid option

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