sorry for the typos in my posting before, i just said 'tnsnames.ora in server' as 'listener.ora in server'. Let me repost tnsnames and listener file in db server. listener.ora in db server: -------------------------- -- entry for mydb2 is almost same with mydb1 below LISTENER_RAC = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER_A)(PORT = 1522)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = rac_1)) ) ) ) SID_LIST_LISTENER_RAC = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /home/oracle/app/oracle/product/920) (PROGRAM = extproc) ) (SID_DESC = (ORACLE_HOME = /home/oracle/app/oracle/product/920) (SID_NAME = mydb1) ) ) tnsnames.ora in db server ------------------------- --for mydb1 LISTENER_RAC1 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER_A)(PORT = 1522)) ) --for mydb2 LISTENER_RAC2 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER_B)(PORT = 1522)) ) --for both remote listener LISTENER_RAC = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER_A)(PORT = 1522)) (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER_B)(PORT = 1522)) ) ) regards, tomi --- tomi wijanto <restomi_w@xxxxxxxxx> wrote: > 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 _______________________________ Do you Yahoo!? Declare Yourself - Register online to vote today! http://vote.yahoo.com -- //www.freelists.org/webpage/oracle-l