RE: Cluster testing

  • From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 11 Feb 2004 09:30:42 -0500

Sean,

I'm running the same using 8.1.7.  Because the expectations of OFS are so
basic, your tests are also basic.

Try the obvious:

1).  Simply shut the database down manually and make sure that OFS restarts
it.  This test Oracle crashes and database restarts - something that you
don't get in non-clustered systems by-the-way.
2).  Issue a "lsnrctl stop" and watch as OFS restarts it - another bouns you
don't get on non-clustered machines.
3).  Change the init.ora file - place an invalid param in there.  My
favorite is "toms_crash=yes".  Shut the database down.  Watch as OFS tries
to restart the database.  And then watch it fail over to the other machine.
This only works if you have two Oracle homes - one for each machine.
4).  The big obvious one - shut down the primary machine and watch OFS bring
the db up on the backup server.

I've been running OFS for 3 years now and it's not even a minor worry.

Good Luck!  

Tom Mercadante
Oracle Certified Professional


-----Original Message-----
From: O'Neill, Sean [mailto:Sean.ONeill@xxxxxxxxxx]
Sent: Wednesday, February 11, 2004 9:19 AM
To: 'List, Oracle-l Freelists'
Subject: Cluster testing


Hi Folks,

We're implementing Oracle 9i on MSCS with OFS, W2K, Compaq hardware
(including SAN), Cisco swtiches.  We've a well known ERP software using =
the
9i database.  Anyways I was wondering if anyone could provide
feedback/advice on what tests we should take the cluster config through =
to
prove it does what it says on the box so-to-speak =3D:-0

References to papers or ideally maybe a checklist you have used, or =
would
use if you were implementing clustering ;)   would be much appreciated.

-------------------------
Se=E1n O' Neill
Organon (Ireland) Ltd.
[subscribed: digest mode]=20
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: