Re: Oracle Parallel Server Option

No. You have one shared database, but two or more separate instances, each with a distinct SID. Some hardware vendors provide an automatic failover feature so that if one instance crashes the users are automatically re-routed to another instance when they log back in. How well failover works depends in part on how your users log in. That is do they log into an application server or directly to a database server and so on.

There are data partitioning issues with OPS in that you want all updaters for a heavy hit table to come from one machine. But that is getting well beyond the basics. Note with Oracle 8 there is an init.ora parameter that you must code to run parallel that does not exist in ver 7.0 - 7.3. When this parameter is coded the database always starts as if you entered: 'startup parallel'. There is a Parallel Server Concepts manual on the documentation CD.

In article <AC6JM7Us#GA.153_at_pet.hiwaay.net>,   "Shirley Kwan" <sskwan_at_ingr.com> wrote:
> So it means that I need to setup two machines with two instance of
the same
> name. And both instances are running at the same time. A shared disk
needed
> to setup to contain the actual tablespace and all client machine need
to
> point to the shared disk. If one machine fails, all client can still
access
> Oracle through the instance of another machine.
>
> Is that correct ???
>
> Thanks in advance !!!
>
> Shirley Kwan
>
> markp7832_at_my-deja.com wrote in message
<7jgh7i$nfj$1_at_nnrp1.deja.com>...
> >In article <nd1ohZKs#GA.200_at_pet.hiwaay.net>,
> > "Shirley Kwan" <sskwan_at_ingr.com> wrote:
> >> Hi all,
> >>
> >> Does anyone have information about Parallel Server Option ???
> >> How can I implement it ?
> >> What's the basic system requirement ?
> >> What's the advantage of using Parallel Server Option ?
> >> .......
> >> --
> >> Shirley Kwan......
> >>
> >The Oracle Parallel Server product comes with the Enterprise edition
of
> >Oracle. In inorder to set it up you must have multiple hardware
boxes
> >from a vendor that supports shared file systems. With versions 7.0 -
> >7.3 you have to setup the hardware vendors DLM, distributed lock
> >manager, and then you have to create the database with multiple
> >instances. Oracle has taken over providing the DLM with either
version
> >8 or 8.1.
> >
> >One of the main advantages of OPS is failover. Should one machine
have
> >a hardware failure you shift the load to the other machine(s)
providing
> >you hold the load to 50% of machine capacity in a two box setup.
> >Another is if you are approaching machine capacity you can add
another,
> >in theory cheaper, machine of the same type rather than upgrade to a
> >bigger box. With recent advances in hardware capacity and reduction
in
> >cost I see the only real advantage being failover.
> >
> >
> >
> >--
> >Mark D. Powell -- The only advice that counts is the advice that
> > you follow so follow your own advice --
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Share what you know. Learn what you don't.
>
>

--
Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 08 1999 - 08:36:47 CDT