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"
