sessions not switching to new standby after switchover (data guard)
Date: Thu, 9 May 2013 19:49:05 +0000
Message-ID: <46852E87A7561E489DF15753ECB0B6D80A95B15D_at_SSVMEXDAG01MB02.tufts.ad.tufts.edu>
Oracle 11.2.0.3 on rhel 6.
Set up: primary is db1. Standby is db2.
Switchover to standby (db2) works, but active sessions don't move to the new primary (db2) until the new STANDBY (db1) is open. All new sessions get 'db in initilzation state' and can't login. We want the standbys to be in mounted state because we are not licensed for Active Data Guard.
tnsnames.ora entry:
ADVSTG.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = advdb-stage-01.uit.tufts.edu)(PORT = 11003)) (ADDRESS = (PROTOCOL = TCP)(HOST = advdb-stage-02.uit.tufts.edu)(PORT = 11003)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = SVC_ADVSTG) (FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
Users use ADVSTG as the connect string.
The switch going the other way works, (switchover to db1) i.e., the user sessions get moved correctly.
We also have a trigger that gets run on db startup which stops the svc_advstg service for the standby and starts it for the primary. This is so that new sessions get pointed to the new primary.
Hope that is clear.
Thanks for any help.
Joe
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 09 2013 - 21:49:05 CEST