Dear collegues,
Who can give me clues on this:
We're running Oracle 7.3.4 on a double 4100 (cluster) under Tru64 4.0d/1.5.
Both OS and DBMS are installed locally, the database itself resides on a
RAID, which is completely configured as a ASE service. I created start/stop
scripts that will actually start and stop all three databases and the Oracle
listener. There's only one 4100 by which the database is accessable, the
other 4100 is "standby" and will take over if the active machine fails.
I observered an unplanned fail-over once (due to machine check!) and since
nothing has been changed in the working environment, it is to be expected to
work again.
It didn't.
Alas, I was on holiday at the time so I only can tell from "hear tell" what
happened.
The one machine that runs Oracle failed - again, due to a machine check, I
found out) but the database was NOT taken over by the other machine - at
least, no data could be accessed. What my collegues did was restart both
machines, it seems the service has ben started on the preferred node, but
one database (the most important one) did not start automatically. Logging
is as Oracle, it was able to start it manually.
I can't find ANYTHING on what caused the failure. On the standby node, I
found Oracle files left, of two databases, not of the most important one. So
it is possible that the service has started - just not the database.
When cheching, I found cmon (the graphical cluster monitor) signals "No ASE
reports received" and will show both(!) nodes as "unavailable" - where both
are up and running.....asemgr however works fine.
So:
- Where can I find information on the failover (in the system) - even after
some time?
- Why does cmon signal trouble where there is none?
- How to solve (better: prevent) this to happen again?
Thanks in advance.
Willem Grooters
Sema Group Informatica BV
Managed Services
Tel. +31 (0)294 239 500
Fax. +31 (0)294 239 501
E-mail Willem.Grooters_at_sema.nl
------------------------------------------------------------------------
This e-mail is confidential and intended solely for the use of the
individual(s) to whom it is addressed. Any views and opinions presented
are solely those of the author and do not necessarily represent those of
Sema Group.
If you are not the intended recipient, be advised that you have received
this e-mail in error and that any use, dissemination, forwarding,
printing or copying of this e-mail is strictly prohinited.
If you have received this e-mail in error please notify Sema Group
Informatica by telephone +31 (0)294 239 500
------------------------------------------------------------------------
Received on Wed Aug 23 2000 - 13:49:23 NZST