Re: Faststart Failover

From: Carel-Jan Engel <cjpengel.dbalert_at_xs4all.nl>
Date: Mon, 14 May 2007 07:17:28 +0200
Message-Id: <1179119848.7490.7.camel@lagavulin.dbalert.eu>

John,

No paper at had, but an example how I set up a failover of the tnsnames entry below might help:

#
# The application alias, failover to the active primary
#

d10b =
  (DESCRIPTION =
(FAILOVER=ON)
(LOAD_BALANCE=OFF)
(ADDRESS = (PROTOCOL = TCP)(HOST = ardbeg)(PORT = 1523))
(ADDRESS = (PROTOCOL = TCP)(HOST = bowmore)(PORT = 1523))
(ADDRESS = (PROTOCOL = TCP)(HOST = caolila)(PORT = 1523))
(CONNECT_DATA =

      (SERVICE_NAME = d10b)
    )
  )

This is for database with SID d10b, and three servers.

If you switch/failover your test database, the only thin in SQL*Plus you need to do is reconnect, using the 'd10b' connect string alias.

Your problem with ODBC might be related to the thin client. To start another opinion-war, I pretty much dislike this 'easy connect' (another term generated by Oracle's Marketing Obfuscation Toolkit) method. I much more prefer the thick client. The thick client uses OCI, and yes it needs installation of some Oracle client software. OTOH, in return, you as a DBA will get control over were your instances reside. IMHO, the power of the DBA should extend to the client configuration, regarding Oracle*Net (previously know as SQL*Net). Thick client allows that, for the JDBC thin client you have to enter your connect strings in an obscure properties file, belonging to the application. Why do you need an application administrator to move your database to another server?

Thin client can deal with Fast Start Failover. Just substitute the alias in the properties file with the complete connect string, similar to: (DESCRIPTION = (FAILOVER=ON) (LOAD_BALANCE=OFF) (ADDRESS = (PROTOCOL = TCP)(HOST = ardbeg)(PORT = 1523)) (ADDRESS = (PROTOCOL = TCP)(HOST = bowmore)(PORT = 1523)) (ADDRESS = (PROTOCOL = TCP)(HOST = caolila)(PORT = 1523)) (CONNECT_DATA = (SERVICE_NAME = d10b)))

HTH Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok) ===

On Sun, 2007-05-13 at 17:30 -0500, John P Weatherman wrote:

> All,
> 
> Can anyone point me to a good white paper of setting up clients for
> Faststart Failover to a Data Guard standby?  We are having issues with
> getting JDBC clients to restart properly, and Oracle wants us to verify
> that SqlPlus fails over normally.  The problem is, I can't find a good
> paper to set up the SqlPlus failover so I don't know what exactly
> "normally" is.  Any guidance would be appreciated.  I haven't worked
> with Faststart until now and walked into the TAR my second day on the
> new job.
> 
> TIA,
> 
> John
> 
> 
> John P Weatherman
> Oracle DBA
> Asurion
> 
> --
> http://www.freelists.org/webpage/oracle-l
> 
> 

--
http://www.freelists.org/webpage/oracle-l

Received on Mon May 14 2007 - 00:17:28 CDT