SAP Knowledge Base Article - Preview

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

Symptom

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


Read more...

Environment

  • MDM Release Independent
  • SAP NetWeaver Master Data Management

Product

SAP NetWeaver Master Data Management 2.0 ; SAP NetWeaver Master Data Management 3.0 ; SAP NetWeaver Master Data Management 5.5 ; SAP NetWeaver Master Data Management 7.1

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.