Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Link Id ssm_cb_ea error

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.

Tags:
Former Member
Former Member replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question