Re: Faststart Failover
- From: Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx>
- To: jweatherman91@xxxxxxxxxxxxxx
- Date: Mon, 14 May 2007 07:17:28 +0200
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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
Other related posts:
