The only other person I know who actively connects to the database using a Oracle client uses the Squirrel client to connect & having not ever used that client before didn't want to 'try something new'. I did take the connection string they use there and translated it to the format that SQL*Plus requires so I'm pretty sure there should not be any problem with that.
Thanks for your response. Joe _____ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Andrew Hicox Sent: Wednesday, July 09, 2014 12:20 PM To: arslist@ARSLIST.ORG Subject: Re: Slightly OT: Connecting SQL*Plus client to an Oracle Database.. ** Can anyone else connect to the DB without being on localhost with it? If no other remote client can connect, maybe the listener isn't running? Also if others can connect, try copying their tnsnames.ora file Andy On Wednesday, July 9, 2014, 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_ _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"
