Oracle connection problem
[access connection] [connection] [connection problem] [french connection]
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) [...]