Communication Issues ORA-16525 and ORA-12545 After Succesful STANDBY Creation by EM (Doc ID 964252.1)

Last updated on APRIL 18, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 10-Dec-2015***

Symptoms

On : 10.2.0.4 version, Oracle Data Guard with Broker.

The data guard configuration is created successfully using enterprise manager (Grid Control) but when attempting to check the health of the configuration using show configuration it fails. The following error occurs.

ERROR
-----------------------
DGMGRL> connect sys@prjmpsb
Password:
Connected.
DGMGRL> show configuration verbose

Configuration
Name: PRJMP
Enabled: YES
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:
PRJMP - Primary database
PRJMPSB - Physical standby database

Current status for "PRJMP":
Error: ORA-16625: cannot reach the database


DGMGRL> show database verbose "PRJMPSB"

Database
Name: PRJMPSB
Role: PHYSICAL STANDBY
Enabled: YES
Intended State: ONLINE
Instance(s):
PRJMPSB

Properties:
InitialConnectIdentifier = '(DESCRIPTION=(ADDRESS_LIST =
(ADDRESS=(PROTOCOL=tcp)(HOST=oempr.cc.wmich.edu)(PORT=1521)))(CONNECT_DATA=(SID=PRJMPSB)(SERVER=DEDI
CATED)))'
ObserverConnectIdentifier = ''
LogXptMode = 'ASYNC'
Dependency = ''
DelayMins = '0'
Binding = 'OPTIONAL'
MaxFailure = '0'
MaxConnections = '1'
ReopenSecs = '300'
NetTimeout = '180'
LogShipping = 'ON'
PreferredApplyInstance = ''
ApplyInstanceTimeout = '0'
ApplyParallel = 'AUTO'
StandbyFileManagement = 'auto'
ArchiveLagTarget = '1800'
LogArchiveMaxProcesses = '2'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = ''
LogFileNameConvert = ''
FastStartFailoverTarget = ''
StatusReport = '(monitor)'
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
HostName = 'oempr'
SidName = 'PRJMPSB'
LocalListenerAddress = '(ADDRESS=(PROTOCOL=tcp)(HOST=oempr)(PORT=1521))'
StandbyArchiveLocation = '/u05/oradata/PRJMP/archive'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = 'PRJMP_%t_%s_%r.arc'
LatestLog = '(monitor)'
TopWaitEvents = '(monitor)'

Current status for "PRJMPSB":
Error: ORA-16625: cannot reach the database



DMON logs shows ora-12545 error.

TNSping and remote SQLPLUS connections work as expected.

Though the logs are shipping and applied fine cannot verify the health of the data guard configuration via grid or DGMGRL.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms