1670714 - MDM Repository stopped connecting to Oracle/More Oracle users exist for MDM

While creating a new MDM repository on Oracle there are the following extra DBMS users created (besides the DBMS user with you connect to DBMS from MDM - by default it is "system" user):

A2I_XCAT_DBS    
<rep_name>_M000
<rep_name>_Z000

If you change the password one of the mentioned users (including the DBMS user with you connect to DBMS from MDM!) and do not change the rest of them accordingly, MDM Repository will not be accessible by MDS.

You might get similar messages in the MDS_Log:

Service 'MXD', ERROR CODE=1017     ORA-01017: invalid username/password; logon denied MDMCATALOG_m001 does not exist or bad password provided, Last CMD:

Load error(0x84020005: Unable to set current database with Database Server) for MDM_CATALOG

Service 'MXD', ERROR CODE=1012     ORA-01012: not logged onA2i_xCat_DBs does not exist or bad password provided, Last CMD: ALTER SESSION SET CURRENT_SCHEMA = A2i_xCat_DBs

• MDM Release Independent
• SAP NetWeaver Master Data Management

A2I_XCAT_DBS , <rep_name>_M000, <rep_name>_Z000, MDM_CATALOG, ORA-01012, bad password provided.   , KBA , MDM-FN , Master Data Management Foundation , MDM-FN-MDS , Master Data Server , MDM-FN-MDS-DB , DB Layer , MDM-FN-CON , Admin Console , How To