Re: Remedy and TNSNAMES.ora
Title: RE: Remedy and TNSNAMES.ora ** Do not edit this file! It is used by the arserverd process (or arserver.exe program) to connect to your Oracle database. The arserverd process's port is NOT relevant to the port needed/desired to connect to your Oracle database. If there is a problem connecting to the Oracle database, you need to talk to your Oracle DBA. James McKenzie Somewhat Remedy Guru and Oracle Expert. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, October 17, 2006 10:58 AM To: arslist@ARSLIST.ORG Subject: Remedy and TNSNAMES.ora Please excuse my newbie-ness as I have only worked with remedy for a very short amount of time, and all of my expose to remedy has been without any direction or documentation (only the web). So here's the question/problem: I'd like to connect to the database using TOAD, but there appears to be something wrong with the entry in the TNSNAMES file. Here is what it looks like (that's not the real host IP, just so you know): REMEDY = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.10)(PORT = 1521)) ) (CONNECT_DATA = (SID = orcl) ) ) __20060125___This posting was submitted with HTML in it___
Remedy and TNSNAMES.ora
Sorry if this is a double post, I was having some posting issues. Please excuse my newbie-ness as I have only worked with remedy for a very short amount of time, and all of my expose to remedy has been without any direction or documentation (only the web). So here's the question/problem: I'd like to connect to the database using TOAD, but there appears to be something wrong with the entry in the TNSNAMES file. Here is what it looks like (that's not the real host IP, just so you know): REMEDY = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.10)(PORT = 1521)) ) (CONNECT_DATA = (SID = orcl) ) ) Now, this is the file that I was given when I started, however when I connect to the remedy database using the Action Request System program (version 5.01.01 Patch 1228), and resolve the host name, I get a different IP than the one listed in my TNSNAMES file, as well as a different port. Also, if I put the server name and port from the AR System program into my TNSNAMES file, I am still unable to connect. Now, this brings me to my questions. First, can I determine the correct TNSNAMES entry by using the information that I have? Or is that something that I can't determine, and need to be told (I'd rather not deal with the group thats administrating our Remedy system). Next, is there a way that my account may be limited to only allow me to log on through the front end application, and not through a TOAD connection (which would require me to request access, and I could request the TNS entry too)? I appologize if I didn't give enough information, or if this is blindingly easy and I just missed it, but greatly appreciate any help that can be given. Thanks in advance! ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Remedy and TNSNAMES.ora
** If you do a tnsping REMEDY what do you get?On 10/17/06, Chris Hidden [EMAIL PROTECTED] wrote: Sorry if this is a double post, I was having some posting issues.Please excuse my newbie-ness as I have only worked with remedy for a very short amount of time, and all of my expose to remedy has beenwithout any direction or documentation (only the web).So here's the question/problem:I'd like to connect to the databaseusing TOAD, but there appears to be something wrong with the entry in the TNSNAMES file.Here is what it looks like (that's not the realhost IP, just so you know):REMEDY = (DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.10)(PORT = 1521)))(CONNECT_DATA =(SID = orcl)) )Now, this is the file that I was given when I started, however when Iconnect to the remedy database using the Action Request System program (version 5.01.01 Patch 1228), and resolve the host name, I get adifferent IP than the one listed in my TNSNAMES file, as well as adifferent port.Also, if I put the server name and port from the ARSystem program into my TNSNAMES file, I am still unable to connect. Now, this brings me to my questions.First, can I determine thecorrect TNSNAMES entry by using the information that I have? Or is thatsomething that I can't determine, and need to be told (I'd rather not deal with the group thats administrating our Remedy system).Next, isthere a way that my account may be limited to only allow me to log onthrough the front end application, and not through a TOAD connection(which would require me to request access, and I could request the TNS entry too)?I appologize if I didn't give enough information, or if this isblindingly easy and I just missed it, but greatly appreciate any helpthat can be given.Thanks in advance!___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org-- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineer www.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___
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
Re: Remedy and TNSNAMES.ora
** OK ... well it sounds like the HOST value maybe incorrect.If you have a Remedy server on Oracle then there must be a tnsnames.ora file on the Remedy server which correctly points to the Oracle. Take the entry out of that file and place it in the file on your machine. On 10/17/06, Chris Hidden [EMAIL PROTECTED] wrote: It shows me the entry out of the TNSNAMES.ora file, and then hangs.___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org-- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineerwww.specificintegration.com 703-376-1249 __20060125___This posting was submitted with HTML in it___
Re: Remedy and TNSNAMES.ora
Title: RE: Remedy and TNSNAMES.ora ** 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 __20060125___This posting was submitted with HTML in it___
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. 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: 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
Re: Remedy and TNSNAMES.ora
** At this point I will re-iterate what James said originally ... talk to your DBA.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 theTNSNAMES.ora file from there.Also, the TNSNAMES.ora file that I have beenprovided 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 whichresolves 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 databaseour Remedy application uses, however I also connect to the remedy back endusing 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, whichmeans TOAD should be able to connect to it (assuming I have the correct TNSentry) 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 thetnsnames.ora file and then use the IP address in the entry to attempt tocontact the server on the port mentioned.This should be 1521 unless youset 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 McKenzieL-3 GSI-Original Message-From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Chris HiddenSent: Tuesday, October 17, 2006 11:47 AMTo: arslist@ARSLIST.ORG Subject: Re: Remedy and TNSNAMES.oraIt 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 CarusoSpecific Integration, Inc.Senior Remedy Engineer www.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___
Re: Remedy and TNSNAMES.ora
Title: RE: Remedy and TNSNAMES.ora ** 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:arslist@ARSLIST.ORG] On Behalf Of Chris Hidden Sent: Tuesday, October 17, 2006 12:50 PM To: arslist@ARSLIST.ORG 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___
Re: Remedy and TNSNAMES.ora
Title: RE: Remedy and TNSNAMES.ora ** TOAD is a GUI SQL editor/browser application. It stands for Tool for Oracle Application Development From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Tuesday, October 17, 2006 2:58 PMTo: arslist@ARSLIST.ORGSubject: Re: Remedy and TNSNAMES.ora ** Chris: What is TOAD? James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Chris Hidden Sent: Tuesday, October 17, 2006 12:50 PM To: arslist@ARSLIST.ORG 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. 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 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Remedy and TNSNAMES.ora
Title: RE: Remedy and TNSNAMES.ora ** Fred: Thanks. I hate ambiguous acronyms Chris is correct. He should be able to log into the Oracle server with the appropriate credentials and settings. James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Tuesday, October 17, 2006 1:00 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy and TNSNAMES.ora ** TOAD is a GUI SQL editor/browser application. It stands for Tool for Oracle Application Development __20060125___This posting was submitted with HTML in it___
Re: Remedy and TNSNAMES.ora
Title: RE: Remedy and TNSNAMES.ora ** It is a DB independent client connect toolwhat it appears is Chris is an end user trying to connect to the Remedy back end. Chris, You will only be able to do this with either your Remedy Admin or the DBA's assistance. The reason that the ODBC works is that it is using the Remedy level API to connect to the Remedy application server...not the DB itself. If I remember correctly TOAD can also use the Remedy ODBCso you could try that if you would like...but one thing to know about the Remedy ODBC is that it doesn't like joins very much L. J. HeadSoftware EngineerRemedy Approved Consultant From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Tuesday, October 17, 2006 1:58 PMTo: arslist@ARSLIST.ORGSubject: Re: Remedy and TNSNAMES.ora ** Chris: What is TOAD? James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Chris Hidden Sent: Tuesday, October 17, 2006 12:50 PM To: arslist@ARSLIST.ORG 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. 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 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
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
Re: Remedy and TNSNAMES.ora
Title: RE: Remedy and TNSNAMES.ora ** ohI thought it was DB independentthen forget what I said in my last post...:) L. J. HeadSoftware EngineerRemedy Approved Consultant From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick WSent: Tuesday, October 17, 2006 2:00 PMTo: arslist@ARSLIST.ORGSubject: Re: Remedy and TNSNAMES.ora ** TOAD is a GUI SQL editor/browser application. It stands for Tool for Oracle Application Development From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Tuesday, October 17, 2006 2:58 PMTo: arslist@ARSLIST.ORGSubject: Re: Remedy and TNSNAMES.ora ** Chris: What is TOAD? James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Chris Hidden Sent: Tuesday, October 17, 2006 12:50 PM To: arslist@ARSLIST.ORG 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. 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 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Remedy and TNSNAMES.ora
Title: RE: Remedy and TNSNAMES.ora ** 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:arslist@ARSLIST.ORG] On Behalf Of Chris Sent: Tuesday, October 17, 2006 1:04 PM To: arslist@ARSLIST.ORG 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 __20060125___This posting was submitted with HTML in it___
Re: Remedy and TNSNAMES.ora
Wellnot trying to be too condescending but that's what your Remedy Developer is for. If you give him requirements of what you would like changed I'm sure if he is worth anything as a developer of Remedy he would be able to provide you the product you need...assuming your company wants the changes made that is. L. J. Head Software Engineer Remedy Approved Consultant -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Chris Hidden Sent: Tuesday, October 17, 2006 2:16 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy and TNSNAMES.ora J.L. Thanks for the info. Yeah, I'm an end user as far as Remedy goes, we use it to track issues for our software development. However it lacks some capabilities that we would like to have so my goal was to link to the database and then extend the capabilities. Looks like I need to get into contact with the DBA and determine if they'll even let me do that. Thanks for everyones help! ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Remedy and TNSNAMES.ora
Title: RE: Remedy and TNSNAMES.ora ** Technically they have versions for databases other than Oracle (they just started with Oracle) Oracle, SQL Server, MySQL, DB2,Sybase Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of L. J. HeadSent: Tuesday, October 17, 2006 3:07 PMTo: arslist@ARSLIST.ORGSubject: Re: Remedy and TNSNAMES.ora ** ohI thought it was DB independentthen forget what I said in my last post...:) L. J. HeadSoftware EngineerRemedy Approved Consultant From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick WSent: Tuesday, October 17, 2006 2:00 PMTo: arslist@ARSLIST.ORGSubject: Re: Remedy and TNSNAMES.ora ** TOAD is a GUI SQL editor/browser application. It stands for Tool for Oracle Application Development From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of McKenzie, James J C-E LCMC HQISEC/L3Sent: Tuesday, October 17, 2006 2:58 PMTo: arslist@ARSLIST.ORGSubject: Re: Remedy and TNSNAMES.ora ** Chris: What is TOAD? James McKenzie -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Chris Hidden Sent: Tuesday, October 17, 2006 12:50 PM To: arslist@ARSLIST.ORG 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. 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 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Remedy and TNSNAMES.ora
Title: RE: Remedy and TNSNAMES.ora ** Fred: That might explain why when Chris connects to the database he was getting a port other than 1521. MS SQL defaults to 1433. I don't know about MySQL or DB2. James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Grooms, Frederick W Sent: Tuesday, October 17, 2006 1:32 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy and TNSNAMES.ora ** Technically they have versions for databases other than Oracle (they just started with Oracle) Oracle, SQL Server, MySQL, DB2, Sybase Fred __20060125___This posting was submitted with HTML in it___
Re: Remedy and TNSNAMES.ora
I would hate to see a Remedy system without at minimum an admin that could make changes...I would really recommend against changing anything in the Remedy DB at the DB level. Remedy maintains all of its own tables and indexes and if you add columns behind the scenes they would not translate to fields in your remedy forms and would likely get wiped out next time a change is made through the Remedy Admin tool. L. J. Head Software Engineer Remedy Approved Consultant -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Chris Hidden Sent: Tuesday, October 17, 2006 2:40 PM To: arslist@ARSLIST.ORG Subject: Re: Remedy and TNSNAMES.ora I think I've got my problem sorted out, so I should be able to hit the DBA with the appropriate questions (as soon as I find out how to get in touch with them!). J.L. - I'm not sure if we have a Remedy Developer, I would assume we do, but I doubt I could get any of his or her time for a fairly small project (small, but very valuable to those who would use it). ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
