OK. One of the things that is difficult to gauge in a newsgroup is whether
others are interested or not, so what I try and do after a few posts
backwards and forwards between myself and one other person, I take them
offline. Anyway, here's the details of what's being going on between
Shirley and I via email.
FailSafe is an NT only product that allows a single instance database to
automatically failover from one node of an NT cluster to the other node, if
the first node fails. I think it's on a separate CD to the server CD, but
as I rarely use the CD's I'm not 100% sure of that.
If you want to set up SQL*Net for the ability to connect to a primary node,
then a secondary node if the primary is down, all you need is two ADDRESS
lists for your alias, like this:
ORCL.US.ORACLE.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = psharman-node1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = psharman-node2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
If node 1 is not up, you'll connect to node 2. Note this is used for OPS,
not FailSafe. Also, this is NOT transparent application failover, that came
in 8.0. If the first node dies, the user will need to reconnect.
HTH.
Pete
Nathan Phan wrote:
> 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
> > x-mozilla-cpt:;29648
> > fn:Pete Sharman
> > end:vcard
> >
> > --------------C24A24207264DA1264C5DE1E--
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
--
Regards
Pete
Received on Wed Jun 16 1999 - 11:01:35 CDT
