RAC & PCP testing

From: Raj <yoursraju007_at_gmail.com>
Date: Mon, 15 Aug 2005 17:29:05 -0400
Message-ID: <7f411f4e05081514296c9c9cbf@mail.gmail.com>

All-

RAC testing:

Client tnsnames.ora:

ABCD =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DBA01)(PORT = 1531))
(ADDRESS = (PROTOCOL = TCP)(HOST = DBA02)(PORT = 1531))
(LOAD_BALANCE = yes)
(CONNECT_DATA =

      (SERVER = DEDICATED)
      (SERVICE_NAME = ABCD)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )

    )
  )

Here connect time failover does not work , if the first listener is down. More elaboration:

1. When the calls goes a listener which is DOWN, it should connect to the other instance... but this is not connecting.. its trying again and again the same listener.... can any1 share any experience with the same. Some kind of routing cache???
2. If the first call goes to the working listener, it works fine and does not bother about the other listener.

Secondly, on PCP testing: Failover worked successfully... But failback does not happen when the nodes comes back up... Is this expected behaviour ? Does oracle support failback for PCP ??

Thanks

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

Received on Mon Aug 15 2005 - 17:29:35 CDT