RE: TAF

From: Khemmanivanh, Somckit <somckit.khemmanivanh_at_weyerhaeuser.com>
Date: Thu, 14 Jul 2005 02:14:02 -0700
Message-ID: <65C0D8935651CB4D96E97CEFAC5A12B944488C@wafedixm10.corp.weyer.pri>

Hmm, I don't see a FAILOVER = yes entry in your GWIT entry -- I have a 10g 2 node RAC cluster also. My test works for me -- that is sess1 sqlplus select, and shutdown abort the instance from sess 2. Sess 1 fails over to the surviving instance and finishes the select statement from where it left off...

Did you happen to verify how you were connected before perfoming the shutdown abort?

I used a slightly modded Jeff Hunter script to do this:

COLUMN instance_name FORMAT a13
COLUMN host_name FORMAT a9
COLUMN failover_method FORMAT a15
COLUMN failed_over FORMAT a11

SELECT
    instance_name

  , host_name
  , NULL AS failover_type
  , NULL AS failover_method
  , NULL AS failed_over

FROM v$instance
UNION
SELECT
    NULL

  , NULL
  , failover_type
  , failover_method
  , failed_over

FROM v$session;

Thanks!
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of BERNHARD Nora Sent: Wednesday, July 13, 2005 11:37 PM
To: oracle-l_at_freelists.org
Subject: 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_at_stgkk.sozvers.at

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jul 14 2005 - 04:16:26 CDT