Here it is...
DGMGRL> show configuration;
Configuration - test_config
Protection Mode: MaxPerformance
Databases:
test_p - Primary database
test_s - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL>
DGMGRL> show database verbose test_p;
Database - test_p
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
test
Properties:
DGConnectIdentifier = 'test_p'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
DelayMins = '0'
Binding = 'optional'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '5'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = ''
LogFileNameConvert = '/oracle/test/origlogA/,
/oracle/test/origlogA/, /oracle/test/origlogB/, /oracle/test/origlogB/,
/oracle/test/standbylog, /oracle/test/standbylog'
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
ApplyLagThreshold = '0'
TransportLagThreshold = '0'
TransportDisconnectedThreshold = '30'
SidName = 'test'
StaticConnectIdentifier = 'test_P'
StandbyArchiveLocation = '/oracle/test/oraarch/testarch'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
TopWaitEvents = '(monitor)'
Database Status:
SUCCESS
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show database verbose test_s;
Database - test_s
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Apply Rate: 78.00 KByte/s
Real Time Query: OFF
Instance(s):
test
Properties:
DGConnectIdentifier = 'test_s'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
DelayMins = '0'
Binding = 'OPTIONAL'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '30'
RedoCompression = 'DISABLE'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'AUTO'
ArchiveLagTarget = '0'
LogArchiveMaxProcesses = '5'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = ''
LogFileNameConvert = '/oracle/test/origlogA/,
/oracle/test/origlogA/, /oracle/test/origlogB/, /oracle/test/origlogB/,
/oracle/test/standbylog, /oracle/test/standbylog'
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
ApplyLagThreshold = '0'
TransportLagThreshold = '0'
TransportDisconnectedThreshold = '30'
SidName = 'test'
StaticConnectIdentifier = 'test_S'
StandbyArchiveLocation = '/oracle/test/oraarch/testarch'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = '%t_%s_%r.dbf'
TopWaitEvents = '(monitor)'
Database Status:
SUCCESS
DGMGRL> exit
standby:/oracle/test>
standby:/oracle/test>
standby:/oracle/test>
standby:/oracle/test>
standby:/oracle/test> tnsping test_s
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 12-FEB-2016
03:32:18
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
/oracle/test/11204/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY
= TEST.WORLD) (PROTOCOL = TCP) (HOST = standby) (PORT =1545)))
(CONNECT_DATA = (SID = test) (GLOBAL_NAME = test) (SERVICE_NAME= test_S)))
OK (0 msec)
standby:/oracle/test>
standby:/oracle/test> tnsping test_p
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 12-FEB-2016
03:32:20
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
/oracle/test/11204/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY
= TEST.WORLD) (PROTOCOL = TCP) (HOST = primary) (PORT =1545)))
(CONNECT_DATA = (SID = test) (GLOBAL_NAME = test) (SERVICE_NAME = test_P)))
OK (10 msec)
standby:/oracle/test>
On Thu, Feb 11, 2016 at 10:20 AM, abu fazal md abbas <abbas.appsdba@xxxxxxxx
wrote:
Hi,
It seems to be an issue with connection timeout settings.
Could you provide the output of the following
dgmgrl> show database verbose test_p
dgmgrl> show database verbose test_s
and then from both primary and standby servers
$ tnsping test_p
$ tnsping test_s
*Thanks and Regards,*
Abbas
*Abu Fazal Mohammed Abbas*
Website: www.oraclebuffer.com
------------------------------
*From:* max scalf <oracle.blog3@xxxxxxxxx>
*To:* Oracle Mailing List <oracle-l@xxxxxxxxxxxxx>
*Sent:* Thursday, 11 February 2016 8:49 PM
*Subject:* Re: DataGuard Failover Test issues
quick update to that, after about 20 mins of hanging i got below error
from show config...
Configuration Status:
ORA-16662: network timeout when contacting a database
DGM-17017: unable to determine configuration status
DGMGRL>
On Thu, Feb 11, 2016 at 9:18 AM, max scalf <oracle.blog3@xxxxxxxxx> wrote:
hello list,
We are in process of testing failover for our 11.2.0.4 data guard
environement. While under normal circumstance when we ran show
configuration for data guard broker we get success message as shown below
DGMGRL> show configuration verbose;
Configuration - test_config
Protection Mode: MaxPerformance
Databases:
test_p - Primary database
test_s - Physical standby database
Properties:
FastStartFailoverThreshold = '30'
OperationTimeout = '30'
FastStartFailoverLagLimit = '30'
CommunicationTimeout = '180'
ObserverReconnect = '0'
FastStartFailoverAutoReinstate = 'TRUE'
FastStartFailoverPmyShutdown = 'TRUE'
BystandersFollowRoleChange = 'ALL'
ObserverOverride = 'FALSE'
ExternalDestination1 = ''
ExternalDestination2 = ''
PrimaryLostWriteAction = 'CONTINUE'
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL>
now when we literally go power off our primary host(test_p) and come over
to standby host(test_p) we do show configuration it just hangs as shown
below, I waited a good 20 mins but no luck
DGMGRL> connect sys/XXXXXX;
Connected.
DGMGRL> show configuration verbose;
i do see message in alert log as show below, once we shutdown primary...
and when i issue show config in data guard broker, no errors in drcTEST.log
file either...
Fri Feb 12 02:13:00 2016
RFS[5]: Possible network disconnect with primary database
Fri Feb 12 02:13:00 2016
RFS[6]: Assigned to RFS process 3786
RFS[6]: Possible network disconnect with primary database
Fri Feb 12 02:13:00 2016
RFS[4]: Possible network disconnect with primary database
Fri Feb 12 02:13:00 2016
RFS[2]: Possible network disconnect with primary database
Fri Feb 12 02:14:32 2016
has anybody seem something similar ?? What am i doing wrong? I have
tested switchover 10's of time successfully but when it comes to failover
the show config part hangs....