MDM 321 – SAP Netweaver Master Data Management

Symptom

Cannot connect to Oracle from the MDM server or another MDM program/utility

Reason and Prerequisites

How to verify a connection to Oracle from the MDS server machine/client machine

Solution

The easiest and safest way to check a connection to Oracle is by using an Oracle sqlplus command line utility.
Run the sqlplus command from the MDM server machine if you have trouble connecting from mds or from the client machine (if the other MDM program/utility does not connect to Oracle).
Windows: open window command (Start->Run type cmd).
Unix: use the same user that executes mds or the other MDM program/utility.
Execute the following command :
sqlplus user/password@SID

1. User – Oracle user used by mds or the other MDM program/utility2. Password – Oracle password used by mds or the other MDM program/utility3. SID – Oracle database (instance) name

Example:
sqlplus system/systempwd@MDMORA
If the connection was succesful, you will receive aSQL>prompt.
Type Exit to disconnect from Oracle. The basic Oracle connection is working properly.
In case of a connection problem, you will get an error message specifing the exact problem.
Error examples:
ORA-12154: TNS:could not resolve the connect identifier specifiedORA-01017: invalid username/password; logon denied

Consult your Oracle DBA for solving these problems.