Re: RAC problem, TAF in primary/secondary role?


Given that you weren't aware of the 
primary/secondary option, it seems
likely that you haven't configured the
tnsnames.ora file, two listener.ora files 
and spfile to make best use of the configuration.
Look of INSTANCE_ROLE in the RAC
manuals, and primary/secondary.

I wouldn't normally expect to do a normal
shutdown on a RAC instance to test failover,
by the way, so I've only played around with
shutdown abort - which obviously wouldn't
result in a  "shutdown in progress" error.

If you want to post the relevant bits of the
listener and tnsnames files I'll take a quick
look to see if I can spot the problem.

Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Optimising Oracle Seminar - schedule updated Sept 19th





----- Original Message ----- 
From: "tomi wijanto" <restomi_w@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Sent: Friday, October 22, 2004 9:55 AM
Subject: Re: RAC problem, TAF in primary/secondary role?


Hi,

i have tested the primary / secondary role, and i
found some differences when using TAF.

For example when NOT using active_instance_count,
first i connect to instance A, and then i shutdown
instance A. From the same session, i check that it was
failed over to instance B (select * from v$instance).
Then i startup instance A and shutdown instance B. It
also failed over back to instance A.

But when i use prim/second role, failover didn't
worked. I always get error message 'shutdown in
process' or 'disconnected'.
So, does TAF not work in this kind of setting? The
only failover that is success is for connection/logon
time.

regards,
tomi


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

Other related posts: