1 Reply Latest reply: Feb 17, 2013 11:51 PM by CKPT RSS

    DG Broker -  Error is ORA-12521    11gR2 RAC

    user10922685
      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
          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.