Link Id ssm_cb_ea error

[Former Member]

Hi experts!!

I need help on this error I've tried to solve this days.

Im creating the ssm_cb_ea linkId and Im getting this error: ora 12504 el listener no ha recibido el service_name en connect_data

Ive checked the tnsnames.ora file

LISTENER_MD7 =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.29.73)(PORT = 1521))

)

)

MD7 =

  (DESCRIPTION =

    (ADDRESS =

  (PROTOCOL = TCP)

  (HOST = 10.11.29.73)

  (PORT = 1521))

    (CONNECT_DATA =

  (SID = MD7)

      (SERVER = DEDICATED)

      (SERVICE_NAME = MD7)

    )

  )

I can execute the tnsping md7 successfully.

I can also execute the sqlplus SAPSMDDB/ecpSSM__2014/@MD7 and I get this error: Ora 12545 Connect failed because target host or object does not exist

I have checked the environment variable Path, ORACLE_HOME and ORACLE_SID

Is there anything I am missing? I thank any help.

Ingrid.

[Former Member · Accepted solution]

Hi Ingrid,

Make sure the library path is pointing to the 32-bit oracle client then try changing the oracle user to sapsr3db and the Server to MD7 which is your service_name.
This wiki contains a summary of what you need to check: http://wiki.scn.sap.com/wiki/x/ooKYF.
I hope this helps.
Isabel

[Former Member · Accepted solution]

Hi, this link that you gave me was very helpful to check the different configurations needed to make the linkId work. Finally my error was on my tnsnames, because I had in two points of the document the name of the server (instead of the ip) and that name was calling a wrong ip, so I changed the server's name for the ip number, and it worked fine.

Thanks a lot!!