Chris:
If you are running Remedy against a REMOTE Oracle server, you have to have a proper TNSNAMES.ORA file on the Remedy server. If not, Remedy cannot and will not connect to the Oracle Database. GET THAT FILE from the system admin or if you are it, look on the server for it.
Use the parameters in the TNSNAMES.ORA file to connect with TOAD to the database. This should work. If you cannot use TOAD, then attempt to use tnsping with the same file. If tnsping will not work, something is very, very wrong. Since the IP address you posted is in private name space (10.x.x.x) you can ONLY connect from a like area. You cannot connect from a system having a public IP space address. It is possible that your network is split into to parts where it is not possible (for various reasons) to connect across them.
Can you access the Remedy server?
Can you get the TNSNAMES.ORA file from this system?
It appears that you are attempting to access your Oracle server from a system other than your Remedy server. Can you run either ipconfig /all (for Windows) or ifconfig (for UNIX) and look at the IP address. Is the IP address the same for the first three digits?
James McKenzie
L-3 GSI
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Chris
Sent: Tuesday, October 17, 2006 1:04 PM
To: [email protected]
Subject: Re: Remedy and TNSNAMES.ora
I think maybe I should have been a bit more clear. I'm not administering anything, simply trying to connect to the oracle database that is feeding Remedy (TOAD, SQLPlus, any tool realy, I just would like to connect to it though a program other than ARS or Crystal Reports).
My real question was, can I figure this out by looking at settings I have, or do I need to go to the DBA, since my boss doens't even know who the DBA is (ownership of our Remedy system was recently transfered), I was hoping that I could get this information without having to go that route. It looks like I do.
Thanks for the information.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
