Difficulties when creating a slave repository on MDM 7.1

[Former Member]

Hi Experts,

We're trying to create a Slave repository on MDM 7.1, but when trying to connect to the other DBMS a message shows up saying that it's unable to connect with Database Server.

I went to the MDM log and found the following message:

Service 'MQ0', Schema 'system', ERROR CODE=12154 ||| ORA-12154: TNS:could not resolve the connect identifier specified Last CMD:

Important information:

The servers are different, one for the master and the other for slave. (the DB is also in each correspondent server).

Both servers are on the same network.

The Oracle Listener is up and working, we could telnet it.

Does anybody faced with something similar?

Thanks for the help

Armando Martines Neto

[Former Member]

Hi Experts, we solved the problem...

We just added the slave hostname on the file tsnames.ora of the master server. with this little configuration, both servers start communicating.

cheers

Armando Martines Neto

[Former Member]

Adding the full log message from MDM:

OCI Attach, try again ...

Last CMD:

",MDSAdminServer@GetDbmsSettings,Oracle_DBConnection.cpp,201,,,,server_user,server_global,,,

2009-07-20T19:20:57.918,11 ,24,"OCI Attach returned: -1",MDSAdminServer@GetDbmsSettings,Oracle_DBConnection.cpp,543,,,,server_user,server_global,,,

2009-07-20T19:20:57.918,11 ,24,"Service '15.179.91.77', Schema 'mpmuser', ERROR CODE=12154 ||| ORA-12154: TNS:could not resolve the connect

cheers,

Armando Martines Neto