on 09-11-2014 5:40 PM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!!
User | Count |
---|---|
15 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.