Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h8PKQ9K25271 for ; Thu, 25 Sep 2003 15:26:09 -0500 X-ClientAddr: 66.27.56.213 Received: from www2.fatcity.com (rrcs-west-66-27-56-213.biz.rr.com [66.27.56.213]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h8PKQ9c25266 for ; Thu, 25 Sep 2003 15:26:09 -0500 Received: (from root@localhost) by www2.fatcity.com (8.11.6/8.11.6) id h8PHlMY32249 for oracle-l@orafaq.net; Thu, 25 Sep 2003 10:47:22 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D110E; Thu, 25 Sep 2003 10:39:58 -0800 Message-ID: Date: Thu, 25 Sep 2003 10:39:58 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Jared.Still@radisys.com Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Jared.Still@radisys.com Subject: re : cccp,sap, clustering Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=_alternative 0060D2E688256DAC_=" --=_alternative 0060D2E688256DAC_= Content-Type: text/plain; charset="us-ascii" Interesting, we hadn't considered setting up 2 Oracle homes on shared disk. Had we considered that, we would have likely still gone to a separate oracle home per node. These servers are running SAP, and SAP is the micro managing PHB of the COTS world. Changing OHOME can be non-trivial with SAP. Jared Piet de Visser Sent by: ml-errors@fatcity.com 09/25/2003 04:14 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L cc: Subject: re : cccp,sap, clustering Jared, Group, briefly : my preferred cluster has 4 or more machines, with a single oracle-home installed on the SAN. Optionally: a physical standby system of 2 or more machines with stdby db running, lgwr for transport, in max-avail-mode. a second oracle_home will be kept on the same san, but will be silent/unused during normal operations. Only on upgrades or tests will the 2nd ora-home be mounted to 1 of the nodes, so the upgrade can be performed. when upgrade is deemed a success, all other nodes will 1-by-1 stop, unmount-ohome, re-mount the patched ohome, and business continues as usual. When the last node is up for patch, we can either san-snap the new ohome, upgrade manually, or keep it for a while, to please damanagement with a rollback option. Alternatively, the standby-db can be used for a "running-upgrade", but this process is much more complex. Guiding principles: - copies of ohome are not a good thing, not even if handled by OUI, OEM, or any other tool, - but I need 2 copies, just in case one of them breaks (analogy: ctl-files, redo-logs). - in all cases, I prefer to work from a single-point-of-maintenance. Doubts: how many nodes or databases can realistically be served by 1 ohome on 1 single filesystem. Have one cust who plans to run 5+ databases on a 2-node cluster. Go explain the options for growth... When I tried to re-start an OFA discussion, some weeks back (Thank Tim, for nice reply), this was one of the items I wanted to try and shove INTO the STANDARD, or at least, discuss with some bright and experienced minds. Regards, PdV Oracle DBA, and Certified. You figure out the rest. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Piet de Visser INET: piet.de.visser@logicacmg.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --=_alternative 0060D2E688256DAC_= Content-Type: text/html; charset="us-ascii"
Interesting, we hadn't considered setting up 2 Oracle homes on shared disk.

Had we considered that, we would have likely still gone to a separate oracle
home per node.  These servers are running SAP, and SAP is the micro managing
PHB of the COTS world.  Changing OHOME can be non-trivial with SAP.

Jared




Piet de Visser <piet.de.visser@logicacmg.com>
Sent by: ml-errors@fatcity.com

 09/25/2003 04:14 AM
 Please respond to ORACLE-L

       
        To:        Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
        cc:        
        Subject:        re : cccp,sap, clustering




Jared, Group,

briefly : my preferred cluster has 4 or more machines,
with a single oracle-home installed on the SAN.
Optionally: a physical standby system of 2 or more machines
with stdby db running, lgwr for transport, in max-avail-mode.

a second oracle_home will be kept on the same san,
but will be silent/unused during normal operations.

Only on upgrades or tests will the 2nd ora-home be mounted
to 1 of the nodes, so the upgrade can be performed.
when upgrade is deemed a success, all other nodes
will 1-by-1 stop, unmount-ohome, re-mount the patched ohome,
and business continues as usual.
When the last node is up for patch,
we can either san-snap the new ohome,
upgrade manually, or keep it for a while,
to please damanagement with a rollback option.

Alternatively, the standby-db can be used for a "running-upgrade",
but this process is much more complex.

Guiding principles:
- copies of ohome are not a good thing, not even if handled by OUI, OEM, or
any other tool,
- but I need 2 copies, just in case one of them breaks (analogy: ctl-files,
redo-logs).
- in all cases, I prefer to work from a single-point-of-maintenance.

Doubts: how many nodes or databases can realistically be served
by 1 ohome on 1 single filesystem. Have one cust who plans to run 5+
databases on a 2-node cluster. Go explain the options for growth...

When I tried to re-start an OFA discussion,
some weeks back (Thank Tim, for nice reply),
this was one of the items I wanted to try and shove
INTO the STANDARD,
or at least, discuss with some bright and experienced minds.

Regards,

PdV
Oracle DBA, and Certified.
You figure out the rest.


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Piet de Visser
 INET: piet.de.visser@logicacmg.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

--=_alternative 0060D2E688256DAC_=-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Jared.Still@radisys.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).