Re: Fail Over Options

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
> > > '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).
> > > --
> > > Please see the official ORACLE-L FAQ:
> > > http://www.orafaq.com
> > > --
> > > Author: DENNIS WILLIAMS
> > > INET: DWILLIAMS_at_LIFETOUCH.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).
> >
> >
> > =====
> > 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
> >
> === 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Yechiel Adar
  INET: adar76_at_inter.net.il

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