RE: Oracle 11R2g data guard client connectivity
- From: Joseph David Paparo <jpaparo@xxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 7 Feb 2013 19:14:02 +0000
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Joseph David Paparo
Sent: Thursday, February 07, 2013 11:58 AM
To: oracle-l@xxxxxxxxxxxxx
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@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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
