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):
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
About this pageThis 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.