Sorry got interupted, then ensure your /etc/hosts file has the ip address do a tnsping first using the oracle tnsnames.ora
On Wed, Jul 9, 2014 at 4:41 PM, patrick zandi <remedy...@gmail.com> wrote: > 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 > -- Patrick Zandi _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
