ORA-12545: Connect failed because target host or object does not exist
Hi,
I've got this problem for the linked server (to Oracle DB)
Msg 3701, Level 11, State 5, Line 2
Cannot drop the procedure 'my_proc', because it does not exist or you do not have permission.
OLE DB provider "OraOLEDB.Oracle" for linked server "ORA_link" returned message "ORA-12545: Connect failed because target host or object does not exist".
Msg 7303, Level 16, State 1, Procedure my_proc, Line 215
Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server "ORA_link".
But I can successfully tnsping that (where link_ora is the source name I've used for the linked server)
C:\Documents and Settings\my.login>tnsping link_ora
TNS Ping Utility for 64-bit Windows: Version 10.2.0.1.0 - Production on 03-DEC-2
009 15:52:58
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
\\temdbs\tns_admin$\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (description = (ENABLE=BROKEN) (ADDRESS_LIST= (ADDRESS= (P
ROTOCOL=TCP) (Host=vsprod-tem.fe.corp.abc.com) (Port=1526))) (CONNECT_DATA= (SID
=link_ora)))
OK (20 msec)