Re[2]: OPS on a single machine ?

Folks,

    The idea behind OPS is to get two or more servers involved in the database to increase throughput. Therefore it is not possible to install OPS on a single server, you need two at a minimum. The method of synchronizing file writes is also OS specific and you need a manager for the purpose (MC/ServiceGuard in HP's case). Also data locks are propagated between the instances via network and a common file, something akin to the sgadef.ora file, but mainly network. There are a number of database views that one can access to see what is happening, like file_lock and file_ping. See the Oracle reference manual.

Dick Goulet

____________________Reply Separator____________________
Author: Stefan Jahnke <stefan.jahnke_at_d2vodafone.de>
Date:       9/4/2001 1:15 AM

Hi,

I'm just making assumptions. According to an Oracle guy, with OPS on 8.1.7, the instances communicate via 2 different ways. One way is via network connections (process to process communication). The other way is via locking blocks and propagating it via distr. lock manager. So, according to what he said, the instance is also taking a look at the disk directly and checking the block it wants to read (it's a raw device, so there won't be a file system). What I don't know is, how are the locks propagated ? Is there a shared datastructure (kind of a lock list) that can be accessed by both instances (and how is it maintained and accessed?) or does the instance check the status of the block directly ?

> Hallas John schrieb:
>
> That's an interesting concept. Won't there be problems with file
> sharing. Once the first instance has started will the 2nd one be
> allowed access to the datafiles?. I don't know much about raw files
> but I suspect that would be the problem area.
>
> -----Original Message-----
> From: Stefan Jahnke [mailto:stefan.jahnke_at_d2vodafone.de]
> Sent: 04 September 01 08:40
> To: Multiple recipients of list ORACLE-L
> Subject: OPS on a single machine ?
>
> Hi,
>
> I was wondering if it is possible to set up OPS on a single machine.
> Maybe like this:
> 1 disk as a raw device, then set up an instance to use the raw device
> and set up parallel server's second instance to use the raw device,
> too.
> Before I go through the hassle just to find out that it doesn't work,
> did anybody try this before ?
>
> (I'm on SuSE 7.2, Oracle 8.1.7 with OPS option)
>
> --
> ----------------------------
> | Regards, |
> | Stefan Jahnke |
> | BOV AG |
> | @:D2 Vodafone, Abt.: FBOM |
> | Tel.: 0211/533-4893 |
> ----------------------------
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Stefan Jahnke
> INET: stefan.jahnke_at_d2vodafone.de
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
>
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_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).
>
> **********************************************************************
> This email and any attachments may be confidential and the subject of
> legal professional privilege. Any disclosure, use, storage or copying
> of this email without the consent of the sender is strictly
> prohibited.
> Please notify the sender immediately if you are not the intended
> recipient and then delete the email from your inbox and do not
> disclose the contents to another person, use, copy or store the
> information in any medium.
> **********************************************************************
>
> ---------------------------------------------------------
> This Mail has been checked for Viruses
> Attention: Encrypted mails can NOT be checked!
>
> **
>
> Diese Mail wurde auf Viren geprueft
> Hinweis: Verschluesselte mails koennen NICHT auf Viren geprueft
> werden!
> ---------------------------------------------------------

-- 
 ----------------------------
| Regards,                   |
| Stefan Jahnke              |
| BOV AG                     |
| @:D2 Vodafone, Abt.: FBOM  |
| Tel.: 0211/533-4893        |
 ----------------------------
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stefan Jahnke
  INET: stefan.jahnke_at_d2vodafone.de

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_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).