Re: IP address change - HELP
What box did you change the ip address on? The Remedy server or the Oracle? If it was the oracle, did you update your tnsnames.ora file on the remedy server? _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Koski, David Sent: Tuesday, November 11, 2008 6:58 AM To: arslist@ARSLIST.ORG Subject: IP address change - HELP ** We recently changed the IP address on a new box from a public address to a private address. DNS has been updated, /etc/hosts (linux system), etc. Now ARS won't fire up. Oracle seems to be running fine and we can connect to it via SQL, however ARS seems to be having problems. The startup starts armonitor and arserverd but never starts the email engine or plugins. It doesn't appear the arserverd is fully starting. The TCP port is never opening. After startup the system sits for a while and then comes back with the following errors (Which doesn't seem to make sense, how can TNS time out but then immediately tell me the database is available): Tue Nov 11 08:46:34 2008 390600 : Failure during SQL operation to the database (ARERR 552) Tue Nov 11 08:46:34 2008 ORA-12170: TNS:Connect timeout occurred Tue Nov 11 08:46:49 2008 390600 : SQL database is now available (ARNOTE 592) The listener is running, everything is pointed right (We didn't change anything in the ARS or Oracle configs, just moved the DNS and changed the IPs) and the host firewall (as well as the departmental firewall) so no blocking. Does anyone have a clue? Has anyone seen this? Thanks David __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: IP address change - HELP
Quite simply your database isn't able to communicate with your app server. So you need to check things like firewall settings to make sure that the listner port is not blocked. Use ping, tnsping, traceroute, netstat to figure out if network wise all is in place. I had a situation simliar to this and it turned out to be that my nic cards weren't set to full duplex, bad cable, on a bad port. It was a bit fustrating to troubleshoot as it was working enough that pings and tnspings went through with no problems. Ben Cantatore Remedy Manager (914) 457-6209 Emerging Health IT 3 Odell Plaza Yonkers, New York 10701 [EMAIL PROTECTED] 11/11/08 8:57 AM ** We recently changed the IP address on a new box from a public address to a private address. DNS has been updated, /etc/hosts (linux system), etc. Now ARS won't fire up. Oracle seems to be running fine and we can connect to it via SQL, however ARS seems to be having problems. The startup starts armonitor and arserverd but never starts the email engine or plugins. It doesn't appear the arserverd is fully starting. The TCP port is never opening. After startup the system sits for a while and then comes back with the following errors (Which doesn't seem to make sense, how can TNS time out but then immediately tell me the database is available): Tue Nov 11 08:46:34 2008 390600 : Failure during SQL operation to the database (ARERR 552)Tue Nov 11 08:46:34 2008 ORA-12170: TNS:Connect timeout occurred Tue Nov 11 08:46:49 2008 390600 : SQL database is now available (ARNOTE 592) The listener is running, everything is pointed right (We didn't change anything in the ARS or Oracle configs, just moved the DNS and changed the IPs) and the host firewall (as well as the departmental firewall) so no blocking. Does anyone have a clue? Has anyone seen this? Thanks David __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: IP address change - HELP
I don't think that is the problem.. the immediate line after says that the SQL database is now available which means it was temporarily inaccessible. Did you'll make a change to the hostname as well as the IP or is it only an IP change? Is the email server installed on the same machine as the AR Server? Can you ping the AR Server on the new IP from the email server if its a different host using both the new IP address and the host name? Joe From: Koski, David [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, November 11, 2008 8:57:55 AM Subject: IP address change - HELP ** We recently changed the IP address on a new box from a public address to a private address. DNS has been updated, /etc/hosts (linux system), etc. Now ARS won’t fire up. Oracle seems to be running fine and we can connect to it via SQL, however ARS seems to be having problems. The startup starts armonitor and arserverd but never starts the email engine or plugins. It doesn’t appear the arserverd is fully starting. The TCP port is never opening. After startup the system sits for a while and then comes back with the following errors (Which doesn’t seem to make sense, how can TNS time out but then immediately tell me the database is available): Tue Nov 11 08:46:34 2008 390600 : Failure during SQL operation to the database (ARERR 552) Tue Nov 11 08:46:34 2008 ORA-12170: TNS:Connect timeout occurred Tue Nov 11 08:46:49 2008 390600 : SQL database is now available (ARNOTE 592) The listener is running, everything is pointed right (We didn’t change anything in the ARS or Oracle configs, just moved the DNS and changed the IPs) and the host firewall (as well as the departmental firewall) so no blocking. Does anyone have a clue? Has anyone seen this? Thanks David __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: IP address change - HELP
Well the problem is that it continues to do it and ARS is never accessible (We never see our TCP port open). None of the plugins are starting up as well, it seems to continue to go through this cycle. ARS/Oracle, etc are all installed on the same box. We changed the IP on that particular box and the tnsnames.ora file, etc are all set to the DNS name of the host. We've been able to login and out of oracle with sqlplus without an issue. DNS was update and has propagated and the /etc/hosts files were update to reflect the IP change (The DNS name is exactly the same, it was only the IP that changed). We essentially moved it from a public IP address into private space. David From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Tuesday, November 11, 2008 11:01 AM To: arslist@ARSLIST.ORG Subject: Re: IP address change - HELP ** I don't think that is the problem.. the immediate line after says that the SQL database is now available which means it was temporarily inaccessible. Did you'll make a change to the hostname as well as the IP or is it only an IP change? Is the email server installed on the same machine as the AR Server? Can you ping the AR Server on the new IP from the email server if its a different host using both the new IP address and the host name? Joe From: Koski, David [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, November 11, 2008 8:57:55 AM Subject: IP address change - HELP ** We recently changed the IP address on a new box from a public address to a private address. DNS has been updated, /etc/hosts (linux system), etc. Now ARS won’t fire up. Oracle seems to be running fine and we can connect to it via SQL, however ARS seems to be having problems. The startup starts armonitor and arserverd but never starts the email engine or plugins. It doesn’t appear the arserverd is fully starting. The TCP port is never opening. After startup the system sits for a while and then comes back with the following errors (Which doesn’t seem to make sense, how can TNS time out but then immediately tell me the database is available): Tue Nov 11 08:46:34 2008 390600 : Failure during SQL operation to the database (ARERR 552) Tue Nov 11 08:46:34 2008 ORA-12170: TNS:Connect timeout occurred Tue Nov 11 08:46:49 2008 390600 : SQL database is now available (ARNOTE 592) The listener is running, everything is pointed right (We didn’t change anything in the ARS or Oracle configs, just moved the DNS and changed the IPs) and the host firewall (as well as the departmental firewall) so no blocking. Does anyone have a clue? Has anyone seen this? Thanks David __Platinum Sponsor: www.rmsportal.comhttp://www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: IP address change - HELP
When you changed the IP did you restart Oracle? The Oracle server will cache some of its connection information, which will prevent some types of connections to fail (i.e. sqlplus will work, but the OCI connections will fail). Also in Remedy are you referencing the Oracle server as a Remote database or Local database? Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Koski, David Sent: Tuesday, November 11, 2008 12:37 PM To: arslist@ARSLIST.ORG Subject: Re: IP address change - HELP Well the problem is that it continues to do it and ARS is never accessible (We never see our TCP port open). None of the plugins are starting up as well, it seems to continue to go through this cycle. ARS/Oracle, etc are all installed on the same box. We changed the IP on that particular box and the tnsnames.ora file, etc are all set to the DNS name of the host. We've been able to login and out of oracle with sqlplus without an issue. DNS was update and has propagated and the /etc/hosts files were update to reflect the IP change (The DNS name is exactly the same, it was only the IP that changed). We essentially moved it from a public IP address into private space. David From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Tuesday, November 11, 2008 11:01 AM To: arslist@ARSLIST.ORG Subject: Re: IP address change - HELP I don't think that is the problem.. the immediate line after says that the SQL database is now available which means it was temporarily inaccessible. Did you'll make a change to the hostname as well as the IP or is it only an IP change? Is the email server installed on the same machine as the AR Server? Can you ping the AR Server on the new IP from the email server if its a different host using both the new IP address and the host name? Joe From: Koski, David [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, November 11, 2008 8:57:55 AM Subject: IP address change - HELP We recently changed the IP address on a new box from a public address to a private address. DNS has been updated, /etc/hosts (linux system), etc. Now ARS won't fire up. Oracle seems to be running fine and we can connect to it via SQL, however ARS seems to be having problems. The startup starts armonitor and arserverd but never starts the email engine or plugins. It doesn't appear the arserverd is fully starting. The TCP port is never opening. After startup the system sits for a while and then comes back with the following errors (Which doesn’t seem to make sense, how can TNS time out but then immediately tell me the database is available): Tue Nov 11 08:46:34 2008 390600 : Failure during SQL operation to the database (ARERR 552) Tue Nov 11 08:46:34 2008 ORA-12170: TNS:Connect timeout occurred Tue Nov 11 08:46:49 2008 390600 : SQL database is now available (ARNOTE 592) The listener is running, everything is pointed right (We didn’t change anything in the ARS or Oracle configs, just moved the DNS and changed the IPs) and the host firewall (as well as the departmental firewall) so no blocking. Does anyone have a clue? Has anyone seen this? Thanks David ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are