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

Hi,

i have tested it again, and now failover back and
forth between instance is working.
Before in tnsnames, i use INSTANCE_ROLE of PRIMARY for
primary connection, and SECONDARY for backup
connection.
Now i change both of them to ANY. But, i'm still not
sure if this is the best way, because in all samples i
found, they use PRIMARY and SECONDARY instead of ANY.

tnsnames.ora in client
------------------
MYDB_PRI =
  (DESCRIPTION =
    (LOAD_BALANCE=off)(FAILOVER=on)
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST =
SERVER_A)(PORT = 1522))
      (ADDRESS = (PROTOCOL = TCP)(HOST =
SERVER_B)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = mydb)
      (INSTANCE_ROLE = ANY)  # PRIMARY ??
      (SERVER = DEDICATED)
      (FAILOVER_MODE =
         (type=select)(method=basic)
         (backup=MYDB_SEC)
      )
    )
  )

MYDB_SEC =
  (DESCRIPTION =
    (LOAD_BALANCE=off)(FAILOVER=on)
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST =
SERVER_B)(PORT = 1522))
      (ADDRESS = (PROTOCOL = TCP)(HOST =
SERVER_A)(PORT = 1522))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = mydb)
      (INSTANCE_ROLE = ANY)  # SECONDARY ?? 
      (SERVER = DEDICATED)
      (FAILOVER_MODE =
         (type=select)(method=basic)
         (backup=MYDB_PRI)
      )
    )
  )

init.ora
--------
mydb1.LOCAL_LISTENER = LISTENER_RAC1
mydb2.LOCAL_LISTENER = LISTENER_RAC2
mydb1.REMOTE_LISTENER = LISTENER_RAC
mydb2.REMOTE_LISTENER = LISTENER_RAC

listener.ora in server
------------------
LISTENER_RAC1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER_A)(PORT
= 1522))
  )

LISTENER_RAC2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER_B)(PORT
= 1522))
  )

LISTENER_RAC =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST =
SERVER_A)(PORT = 1522))
      (ADDRESS = (PROTOCOL = TCP)(HOST =
SERVER_B)(PORT = 1522))
    )
  )

regards,
tomi

--- Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx>
wrote:

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



        
                
__________________________________
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
http://promotions.yahoo.com/new_mail
--
http://www.freelists.org/webpage/oracle-l

Other related posts: