Oracle 11R2g data guard client connectivity

From: Joseph David Paparo <>
Date: Thu, 7 Feb 2013 17:57:45 +0000
Message-ID: <>


I am having an issue where the client session is not being transferred to the new primary database. I did a switchover from my primary database to my physical standby database and I was hoping that the client session would transfer over. One thing to note is that my primary is a 2 RAC node and my physical standby is a standalone.

I have added the following entry in the tnsnames.ora file on both the primary host and standby.

(ADDRESS = (PROTOCOL = TCP)(HOST = db-prim)(PORT = ###5))
(ADDRESS = (PROTOCOL = TCP)(HOST = db-phys)(PORT = ###6))


I have created this service using srvctl.

Service name: DGTEST
Service is enabled
Server pool: DGTEST
Cardinality: 1
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Failover type: SELECT
Failover method: BASIC
TAF failover retries: 180
TAF failover delay: 1
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: NONE
Preferred instances: DBPRIM
Available instances:

I am able to connect using sqlplus b/b_at_DGTEST before the switchover but after the switchover, I get the following message.

ORA-01033: ORACLE initialization or shutdown in progress Process ID: 0 Session ID: 0 Serial number: 0

It seems that it is still trying to connect to the old primary which is now a standby. Any help would be appreciated. Thanks.

Received on Thu Feb 07 2013 - 18:57:45 CET

Original text of this message