Re: TAF

It is better to set the failover=on and enable=broken
and also did u check on both listeners side that both
instances are getting registered for the service which
u are using.

I use the following tnsname and is working uptil now.

CMSPRD_BT =
  (DESCRIPTION =
    (LOAD_BALANCE = on)
    (FAILOVER = on)
    (enable = broken)
    (ADDRESS = (PROTOCOL = TCP)(HOST =
10.30.0.37)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST =
10.30.0.38)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = CMSPRD)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 120)
        (DELAY = 2)
      )
    )
  )


--- BERNHARD Nora <nora.bernhard@xxxxxxxxxxxxxxxx>
wrote:

> Hello all,
> 
> I just set up a new database on a 2-node 10g RAC.
> There are already some other databases installed and
> running, with working failover. For the new db the
> TAF does not work. As far as I understand (newbie :(
> ), the following entries in tnsnames.ora should
> suffice:
> 
> GWIT =
>   (DESCRIPTION =
>     (ADDRESS = (PROTOCOL = TCP)(HOST =
> o1.stgkk.sozvers.at)(PORT = 1521))
>     (ADDRESS = (PROTOCOL = TCP)(HOST =
> o2.stgkk.sozvers.at)(PORT = 1521))
>     (LOAD_BALANCE = yes)
>     (CONNECT_DATA =
>       (SERVER = DEDICATED)
>       (SERVICE_NAME = gwit.stgkk.sozvers.at)
>       (FAILOVER_MODE =
>         (TYPE = SELECT)
>         (METHOD = BASIC)
>         (RETRIES = 180)
>         (DELAY = 5)
>       )
>     )
>   )
> 
> GWIT1 =
>   (DESCRIPTION =
>     (ADDRESS = (PROTOCOL = TCP)(HOST =
> o1.stgkk.sozvers.at)(PORT = 1521))
>     (CONNECT_DATA =
>       (SERVER = DEDICATED)
>       (SERVICE_NAME = gwit.stgkk.sozvers.at)
>       (INSTANCE_NAME = gwit1)
>     )
>   )
> 
> GWIT2 =
>   (DESCRIPTION =
>     (ADDRESS = (PROTOCOL = TCP)(HOST =
> o2.stgkk.sozvers.at)(PORT = 1521))
>     (CONNECT_DATA =
>       (SERVER = DEDICATED)
>       (SERVICE_NAME = gwit.stgkk.sozvers.at)
>       (INSTANCE_NAME = gwit2)
>     )
>   )
> 
> LISTENERS_GWIT =
>   (ADDRESS_LIST =
>     (ADDRESS = (PROTOCOL = TCP)(HOST =
> o1.stgkk.sozvers.at)(PORT = 1521))
>     (ADDRESS = (PROTOCOL = TCP)(HOST =
> o2.stgkk.sozvers.at)(PORT = 1521))
>   )
> 
> My testing procedure (instructions from an Oracle
> support employee) is as follows: I open two separate
> sqlplus sessions to the same instance, in either of
> them I execute a long select, followed by a shutdown
> abort in the other session. The expected result is
> the select to continue running and finish gracefully
> on the second instance - but instead I receive
> "ORA-03113: end-of-file on communication channel".
> 
> What am I missing? Any hints highly appreciated!
> 
> Thanks,
> 
> Steiermärkische Gebietskrankenkasse
> A-8011 Graz, Josef-Pongratz-Platz 1,
> http://www.stgkk.at
> 
> Nora Bernhard
> OE Informationstechnologie - Systemadministration
> Tel: +43 (0) 316 8035 - 1349
> Fax: +43 (0) 316 8035 - 661349
> mailto:nora.bernhard@xxxxxxxxxxxxxxxx
> 
> --
> http://www.freelists.org/webpage/oracle-l
> 



                
__________________________________________________________
How much free photo storage do you get? Store your friends 'n family snaps for 
FREE with Yahoo! Photos http://in.photos.yahoo.com
--
http://www.freelists.org/webpage/oracle-l

Other related posts: