sessions not switching to new standby after switchover (data guard)
- From: "Armstrong-Champ, Joseph William" <Joseph.Armstrong-Champ@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 9 May 2013 19:49:05 +0000
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
