IF you are using the ORACE_RAC we have found some additional settings in the TNSNAMES.ora need to be applied AND you have some additional settings you have to modify in the SLM module, due to the fact that remedy wrote the code to do it static like name:sid:table or something like that...
hope that helps some. On Wed, Jul 9, 2014 at 4:42 PM, patrick zandi <remedy...@gmail.com> wrote: > 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 > -- Patrick Zandi _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
