RAC & PCP testing

From: Raj <yoursraju007@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Mon, 15 Aug 2005 17:29:05 -0400

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
--
//www.freelists.org/webpage/oracle-l

RAC & PCP testing

Other related posts: