6 Replies Latest reply: Feb 22, 2014 10:48 AM by user12092599 RSS

    DGM-17016: failed to retrieve status for database "STAND"

    user12092599

      Hello experts,

       

      I've been fighting with this for a long time but I cannot find a solution. Could someone help me on this please?

       

      The logs are being applied fine. The problem came when I tried to configure the broker

      I've recreate the broker configuration several times.

      The firewall is down

       

      I can connect to the databases by doing:

       

      sqlplus sys@nicolasdb as sysdba

      sqlplus sys@stand as sysdba

       

      I'm getting these errors continuously:

       

      Primary broker log

       

      NSV1: Site STAND returned ORA-16664.

      DMON: Database STAND returned ORA-16664

      for opcode = HEALTH_CHECK, phase = BEGIN, req_id = 1.1.2128399198

       

       

      Standby broker log

       

      ERROR: Connect Identifier nicolas1 not valid

      NSV0: Can't get db instance specific connect descriptor to database NICOLAS1 (error=16501)

      NSV0: Failed to connect to 0x01001001

      NSV0: Failed to send message to site NICOLAS1. Error code is ORA-16501.

      DMON: Database NICOLAS1 returned ORA-16501

      for opcode = HEALTH_CHECK, phase = BEGIN, req_id = 1.1.2128399193

       

      The config is:

       

      DGMGRL> show database verbose "NICOLAS1"

       

      Database - NICOLAS1

       

        Role:            PRIMARY

        Intended State:  TRANSPORT-ON

        Instance(s):

          nicolas11G

       

        Properties:

          DGConnectIdentifier             = 'nicolas1'

          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               = '/oradata/stand, /oradata/nicolas11G'

          LogFileNameConvert              = '/oradata/stand, /oradata/nicolas11G'

          FastStartFailoverTarget         = ''

          StatusReport                    = '(monitor)'

          InconsistentProperties          = '(monitor)'

          InconsistentLogXptProps         = '(monitor)'

          SendQEntries                    = '(monitor)'

          LogXptStatus                    = '(monitor)'

          RecvQEntries                    = '(monitor)'

          HostName                        = 'nicolas'

          SidName                         = 'nicolas11G'

          StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=nicolas)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=nicolas1_DGMGRL)(INSTANCE_NAME=nicolas11G)(SERVER=DEDICATED)))'

          StandbyArchiveLocation          = '/u01/app/oracle/arch'

          AlternateLocation               = ''

          LogArchiveTrace                 = '0'

          LogArchiveFormat                = '%t_%s_%r.dbf'

          TopWaitEvents                   = '(monitor)'

       

      Database Status:

      SUCCESS

       

      DGMGRL> show database verbose "STAND"

       

      Database - STAND

       

        Role:            PHYSICAL STANDBY

        Intended State:  APPLY-ON

        Transport Lag:   (unknown)

        Apply Lag:       (unknown)

        Real Time Query: OFF

        Instance(s):

          stand

       

        Properties:

          DGConnectIdentifier             = 'stand'

          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               = '/oradata/nicolas11G, /oradata/stand'

          LogFileNameConvert              = '/oradata/nicolas11G, /oradata/stand'

          FastStartFailoverTarget         = ''

          StatusReport                    = '(monitor)'

          InconsistentProperties          = '(monitor)'

          InconsistentLogXptProps         = '(monitor)'

          SendQEntries                    = '(monitor)'

          LogXptStatus                    = '(monitor)'

          RecvQEntries                    = '(monitor)'

          HostName                        = 'nicolas2'

          SidName                         = 'stand'

          StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=nicolas2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=stand_DGMGRL)(INSTANCE_NAME=stand)(SERVER=DEDICATED)))'

          StandbyArchiveLocation          = '/u01/app/oracle/arch'

          AlternateLocation               = ''

          LogArchiveTrace                 = '0'

          LogArchiveFormat                = '%t_%s_%r.dbf'

          TopWaitEvents                   = '(monitor)'

       

      Database Status:

      DGM-17016: failed to retrieve status for database "STAND"

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

       

       

      Primary listener

       

      LISTENER_NICOLAS =

        (DESCRIPTION_LIST =

          (DESCRIPTION =

            (ADDRESS = (PROTOCOL = TCP)(HOST = nicolas.acme.com)(PORT = 1521))

          )

        )

       

      SID_LIST_LISTENER_NICOLAS=

         (SID_LIST=

             (SID_DESC=

                (GLOBAL_DBNAME=nicolas1)

                (SID_NAME=nicolas11G)

                (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)

          )

         (SID_DESC=

                (GLOBAL_DBNAME=nicolas1_DGMGRL)

                (SID_NAME=nicolas11G)

                (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)

          )

      )

       

      Primary tnsnames.ora

       

      NICOLASDB =

        (DESCRIPTION =

          (ADDRESS_LIST =

            (ADDRESS = (PROTOCOL = TCP)(HOST = nicolas.acme.com)(PORT = 1521))

          )

          (CONNECT_DATA =

            (SERVICE_NAME = nicolas1)

          )

        )

       

      STAND =

        (DESCRIPTION =

          (ADDRESS_LIST =

            (ADDRESS = (PROTOCOL = TCP)(HOST = nicolas2.acme.com)(PORT = 1521))

          )

          (CONNECT_DATA =

            (SERVICE_NAME = stand)

          )

        )

       

       

      Standby listener

       

      LISTENER2 =

        (DESCRIPTION_LIST =

          (DESCRIPTION =

            (ADDRESS = (PROTOCOL = TCP)(HOST = nicolas2.acme.com)(PORT = 1521))

          )

        )

       

      SID_LIST_LISTENER2=

         (SID_LIST=

             (SID_DESC=

                (GLOBAL_DBNAME=stand)

                (SID_NAME=stand)

                (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)

          )

         (SID_DESC=

                (GLOBAL_DBNAME=stand_DGMGRL)

                (SID_NAME=stand)

                (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)

          )

       

      Standby tnsnames.ora

       

      NICOLASDB =

        (DESCRIPTION =

          (ADDRESS_LIST =

            (ADDRESS = (PROTOCOL = TCP)(HOST = nicolas.acme.com)(PORT = 1521))

          )

          (CONNECT_DATA =

            (SERVICE_NAME = nicolas1)

          )

        )

       

      STAND =

        (DESCRIPTION =

          (ADDRESS_LIST =

            (ADDRESS = (PROTOCOL = TCP)(HOST = nicolas2.acme.com)(PORT = 1521))

          )

          (CONNECT_DATA =

            (SERVICE_NAME = stand)

       

       

       

      I don't know if you need more info.

       

      Thank you very much in advance