This discussion is archived
1 Reply Latest reply: Feb 17, 2013 9:51 PM by CKPT RSS

DG Broker -  Error is ORA-12521    11gR2 RAC

user10922685 Newbie
Currently Being Moderated
Hi ,

I have setup DG broker for 11gR2 RAC - Primary and DR (standby) - Grid single node ( non- Rac) . It is R12 apps.
I am getting connection errors from standby to production . Although the there is no problem in arciive log shipping and DG broker setup .
But I m getting constant Error ORA-16664 ( On Primary ) and on standby - Failed to connect to remote database prod1. Error is ORA-12521

Pls advise what is missing . I have recreated password file ,but no luck.

Primary : drcprod11.log
Site prod1dg returned ORA-16664.
Site prod1dg returned ORA-16664.
Data Guard Broker Status Summary:
Type Name Severity Status
Configuration prod1_CONFIG Warning ORA-16607
Primary Database prod1 Success ORA-00000
Physical Standby Database prod1dg Error ORA-16664


Standby - drcprod1.log

Failed to send message to site prod1. Error code is ORA-12521.
02/18/2013 00:01:34
Failed to connect to remote database prod1. Error is ORA-12521
Failed to send message to site pcap1. Error code is ORA-12521.
02/18/2013 00:04:04
Failed to connect to remote database prod1. Error is ORA-12521
Failed to send message to site pcap1. Error code is ORA-12521.
02/18/2013 00:06:19
Failed to connect to remote database prod1. Error is ORA-12521
Failed to send message to site pcap1. Error code is ORA-12521.




DGMGRL> show configuration

Configuration - prod1_CONFIG

Protection Mode: MaxPerformance
Databases:
prod1 - Primary database
prod1dg - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

DGMGRL> show instance prod1 verbose on database prod1
Instance "prod1" was not found
DGMGRL> show instance prod11 verbose on database prod1
Error: ORA-16606: unable to find property "verbose"

DGMGRL> show instance verbose prod11 on database prod1

Instance 'prod11' of database 'prod1'

Host Name: u01prod1
PFILE:
Properties:
SidName = 'prod11'
StaticConnectIdentifier = 'prod11_local'
StandbyArchiveLocation = '/u01/arch/prod1'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = 'prod1_%t_%s_%r.arch'
TopWaitEvents = '(monitor)'

Instance Status:
SUCCESS

DGMGRL> show instance verbose prod12 on database prod1

Instance 'prod12' of database 'prod1'

Host Name: u01prod2
PFILE:
Properties:
SidName = 'prod12'
StaticConnectIdentifier = 'prod12_local'
StandbyArchiveLocation = '/u01/arch/prod1'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = 'prod1_%t_%s_%r.arch'
TopWaitEvents = '(monitor)'

Instance Status:
SUCCESS

DGMGRL> show database verbose prod1dg

Database - prod1dg

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds
Apply Lag: 0 seconds
Real Time Query: OFF
Instance(s):
prod1

Properties:
DGConnectIdentifier = 'prod1dg'
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 = '8'
LogArchiveMinSucceedDest = '1'
DbFileNameConvert = ''
LogFileNameConvert = ''
FastStartFailoverTarget = ''
InconsistentProperties = '(monitor)'
InconsistentLogXptProps = '(monitor)'
SendQEntries = '(monitor)'
LogXptStatus = '(monitor)'
RecvQEntries = '(monitor)'
SidName = 'prod1'
StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=pres1.com)(PORT=1533))(CONNECT_DATA=(SERVICE_NAME=prod1dg_DGMGRL)(INSTANCE_NAME=prod1)(SERVER=DEDICATED)))'
StandbyArchiveLocation = '/u01prod/arch/prod1'
AlternateLocation = ''
LogArchiveTrace = '0'
LogArchiveFormat = 'prod1_%t_%s_%r.arch'
TopWaitEvents = '(monitor)'

Database Status:
DGM-17016: failed to retrieve status for database "prod1dg"
ORA-16664: unable to receive the result from a database
  • 1. Re: DG Broker -  Error is ORA-12521    11gR2 RAC
    CKPT Guru
    Currently Being Moderated
    I have setup DG broker for 11gR2 RAC - Primary and DR (standby) - Grid single node ( non- Rac) . It is R12 apps.
    I am getting connection errors from standby to production . Although the there is no problem in arciive log shipping and DG broker setup .
    But I m getting constant Error ORA-16664 ( On Primary ) and on standby - Failed to connect to remote database prod1. Error is ORA-12521
    Failed to connect to remote database prod1. Error is ORA-12521
    Failed to send message to site pcap1. Error code is ORA-12521.
    It is not an issue with either password file, It having issues to establish connections with "prod1" ,
    Have you configured static listener entry?
    And What local_listener value you have set ?

    From all instances
    $lsnrctl status
    12521, 00000, "TNS:listener does not currently know of instance requested in connect descriptor"
    // *Cause:  The listener received a request to establish a connection to a
    // database or other service. The connect descriptor received by the listener
    // specified in addition to the service name an instance name for an instance
    // (usually a database instance) that either has not yet dynamically registered
    // with the listener or has not been statically configured for the listener.
    // This may be a temporary condition such as after the listener has started,
    // but before the database instance has registered with the listener.
    // *Action:
    //  - Wait a moment and try to connect a second time.
    //  - Check which instances are currently known by the listener by executing:
    //    lsnrctl services <listener name>
    //  - Check that the INSTANCE_NAME parameter in the connect descriptor specifies
    //    an instance name known by the listener.
    //  - Check for an event in the listener.log file.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points