Skip to Content
avatar image
Former Member

MDM Console could not connect to Oracle

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Aug 28, 2009 at 08:05 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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

  • avatar image
    Former Member
    Oct 08, 2009 at 08:38 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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