Re: TAF
- From: arun chakrapani rao <arunrao_oradba@xxxxxxxxxxx>
- To: nora.bernhard@xxxxxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 14 Jul 2005 15:18:17 +0100 (BST)
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
>
> --
> //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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
