MDM Console could not connect to Oracle

[Former Member]

Hi all,

I have installed MDM 7.1 on an AIX5.3 Unix-Server including Oracle 10.2.0.2.

The MDM Console is installed on a Windows 2003 Server.

In the MDM Console I can mount the MDM Server sucessfully.But when I enter dbsettings (same information as for sqlplus) I get an ORA-12154:

Service 'GN2.WORLD', Schema 'system', ERROR CODE=12154 ||| ORA-12154: TNS:could not resolve the connect identifier specified

In the server log I found this messages:

 
A-12154: TNS:could not resolve the connect identifier specified
OCI Attach, try again ...
Last CMD:
",MDSAdminServer @ GetDbmsSettings,Oracle_DBConnection.cpp,201,,,,server_user,server_global,,,
2009-08-27T20:12:59.105,1029    ,24,"OCI Attach returned: -1",MDSAdminServer @ GetDbmsSettings,Oracl
e_DBConnection.cpp,543,,,,server_user,server_global,,,
2009-08-27T20:12:59.106,1029    ,24,"Service 'GN2.WORLD', Schema 'system', ERROR CODE=12154 ||| OR
A-12154: TNS:could not resolve the connect identifier specified

Many, many thanks for all replys!

Matthias

[Former Member]

Thank You All, It is working now. Issue was with TNSNAMES.ORA.

Also Oracle Character should be the same as the one mentioned in Install Doc.

Thank You,

Sharan Alemane

[brian_bogart]

Hello ,

We ran into the same issue. The solution for us involved the connection string used in the MDM console when providing the DBMS settings.

For the DBMS server, we needed to use: <DB Host>:<Listener Port>/<DBSID>

Ex: myhost:1527/ABC

Hope this helps anyone else with the same issue.

-Brian

[Former Member]

Problem is solved. I have adjusted the settings in the .mdmdbenv... files on the unix-server and restarted the Instance:

sapcontrol -nr 03 -function RestartInstance.

[Former Member]

Matthias,

I am running into the same issue on MDM 7.1 for windows. Please can you provide me the exact parameter or the file in which this parameter exists.

Thank You,

Sharan Alemane

[Former Member]

Hi Sharan,

I have adjusted the following settings in the .mdmdbenv.sh file:

ORACLE_HOME=/oracle/GN0/102_64

ORACLE_SID=GN2

ORACLE_SQL_PLUS_HOME=/oracle/GN0/102_64/bin

But we are using MDM on a unix-server (AIX) not Windows.

I hope these parameters helps...

Best Regards

Matthias