RE: Oracle 11R2g data guard client connectivity

From: Joseph David Paparo <jpaparo_at_uark.edu>
Date: Thu, 7 Feb 2013 19:14:02 +0000
Message-ID: <5AB9968CF54E564E92EBD0C3F4FACCEA3F7AC8B6_at_ex-mbx1b.uark.edu>

Disregard. I figured it out. It would help if I entered the same service name on tnsnames.ora file...LOL

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Joseph David Paparo Sent: Thursday, February 07, 2013 11:58 AM To: oracle-l_at_freelists.org
Subject: Oracle 11R2g data guard client connectivity

Hello,

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.

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

      (SERVICE_NAME = DB)
      (failover_mode=(type=select)(method=basic))

    )
   )

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
Edition:
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.

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


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

Received on Thu Feb 07 2013 - 20:14:02 CET