TAF

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

Other related posts: