you need to set your ORACLE_HOME variable / your ORACLE_SID and your ORACLE_UNIQUE variable. then the application should work.
On Wed, Jul 9, 2014 at 4:25 PM, Joe D'Souza <jdso...@shyle.net> wrote: > ** > > I can connect to other databases whose connection strings are defined in > that tnsnames.ora file. So that rules out the client not being able to find > the tnsnames.ora file or any permission related issue to that file. > > > > I haven’t made any changes to the sqlnet.ora file. The only two non > commented lines in it are: > > > > SQLNET.AUTHENTICATION_SERVICES= (NTS) > > > > NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) > > > > Cheers > > > > > > > ------------------------------ > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Grooms, Frederick W > > *Sent:* Wednesday, July 09, 2014 12:20 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Slightly OT: Connecting SQL*Plus client to an Oracle > Database.. > > > > I can think of 2 possible reasons off the top of my head. > > > > One reason is that SQLPLUS could not find the TNSNAMES.ORA file. Do you > have an environment variable of TNS_ADMIN? > > In my systems I have that environment variable pointing to the folder > where the tnsnames.ora file is located. SQLPLUS (and the Oracle client in > general) use this environment variable to find the tnsnames.ora > configuration file. > > > > Another possible reason could be a default domain setting. > > In your Oracle Client configuration do you have an SQLNET.ORA > configuration file that defines? > > names.default_domain = world > > > > In those cases the TNSNAMES entry wanted to be: > > CONNENTRY.WORLD = > > (DESCRIPTION = > > (ADDRESS = (PROTOCOL = TCP)(HOST = 111.111.11.111)(PORT = 1521)) > > (CONNECT_DATA = > > (SERVER = DEDICATED) > > (SERVICE_NAME = connentry) > > ) > > ) > > > > And then my login using SQLPLUS would be > > sqlplus user@CONNENTRY.WORLD > > > > Fred > > > > > > *From:* Action Request System discussion list(ARSList) [mailto: > arslist@ARSLIST.ORG] *On Behalf Of *Joe D'Souza > *Sent:* Wednesday, July 09, 2014 10:44 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Slightly OT: Connecting SQL*Plus client to an Oracle Database.. > > > > ** > > 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_ -- Patrick Zandi _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
