This for RAC 10gR2.

I would like to test my client-side application code that deals
with catching and reporting a lost or broken connection to
the database.

What's the best way to simulate a connection failure?
ALTER SYSTEM KILL SESSION '$SID,$SERIAL#' via another process?
Is there an equivalent command that doesn't need to know
the RAC node?

Any pointers to other testing considerations appreciated.

Many TIA!
Mark

--
Mark Harrison
Pixar Animation Studios

<mh (AT) pixar (DOT) com> a écrit dans le message de news: bOW3l.7251$pr6.220 (AT) flpi149 (DOT) ffdc.sbc.com...
Unplug the cable.

Regards
Michel

<mh (AT) pixar (DOT) com> a écrit dans le message de news: bOW3l.7251$pr6.220 (AT) flpi149 (DOT) ffdc.sbc.com...
Unplug the cable.

Regards
Michel

<mh (AT) pixar (DOT) com> a écrit dans le message de news: bOW3l.7251$pr6.220 (AT) flpi149 (DOT) ffdc.sbc.com...
Unplug the cable.

Regards
Michel

<mh (AT) pixar (DOT) com> a écrit dans le message de news: bOW3l.7251$pr6.220 (AT) flpi149 (DOT) ffdc.sbc.com...
Unplug the cable.

Regards
Michel

Michel Cadot wrote:
Or flip the switch to off on a router or hub.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Michel Cadot wrote:
Or flip the switch to off on a router or hub.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Michel Cadot wrote:
Or flip the switch to off on a router or hub.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Michel Cadot wrote:
Or flip the switch to off on a router or hub.
--
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

mh (AT) pixar (DOT) com wrote:
Looking at it from the other side, the worst problems I think to have
land on anyone's desk are to do with investigating connectivity issues.
Somehow there is never an easy answer. So, looking at how you might test
for these you might want to look at Oracle's metaLink site, search for
"connectivity issues" or "Lost contact to oracle" and you should find
your way to some sort of trouble-shooting guide which you might possibly
be able to use to deliberately break your connectivity (without
dismantling your organisation network) so you can do your tests. Besides
whenever I've seen these sort of issues, it seems to be limited to
Oracle/SQL*Net, i.e. there'll be a particular application getting errors
but telnet/ssh sessions are fine, so pulling a cable out or switching
off the router might not be representative of what you might actually
face (one day), and what you appear to want to test.

As an aside, whilst killing the session might test one sort of "lost"
connection scenario, the ones you probably want to test are more
network/TCP/RAC related, which are different I think from a straight
forward killed session. In other words, I think when you actively kill a
session Oracle goes through a certain set of internal procedures to
ensure the kill is clean, whereas a sudden connection loss (as with a
network loss) may be handled differently.