See, this is where I get a bit confused. Unfortunately, I do not have access to where the server is actually running, so I can't get the TNSNAMES.ora file from there. Also, the TNSNAMES.ora file that I have been provided with gives me an IP for the HOST for the REMEDY entry. When I connect to the server via the ARS program, I connect to a domain name which resolves to a differnet IP, and it also specifies port 2020.
If I then change the TNSNAMES.ora file to reflect the new IP and port, I still time out when I run tnsping REMEDY. I guess that I should mention that I'm not 100% sure what back end database our Remedy application uses, however I also connect to the remedy back end using Crystal Reports 8.5, where the HPD:HelpDesk shows up under ODBC -> Remedy ODBC Data Source. From that I gather that it's using ODBC, which means TOAD should be able to connect to it (assuming I have the correct TNS entry) no problem. On Tue, 17 Oct 2006 12:31:44 -0700, McKenzie, James J C-E LCMC HQISEC/L3 <[EMAIL PROTECTED]> wrote: >Chris: > >Do you have a DNS entry for the server name anywhere? Tnsping will read the >tnsnames.ora file and then use the IP address in the entry to attempt to >contact the server on the port mentioned. This should be 1521 unless you >set up the server with a different port. Also the Listener process has to >be running on the Oracle server or you will not connect. > >James McKenzie >L-3 GSI > > >-----Original Message----- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Chris Hidden >Sent: Tuesday, October 17, 2006 11:47 AM >To: [email protected] >Subject: Re: Remedy and TNSNAMES.ora > >It shows me the entry out of the TNSNAMES.ora file, and then hangs. > >___________________________________________________________________________ _ >___ >UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
