6 Replies Latest reply: Jun 16, 2011 3:49 AM by orafad RSS

    dgmgrl  Error: ORA-16664: unable to receive the result from a database

    778791
      PRIMARY=QA112PRG
      STANDBY=QA112STB
      configuring databse with dgmgrl

      DGMGRL> show configuration

      Configuration - PRIMARY

      Protection Mode: MaxPerformance
      Databases:
      QA112PRG - Primary database
      QA112STB - Physical standby database

      Fast-Start Failover: DISABLED

      Configuration Status:
      DISABLED

      DGMGRL> enable configuration
      Enabled.

      DGMGRL> show configuration

      Configuration - PRIMARY

      Protection Mode: MaxPerformance
      Databases:
      QA112PRG - Primary database
      QA112STB - Physical standby database
      Error: ORA-16664: unable to receive the result from a database

      Fast-Start Failover: DISABLED

      Configuration Status:
      ERROR
      DGMGRL> show database verbose 'QA112PRG';

      Database - QA112PRG

      Role: PRIMARY
      Intended State: TRANSPORT-ON
      Instance(s):
      QA112PRG

      Properties:
      DGConnectIdentifier = 'QA112PRG'
      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 = 'MANUAL'
      ArchiveLagTarget = '0'
      LogArchiveMaxProcesses = '4'
      LogArchiveMinSucceedDest = '1'
      DbFileNameConvert = ''
      LogFileNameConvert = ''
      FastStartFailoverTarget = ''
      StatusReport = '(monitor)'
      InconsistentProperties = '(monitor)'
      InconsistentLogXptProps = '(monitor)'
      SendQEntries = '(monitor)'
      LogXptStatus = '(monitor)'
      RecvQEntries = '(monitor)'
      HostName = 'pun-lpar-btk01.bmc.com'
      SidName = 'QA112PRG'
      StaticConnectIdentifier = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=pun-lpar-btk01.bmc.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=QA112PRG_DGMGRL)(INSTANCE_NAME=QA112PRG)(SERVER=DEDICATED)))'
      StandbyArchiveLocation = '/qa/data/obt/QA112PRG/admin/arch/'
      AlternateLocation = ''
      LogArchiveTrace = '0'
      LogArchiveFormat = '%t_%s_%r.log'
      TopWaitEvents = '(monitor)'

      Database Status:
      SUCCESS

      DGMGRL> show database verbose 'QA112STB';

      Database - QA112STB

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

      Properties:
      DGConnectIdentifier = 'QA112STB'
      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 = '4'
      LogArchiveMinSucceedDest = '1'
      DbFileNameConvert = '/qa/data/obt/QA112PRG/data, /qa/data/obt/QA112PRG/data'
      LogFileNameConvert = '/qa/data/obt/QA112PRG/data, /qa/data/obt/QA112PRG/data'
      FastStartFailoverTarget = ''
      StatusReport = '(monitor)'
      InconsistentProperties = '(monitor)'
      InconsistentLogXptProps = '(monitor)'
      SendQEntries = '(monitor)'
      LogXptStatus = '(monitor)'
      RecvQEntries = '(monitor)'
      HostName = 'pun-btk-aix02.bmc.com'
      SidName = 'QA112STB'
      StaticConnectIdentifier = 'QA112STB'
      StandbyArchiveLocation = '/qa/data/obt/QA112PRG/data/archive'
      AlternateLocation = ''
      LogArchiveTrace = '0'
      LogArchiveFormat = '%t_%s_%r.log'
      TopWaitEvents = '(monitor)'

      Database Status:
      DGM-17016: failed to retrieve status for database "QA112STB"
      ORA-16664: unable to receive the result from a database


      why these error commming that i dont get?
        • 1. Re: dgmgrl  Error: ORA-16664: unable to receive the result from a database
          CKPT
          Database Status:
          DGM-17016: failed to retrieve status for database "QA112STB"
          ORA-16664: unable to receive the result from a database
          What is your broker log file shows, check and post.

          Oracle Error :: ORA-16664
          unable to receive the result from a database

          Cause
          During execution of a command, a database in the Data Guard broker configuration failed to return a result.

          Action
          Check Data Guard broker logs for the details of the failure. Ensure network communication is working properly amongst the members of the configuration. Fix any possible network problems and reissue the command.
          • 2. Re: dgmgrl  Error: ORA-16664: unable to receive the result from a database
            778791
            drcQA112PRG.log
            2011-06-10 12:04:04.438 Additional information: 3
            2011-06-10 12:04:04.438 DMON: unable to get FSFO data from "/oracle/11.2.0/product/dbs/dr1QA112PRG.dat"
            2011-06-10 12:04:04.438 status = ORA-16572
            2011-06-10 12:04:04.461 DMON: rfafoGetLocks reinitializing dubious PMYSHUT lock value block contents: flags=0x0, spare1=0x0, spare2=0x0,
            cksm=0x0, rndm=0x0
            2011-06-10 12:04:04.482 DMON: Entered rfm_get_chief_lock() for CTL_BOOTSTRAP, reason 2
            2011-06-10 12:04:04.497 7fffffff 0 DMON: chief lock convert for bootstrap
            2011-06-10 12:04:04.498 DMON: cannot open configuration file "/oracle/11.2.0/product/dbs/dr1QA112PRG.dat", retrying
            "drcQA112PRG.log" 51191 lines, 5433117 characters
            2011-06-16 12:31:43.306 02010000 11710 DMON: MON_PROPERTY forwarded to site QA112STB for processing
            2011-06-16 12:32:13.277 NSV1: Site QA112STB returned ORA-16664.
            2011-06-16 12:32:13.278 00000000 11709 DMON: Database QA112STB returned ORA-16664
            2011-06-16 12:32:13.278 00000000 11709 for opcode = HEALTH_CHECK, phase = BEGIN, req_id = 1.1.11709
            2011-06-16 12:32:13.279 NSV1: Site QA112STB returned ORA-16664.
            2011-06-16 12:32:13.279 02010000 11710 DMON: Database QA112STB returned ORA-16664
            2011-06-16 12:32:13.279 02010000 11710 for opcode = MON_PROPERTY, phase = NULL, req_id = 1.1.11710
            2011-06-16 12:32:13.280 02010000 11710 DMON: MON_PROPERTY operation completed
            2011-06-16 12:32:13.294 02010000 11711 DMON: GET_RES: success. (len = 9980)
            2011-06-16 12:32:13.310 02010000 11711 DMON: GET_RES operation completed
            2011-06-16 12:33:43.272 NSV1: Site QA112STB returned ORA-16664.
            2011-06-16 12:33:43.273 00000000 11712 DMON: Database QA112STB returned ORA-16664
            2011-06-16 12:33:43.273 00000000 11712 for opcode = HEALTH_CHECK, phase = BEGIN, req_id = 1.1.11712
            2011-06-16 12:34:58.280 NSV1: Site QA112STB returned ORA-16664.
            2011-06-16 12:34:58.281 00000000 11713 DMON: Database QA112STB returned ORA-16664
            2011-06-16 12:34:58.282 00000000 11713 for opcode = HEALTH_CHECK, phase = BEGIN, req_id = 1.1.11713
            2011-06-16 12:36:13.279 NSV1: Site QA112STB returned ORA-16664.
            2011-06-16 12:36:13.280 00000000 11714 DMON: Database QA112STB returned ORA-16664
            2011-06-16 12:36:13.280 00000000 11714 for opcode = HEALTH_CHECK, phase = BEGIN, req_id = 1.1.11714
            2011-06-16 12:37:43.273 NSV1: Site QA112STB returned ORA-16664.
            2011-06-16 12:37:43.274 00000000 11715 DMON: Database QA112STB returned ORA-16664
            2011-06-16 12:37:43.274 00000000 11715 for opcode = HEALTH_CHECK, phase = BEGIN, req_id = 1.1.11715
            • 3. Re: dgmgrl  Error: ORA-16664: unable to receive the result from a database
              CKPT
              2011-06-10 12:04:04.438 DMON: unable to get FSFO data from "/oracle/11.2.0/product/dbs/dr1QA112PRG.dat"
              Have you performed any switchover recently? Then is it get failed?

              If so You can remove and add the configuration.
              DMON: cannot open configuration file
              Is your listener is running? and also check is confiruration file exist ?

              $ls -ltr /oracle/11.2.0/product/dbs/dr1QA112PRG.dat

              Edited by: CKPT on Jun 16, 2011 12:48 PM
              • 4. Re: dgmgrl  Error: ORA-16664: unable to receive the result from a database
                778791
                No I have not done switchover.
                yes my listener is runng.
                file /oracle/11.2.0/product/dbs/dr1QA112PRG.dat also exist.
                i have removed the configuration and again created beacuse of same problem .
                • 6. Re: dgmgrl  Error: ORA-16664: unable to receive the result from a database
                  orafad
                  There's a dedicated forum for DG - {forum:id=849}