Re: TAF

From: arun chakrapani rao <arunrao_oradba_at_yahoo.co.in>
Date: Thu, 14 Jul 2005 15:18:17 +0100 (BST)
Message-ID: <20050714141817.52805.qmail@web8505.mail.in.yahoo.com>

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_at_STGKK.sozvers.at> 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_at_stgkk.sozvers.at
> 
> --
> 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

Received on Thu Jul 14 2005 - 09:20:15 CDT