RE: alert log entries not sequential

  • From: "Adams, Matthew (GE Consumer & Industrial)" <MATT.ADAMS@xxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 25 Aug 2004 09:17:14 -0400

No idea at all.  We do know for a certainty=20
that the Veritas Cluster went "split brain"
(i love that term our sysop came up with)
and both sides of the cluster thought it owned
the package in question and both sides mounted,
opened and wrote to the database files.

But since the clocks are in-sync I cannot come=20
with a reason that the timestamps on the alert logs
would be so out of order, even with both sides
writing to it.

----
Matt Adams - GE Appliances - matt.adams@xxxxxxxxxxx
"The swim only hurt once - from the beginning
to the end" - Doc Counsilman on swimming the
English Channel at age 58

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Mercadante, Thomas F
Sent: Wednesday, August 25, 2004 9:12 AM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: alert log entries not sequential


Matt,

Just curious - what do you think it is?

Tom Mercadante
Oracle Certified Professional


-----Original Message-----
From: Adams, Matthew (GE Consumer & Industrial) =
[mailto:MATT.ADAMS@xxxxxx]=20
Sent: Wednesday, August 25, 2004 9:05 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: alert log entries not sequential


I'm pretty sure the reason that it didn't=3D20
work had nothing to do with the clocks.



----
Matt Adams - GE Appliances - matt.adams@xxxxxxxxxxx
"The swim only hurt once - from the beginning
to the end" - Doc Counsilman on swimming the
English Channel at age 58

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Wolfson Larry - lwolfs
Sent: Tuesday, August 24, 2004 8:48 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: alert log entries not sequential


Matt,
        But it didn't work did it?

        Larry

"This is a veritas cluster (non-RAC/OPS) on solaris 8 with oracle =3D =
8.1.7.4
that failed over from one node to another because the network =
connectivity
between =3D the two nodes failed.  Multiple times."

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Adams, Matthew (GE Consumer & Industrial)
Sent: Monday, August 23, 2004 1:08 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: alert log entries not sequential


Sent a reply earlier.  Didn't see it come through. =3D3D20
Maybe it will someday.

Yes, both systems are sync'ed.  The pretty much have=3D3D20
to be for Veritas clustering to work.

Matt

----
Matt Adams - GE Appliances - matt.adams@xxxxxxxxxxx
If C gives you engouth rope to hang yourself, then C++ gives you enough =
rope
to hang yourself, your dog, your co-workers, and everyone in your
neighborhood.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Mercadante, Thomas F
Sent: Monday, August 23, 2004 2:03 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: alert log entries not sequential


Matt,

So the first question still applies.  Do the two machines have the same
timestamp?  Wolfgang & I are guessing that they do not match.

Tom Mercadante
Oracle Certified Professional


-----Original Message-----
From: Adams, Matthew (GE Consumer & Industrial) =3D3D
[mailto:MATT.ADAMS@xxxxxx]=3D3D20
Sent: Monday, August 23, 2004 1:58 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: alert log entries not sequential


Sorry, I should have explained a little better.

This is a veritas cluster (non-RAC/OPS) on solaris 8
with oracle 8.1.7.4  that failed
over from one node to another because the network=3D3D3D20 connectivity =
=3D =3D3D
between the two nodes failed.  Multiple times.


----
Matt Adams - GE Appliances - matt.adams@xxxxxxxxxxx
If C gives you engouth rope to hang yourself, then C++ gives you enough =
=3D
=3D3D rope to hang yourself, your dog, your co-workers, and everyone in =
your
neighborhood.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx =3D3D
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Mercadante, Thomas F
Sent: Monday, August 23, 2004 1:53 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: alert log entries not sequential


That's what I was thinking of, but I was not sure if Matt's thread was
dealing with RAC (two servers) or not.

Tom Mercadante
Oracle Certified Professional


-----Original Message-----
From: Wolfgang Breitling [mailto:breitliw@xxxxxxxxxxxxx]=3D3D3D20
Sent: Monday, August 23, 2004 1:42 PM
To: oracle-l@xxxxxxxxxxxxx; Adams, Matthew (GE Consumer & Industrial)
Subject: Re: alert log entries not sequential


Are the clocks on the two servers in sync?
Quoting "Adams, Matthew (GE Consumer & Industrial)" <MATT.ADAMS@xxxxxx>:

> Database opened normally at 2:15:25
> Entries show a shutdown abort at 2:32:14, when the veritas =3D3D
cluster=3D3D3D20 =3D3D20
>failed over to the other node, but a few lines later, it's =3D3D
reported=3D3D3D20 =3D3D20
>tablespaces were put into backup mode at 2:18:15 =3D3D3D20  Anybody =
know=20
>what might account for this fact?

--=3D3D3D20
regards

Wolfgang Breitling
Oracle 7,8,8i,9i OCP DBA
Centrex Consulting Corporation
www.centrexcc.com

----------------------------------------------------------------
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
-----------------------------------------------------------------
----------------------------------------------------------------
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
-----------------------------------------------------------------
----------------------------------------------------------------
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
-----------------------------------------------------------------


**********************************************************************
The information contained in this communication is confidential, is =
intended
only for the use of the recipient named above, and may be legally
privileged. If the reader of this message is not the intended recipient, =
you
are hereby notified that any dissemination,=3D20 distribution, or =
copying of
this communication is strictly prohibited. If you have received this
communication in error, please re-send this communication to the sender =
and
delete the original message or any copy of it from your computer system.
Thank You.

----------------------------------------------------------------
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
-----------------------------------------------------------------
----------------------------------------------------------------
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: