Re: OPS on a single machine ?

Hi,

thanks alot for all the information.
It is ok if it is not officially supported by Oracle since I need the configuration just for testing.
The future purpose is an installation at a client's side to have one instance optimized for OLTP and one for reporting. But they have to access the same physical database. So, OPS seemed to be perfect. I guess I'll just try to install it at home over the weekend.

| Regards,                   |
| Stefan Jahnke              |
| BOV AG                     |
| @:D2 Vodafone, Abt.: FBOM  |
| Tel.: 0211/533-4893        |
 ----------------------------

Scott schrieb:
>
> Setfan, In OPS or RAC the locking is controlled by the
> DLM which is only communicated through the
> interconnect. The interconnect can be public or
> private. Private interconnects are highly recommended.
> Access to the data blocks by each instance is
> controlled by the DLM. DLM's communicate to each other
> via the interconnect. An instance cannot access a
> block without obtaining a PCM lock 1st(PCM locks are
> managed by the DLM). If the instance is doing a read
> the PCM lock is shared and all instances doing a read
> will also obtain a share lock. However if the instance
> is doing a DML then that instance will get an xclusive
> lock and that is the only instance that can access
> that block. If another instance requires that block
> then that instance has to request the holding instance
> to release the lock(Global enqueue). The holding
> instance writes the block back to disk the lock is
> released and the requesting instance now gets the PCM
> lock in a status (shared or xclusive) depending of the
> whether the activity is a select or DML. Now some of
> the disk I/O associated with DML changes in 9i because
> of cache fusion. You will also need the Cluster
> Manager that comes with your OS so Oracle can
> establish the communications between the nodes. Even
> if you want to install OPS an single node you still
> need the CM. Without the CM and OPS you cannot have 2
> instances concurrently accessing the same disks. It
> doesn't matter whether the instances are on the same
> machine or not.
>
> Scott
>
> --- Stefan Jahnke <stefan.jahnke_at_d2vodafone.de> wrote:
> > 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).
>
> __________________________________________________
> Do You Yahoo!?
> Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
> http://im.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Scott
> INET: oraracdba_at_yahoo.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).
>
> ---------------------------------------------------------
> 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!
> ---------------------------------------------------------

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