Hi Joe, Kindly do a tnsping of your service_name. Possible cause is that you cant reach your destination host. Please also try to do a telnet test to the host ip with the port 1521 to make sure that the port is open on the fw.
Regards, Wesley > On 9 Jul, 2014, at 11:43 pm, Joe D'Souza <jdso...@shyle.net> wrote: > > ** > We have our Remedy database on Oracle 11.2.0.3.0 - 64bit Production server. > > I am using SQL*Plus Release 10.2.0.1.0 client to connect to it but am unable > to connect with a connection error that reads as: > > ORA-12154: TNS:could not resolve the connect identifier specified > > I have checked my tnsnames.ora file for any possible errors in the connection > string and can’t seem to find one. This is the contents of the entry (I have > replaced the actual IP and the service name and what not with fictitious > names for security reasons – the port is 1521 which is the default port.) > > ## Remedy ITSM db - Devl - Used IP instead of hostname > CONNENTRY = > (DESCRIPTION = > (ADDRESS = (PROTOCOL = TCP)(HOST = 111.111.11.111)(PORT = 1521)) > (CONNECT_DATA = > (SERVER = DEDICATED) > (SERVICE_NAME = connentry) > ) > ) > > While connecting I use the username & password as given to me and connentry > as the host string. > > What could possibly be the causes of ORA-12154 that I ought to check for? I > suspect something wrong with my connection string in my tnsnames.ora file but > can’t figure what it is. I checked with the DBA’s for the exact IP, port, > service name and they say it all checks out. > > I was also suspecting that perhaps Oracle client 10.2.0.1.0 may not be > compatible with Oracle Database version 11.2.0.3.0, but I do not think that > could be the problem as Oracle clients are usually compatible with at least 1 > version forward or backward. > > > Any insights as to what I and my DBA’s may be missing may help.. > > Thanks.. > > Joe > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
