| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Parallel Server Option
In article <3766754D.66E549E3_at_us.oracle.com>,
Pete Sharman <psharman_at_us.oracle.com> wrote:
> This is a multi-part message in MIME format.
> --------------C24A24207264DA1264C5DE1E
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> For those interested in this thread, I've taken it offline with
Shirley. Let me
> know if you're interested and we'll bring it back to the newsgroup
again.
Yes Pete, at least I am interested, the discussion just enter into the best part, don't kill me with that. Please bring the discussion on line again. Thanks !
>
> Pete
>
> Shirley Kwan wrote:
>
> > What is Oracle FailSafe ???
> >
> > For the Oracle OPS, you said that I need to set the tnsnames.ora to
the
> > active node first, then to the standby. Can you please give me an
example on
> > how to configure the tnsnames.ora ?
> >
> > Is it only one virtual host with shared media is visble to all
client
> > machine ???
> >
> > Thanks for your help !!!
> >
> > Shirley..........
> >
> > Pete Sharman wrote in message <375FE049.C9E9B762_at_us.oracle.com>...
> > >Shirley
> > >
> > >If you have two servers A and B, the database is located on shared
disks
> > which
> > >is visible to both A and B when you're using Parallel Server.
Which SID
> > and
> > >host you need to point to is determined by what you're trying to
achieve.
> > Are
> > >you using OPS as a hot standby (i.e. one node active, the other
standby)?
> > If
> > >that's the case, your tnsnames.ora should have a connection string
that
> > points
> > >to the active node first, then to the standby. If you have OPS in
> > >active-active configuration, then point the users to the node they
need to
> > use
> > >to minimize pinging etc.
> > >
> > >I'm not too sure of what you're trying to achieve, but it may be
that
> > Oracle
> > >FailSafe is what you need rather than OPS?
> > >
> > >Pete
> > >
> > >Shirley Kwan wrote:
> > >
> > >> So, how can I setup the sqlnet configuration for client ???
> > >> Which SID I use and which host I need to point to ???
> > >>
> > >> Say, if I have two server, A and B with SID A and B respectively.
Where
> > is
> > >> the database locate ??? Is it locate in the share media in server
C) ???
> > >>
> > >> For the sqlnet configuration for client, which one is correct ???
> > >> (1) SID = A, host = A & SID = B, host = B (set both or either one
???)
> > >> (2) SID = A, host = C & SID = B, host = C (set both or either one
???)
> > >>
> > >> Actually, we would like to use Oracle Parallel Server in NT
clustering
> > >> environment.
> > >> In NT clustering environment, only one virtual host is visible
for all
> > >> client although we have two server. Is Oracle Parallel Server
Option have
> > >> the same concept ???
> > >>
> > >> Thank you very much for your help !!!
> > >>
> > >> Shirley Kwan......
> > >>
> > >> markp7832_at_my-deja.com wrote in message
<7jj69e$kts$1_at_nnrp1.deja.com>...
> > >> >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.
> > >
> > >--
> > >
> > >
> > >Regards
> > >
> > >Pete
> > >
> > >
>
> --
>
> Regards
>
> Pete
>
> --------------C24A24207264DA1264C5DE1E
> Content-Type: text/x-vcard; charset=us-ascii;
> name="psharman.vcf"
> Content-Transfer-Encoding: 7bit
> Content-Description: Card for Pete Sharman
> Content-Disposition: attachment;
> filename="psharman.vcf"
>
> begin:vcard
> n:Sharman;Peter
> tel;fax:+1.650.633.1669
> tel;work:+1.650.607.0109
> x-mozilla-html:FALSE
> url:http://www.oracle.com
> org:Worldwide Internal Services Education;Oracle Corporation
> adr:;;500 Oracle Parkway M/S OPL-B1024;Redwood
Shores;California;94065;USA
> version:2.1
> email;internet:psharman_at_us.oracle.com
> title:Project Manager
> note;quoted-printable:SQL> select standard_disclaimer,
witty_remark=0D=0A 2 from company_requirements;=0D=0A=0D=0A ****
The statements and opinions expressed here are my **** =0D=0A **** own
and do not necessarily represent those of **** =0D=0A **** Oracle Corporation. =20****=0D=0A=0D=0A"Controlling application developers is like herding cats." =0D=0AKevin Loney, ORACLE DBA Handbook =0D=0A=0D=0A"Oh no it's not! It's much harder than that!" =0D=0ABruce Pihlamae, long term ORACLE DBA
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Wed Jun 16 1999 - 02:16:42 CDT
 |
 |