4 Replies Latest reply: Jun 7, 2012 12:51 AM by Mahir M. Quluzade 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
          mseberg
          Is it possible your hostname is not set up? If its not on the hosts file is one cause of this error.

          Also check the listener and tnsnames files and ensure that there is no connection problem between the Primary and the Standby.

          Use tnsping and try to connect from SQL Plus on each server to the other database (The standby will bark).

          make sure you have _DGMGRL in your listener file

          Ex

          http://www.visi.com/~mseberg/Data_Guard_Listener_Example.html

          Best Regards

          mseberg

          I noticed later you have this set :
          StandbyFileManagement = 'MANUAL
          But its set to AUTO on the other, I would consider setting them both to AUTO.

          Also your DbFileNameConvert and LogFileNameConvert parameters are set on one but not set on the other, Based on this
          I would strongly consider comparing the INIT's.

          I have had great luck creating my standby from my primary INIT and only changing these parameters on the standby :


          FAL_SERVER

          FAL_CLIENT

          STANDBY_FILE_MANAGEMENT

          DB_UNIQUE_NAME

          DB_FILE_NAME_CONVERT

          LOG_FILE_NAME_CONVERT

          log_archive_dest_1'

          log_archive_dest_2

          LOG_ARCHIVE_DEST_STATE_1

          LOG_ARCHIVE_DEST_STATE_2

          LOG_ARCHIVE_MAX_PROCESSES



          Edited by: mseberg on Jun 16, 2011 5:34 AM
          • 2. Re: dgmgrl Error: ORA-16664: unable to receive the result from a database
            BPeaslandDBA
            Can you sign on to the Standby as SYS and issue queries against some V$ views? Do you get errors?

            Cheers,
            Brian
            • 3. Re: dgmgrl Error: ORA-16664: unable to receive the result from a database
              JohnM
              I think the issue is that from the standby you cannot connect to the primary. Please logon to the standby server and try and connect to the primary via sql*net. Likely you will get an error, which is why you are seeing this in DG broker.
              • 4. Re: dgmgrl Error: ORA-16664: unable to receive the result from a database
                Mahir M. Quluzade
                HI,

                Can you try following senario and pste here results:

                1. Add tnsnames.ora QA112PRG, QA112STB on both server (primary and standby).
                2. If you are writing QA112PRG, QA112STB desriptions with hostname you can add servernames and ips to */etc/hosts* file.
                3. Try on both server : tnsping QA112PRG; tnsping QA112STB
                4. Set StandbyFileManagement parameter set 'AUTO' , this help datafile management automatically .
                5. Watch my video : http://www.mahir-quluzade.com/2012/01/overview-data-guard-configuration.html
                (http://www.youtube.com/watch?feature=player_embedded&v=5keahpkzLtM)

                Regards
                Mahir M. Quluzade.
                www.mahir-quluzade.com