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"
