Yes, we have three servers running in a server group - one admin server and two
user-facing servers. We have ARS 7.1 p5 on Windows Server 2003 with half of
ITSM 7.0.3 p6. Oracle is running on Linux (not sure which version, but may be
a version of Suse - I can find out if it makes a difference). We use LDAP
instead of TNSNAMES, but this is (the edited - formatting added, names and
ports changed) the output of tnsping:
C:\Users\lyletaylor>tnsping remedypr1
TNS Ping Utility for 32-bit Windows: Version 10.2.0.3.0 - Production on 16-NOV-2
009 15:18:26
Copyright (c) 1997, 2006, Oracle. All rights reserved.
Used parameter files:
C:\ORACLE\10GCLIENT\network\admin\sqlnet.ora
Used LDAP adapter to resolve the alias
Attempting to contact
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST= server1)(PORT=port))
(ADDRESS=(PROTOCOL=TCP)(HOST= server2)(PORT= port))
(ADDRESS=(PROTOCOL=TCP)(HOST= server3)(PORT= port))
(ADDRESS=(PROTOCOL=TCP)(HOST= server4)(PORT= port))
(CONNECT_DATA=(SERVICE_NAME=service)))
OK (0 msec)
My understanding is that two of the servers are there as standby hosts in case
the other two go down (that is, only two of the four are currently active).
We've failed over between the two that are actively up when we've had to
restart the databases due to patching, certain config changes, etc. In those
cases, they shutdown one, make the change, bring it up, and then do the same on
the other, pushing us back and forth between them.
I'm not sure about how we compare to what's listed under FAILOVER_MODE in your
entry. Perhaps we're using Oracle client defaults; I don't know what those
would be, however.
Lyle
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Ramey, Anne
Sent: Monday, November 16, 2009 1:58 PM
To: [email protected]
Subject: Re: Oracle RAC failover
**
We've not had these same problems in our non-server grouped development
environment. Do you have more than one ARS server in a server group?
We are running ARS 7.1 P 6 with ITSM 7.0.03 P 9 on Linux RHEL 4 OS, with Oracle
10g RAC with the following TNS names info:
REMEDYT =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = mydbhost1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = mydbhost2)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = myservicename)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
Anne Ramey
***********************************
E-mail correspondence to and from this address may be subject to the North
Carolina Public Records Law and may be disclosed to third parties only by an
authorized State Official.
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Lyle Taylor
Sent: Friday, November 13, 2009 5:02 PM
To: [email protected]
Subject: Re: Oracle RAC failover
**
We're using AR Server 7.1 p6 with Oracle in a RAC, and as far as I know, we've
never had any issues with it, and we have failed over from one server to
another. It's possible that the AR server got a couple intermittent errors,
but it has never crashed on us or shut itself down. I'm not sure what might be
different in our environment, but I would be willing to help look into things
(that is, compare our setup to yours) if you help me know what to look for.
Lyle
From: Action Request System discussion list(ARSList)
[mailto:[email protected]] On Behalf Of Tony Worthington
Sent: Friday, November 13, 2009 2:52 PM
To: [email protected]
Subject: Re: Oracle RAC failover
** We had the same issues and ended up abandoning RAC. Oracle told us that the
Transparent Application Failover (TAF) code that made the switch via OCI
libaries wasn't supported in the arserver binaries. Or we never figured out
how to set up our connection strings properly...
I'd also be interested to hear if someone has figured out how to fail over
without affecting arserver or requiring a restart.
http://wiki.oracle.com/page/Transparent+Application+Failover+(TAF)
Tony Worthington | Sr. Technical Analyst | Kohl's Department Stores
N56 W17000 Ridgewood Drive | Menomonee Falls, WI 53051 | office: (262)
703-7763 | e-mail: [email protected]
From:
"Ramey, Anne" <[email protected]>
To:
[email protected]
Date:
11/13/2009 03:40 PM
Subject:
Oracle RAC failover
Sent by:
"Action Request System discussion list(ARSList)" <[email protected]>
________________________________
**
We've been running ARS 7.0 then upgraded to 7.1 with ITSM 7.0 using Oracle RAC
as the DB for the last 2 years. Everything is fine when everything is up, but
we discovered recently that the failover just doesn't work. SQLPlus sessions
from the ARS servers work fine and recover from the pause in the failover fine.
Remedy just doesn't seem to be able to handle it at all. The DBAs say that
the oracle errors I see in the ARS logs are normal for a failover--but the app
just can't handle it. Does anyone have oracle RAC working so that the failover
actually prevents all ARS failures?
Anne Ramey
***********************************
E-mail correspondence to and from this address may be subject to the North
Carolina Public Records Law and may be disclosed to third parties only by an
authorized State Official.
_Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_
________________________________
CONFIDENTIALITY NOTICE:
This is a transmission from Kohl's Department Stores, Inc.
and may contain information which is confidential and proprietary.
If you are not the addressee, any disclosure, copying or distribution or use of
the contents of this message is expressly prohibited.
If you have received this transmission in error, please destroy it and notify
us immediately at 262-703-7000.
CAUTION:
Internet and e-mail communications are Kohl's property and Kohl's reserves the
right to retrieve and read any message created, sent and received. Kohl's
reserves the right to monitor messages by authorized Kohl's Associates at any
time
without any further consent.
_Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_
NOTICE: This email message is for the sole use of the intended recipient(s) and
may contain confidential and privileged information. Any unauthorized review,
use, disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply email and destroy all copies of
the original message.
_Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_
_Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
