Link Id ssm_cb_ea error
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
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.11.29.73)(PORT = 1521))
(PROTOCOL = TCP)
(HOST = 10.11.29.73)
(PORT = 1521))
(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.
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.