Veritas Cluster Server does this. I understand 9i RAC
does this as well, but I do not have any hands on
experience with it.
Pete
- Yechiel Adar <adar76_at_inter.net.il> wrote:
> I heard that there is a network switch or router
> that does dynamic
> translation
> of IP addresses. So you can always connect to one
> address and change the
> translation in the switch/router in case of fail
> over.
> This should be transparent to your thin jdbc client.
>
> Yechiel Adar
> Mehish
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> Sent: Wednesday, August 28, 2002 11:18 PM
>
>
> > Ricjard is correct. jdbc thin client does not
> allow
> > transparent fail over. The thick client reads a
> > tnsnames.ora file which is where the fail over
> > actually occurs. There are multiple server names
> for
> > the same service name. If the first server in the
> > search is down, it falls through to the next
> server.
> >
> > jdbc is a straight connection to a single
> database.
> > No read of tnsnames.ora.
> >
> > Pete
> >
> > --- "Ji, Richard" <Richard.Ji_at_MobileSpring.com>
> wrote:
> > > Dennis,
> > >
> > > One thing you can't do with Thin driver is
> > > Transparent Application Failover
> > > which is what Peter wants to do I believe.
> > >
> > > Richard
> > >
> > > -----Original Message-----
> > > Sent: Wednesday, August 28, 2002 1:00 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Peter - A couple of issues come to mind:
> > >
> > > 1) So you are saying that connection failover is
> > > your prime interest at this
> > > stage? I was thinking database failover when I
> saw
> > > your question.
> > > 2) So what is wrong with thin client? At my site
> we
> > > are tending to go with
> > > thin so we don't have to install SQL*Net client
> on
> > > every app server. That
> > > was what attracted us to Java in the first
> place.
> > > Everything I've seen says
> > > that for some applications thin has better
> > > performance and for others OCI is
> > > better. Personally I like having options.
> > > 3) How committed to Oracle is your site? If you
> have
> > > a heavy Oracle
> > > commitment, you may be able to stick it to IBM's
> > > attitude. Traditionally IBM
> > > has had an attitude of "use all of our stuff".
> This
> > > goes back to when they
> > > were the Microsoft of the computer industry.
> Nobody
> > > worries about IBM
> > > monopolizing the industry today. Obviously they
> are
> > > learning to shed that
> > > parochial attitude in order to succeed today.
> I'll
> > > bet if you complained up
> > > the IBM management chain about this person's
> > > attitude you might see a change
> > > for the better.
> > >
> > > Dennis Williams
> > > DBA
> > > Lifetouch, Inc.
> > > dwilliams_at_lifetouch.com
> > >
> > >
> > > -----Original Message-----
> > > Sent: Tuesday, August 27, 2002 5:49 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Dennis,
> > >
> > > This is a auite of products. The prime offender
> is
> > > WebSphere, an IBM product. The IBM consultants
> have
> > > been particularly difficult to deal with.
> According
> > > to them, nothing Oracle ever produced works.
> > >
> > > The project specifications call for transparent
> fail
> > > over which is possible using Oracle's thick
> client.
> > > Unfortunately, WebSphere does not seem to be
> able to
> > > use anything but jdbc thin client.
> > >
> > > If we can't get this to work, we will likely go
> to
> > > something like Veritas Cluster Server.
> Replication
> > > provided a solution that had already paid for.
> > >
> > >
> > > --- DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
> wrote:
> > > > Peter - Have you looked at Oracle Standby
> Server?
> > > > Which App server are you
> > > > using? Most of them claim to help you with
> this.
> > > > Dennis Williams
> > > > DBA
> > > > Lifetouch, Inc.
> > > > dwilliams_at_lifetouch.com
> > > >
> > > >
> > > > -----Original Message-----
> > > > Sent: Tuesday, August 27, 2002 3:38 PM
> > > > To: Multiple recipients of list ORACLE-L
> > > >
> > > >
> > > > We are looking at fail over options for
> databases
> > > in
> > > > a
> > > > 7x24 e-commerce environment.
> > > >
> > > > Currently, we are using advanced replication.
> It
> > > > works but it is labor intensive. We have also
> > > > discovered that the application can only use
> jdbc
> > > > rather than the Oracle thick client. In
> essence,
> > > > this
> > > > replication is now manual fail over.
> > > >
> > > > Would someone who has made java and the thick
> > > client
> > > > work provide some pointers to getting it to
> work?
> > >
> > > >
> > > >
> > > > Thanks,
> > > >
> > > >
> > > >
> > > > =====
> > > > Pete Barnett
> > > > Lead Database Administrator
> > > > The Regence Group
> > > > pnbarne_at_regence.com
> > > >
> > > >
> __________________________________________________
> > > > Do You Yahoo!?
> > > > Yahoo! Finance - Get real-time stock quotes
> > > > http://finance.yahoo.com
> > > > --
> > > > Please see the official ORACLE-L FAQ:
> > > > http://www.orafaq.com
> > > > --
> > > > Author: Peter Barnett
> > > > INET: regdba_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
>
=== message truncated ===
Pete Barnett
Lead Database Administrator
The Regence Group
pnbarne_at_regence.com
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Peter Barnett
INET: regdba_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).
Received on Thu Sep 05 2002 - 12:13:32 CDT