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_at_yahoo.com> To: <oracle-l_at_freelists.org> 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 Received on Fri Oct 22 2004 - 14:55:19 CDT