On 10/17/06, Chris Hidden <[EMAIL PROTECTED]
> wrote:
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:arslist@ARSLIST.ORG] On Behalf Of Chris Hidden
>Sent: Tuesday, October 17, 2006 11:47 AM
>To: arslist@ARSLIST.ORG
>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
--
Frank Caruso
Specific Integration, Inc.
Senior Remedy Engineer
www.specificintegration.com
703-376-1249 __20060125_______________________This posting was submitted with HTML in it___
