Chris:
Oracle NEVER runs at 2020 unless it is configured to do so. The standard port for Oracle is 1521. Try that one or 1571 and see if you can ping the server. Also, beat on your DBA and let them know that you need a VALID tnsnames.ora file. If you need, get C level staff involved at this point. You are wasting your time and their money.
James Mckenzie
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Chris Hidden
Sent: Tuesday, October 17, 2006 12:50 PM
To: [email protected]
Subject: Re: Remedy and TNSNAMES.ora
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.
__20060125_______________________This posting was submitted with HTML in it___
