在create configuration 的时候的报错! 警醒

  • 七_仔

    2015-06-12 17:10:25
  • Oracle
  • 原创

监听和tns全部畅通
ORA11GR2 是备库 
ENMOEDU 是主库

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

 
DGMGRL> show database verbose ORA11GR2

Database - ora11gr2

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

  Properties:
    DGConnectIdentifier             = 'ora11gr2'
    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               = 'ENMOEDU, ORA11GR2'
    LogFileNameConvert              = 'ENMOEDU, ORA11GR2'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName                         = 'ORA11GR2'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=enmo2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORA11GR2_DGMGRL)(INSTANCE_NAME=ORA11GR2)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/u01/app/oracle/fast_recovery_area/ORA11GR2'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.arc'
    TopWaitEvents                   = '(monitor)'

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

DGMGRL> EXIT
[oracle@enmo2 ~]$ dgmgrl
DGMGRL for Linux: Version 11.2.0.3.0 - Production

Copyright (c) 2000, 2009, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.
.
DGMGRL> connect sys/oracle@ORA11GR2
Connected.
DGMGRL> SHOW DATABASE VERBOSE ora11gr2

Database - ora11gr2

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

  Properties:
    DGConnectIdentifier             = 'ora11gr2'
    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               = 'ENMOEDU, ORA11GR2'
    LogFileNameConvert              = 'ENMOEDU, ORA11GR2'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName                         = 'ORA11GR2'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=enmo2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORA11GR2_DGMGRL)(INSTANCE_NAME=ORA11GR2)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/u01/app/oracle/fast_recovery_area/ORA11GR2'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.arc'
    TopWaitEvents                   = '(monitor)'

Database Status:
SUCCESS

DGMGRL> show configuration verbose;

Configuration - df

  Protection Mode: MaxPerformance
  Databases:
    enmoedu  - Primary database
    ora11gr2 - Physical standby database

  Properties:
    FastStartFailoverThreshold      = '30'
    OperationTimeout                = '30'
    FastStartFailoverLagLimit       = '30'
    CommunicationTimeout            = '180'
    FastStartFailoverAutoReinstate  = 'TRUE'
    FastStartFailoverPmyShutdown    = 'TRUE'
    BystandersFollowRoleChange      = 'ALL'

Fast-Start Failover: DISABLED

Configuration Status:
ORA-16642: DB_UNIQUE_NAME mismatch
ORA-16625: cannot reach database "enmoedu"
DGM-17017: unable to determine configuration status

DGMGRL> show database verbose ENMOEDU;

Database - enmoedu

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

  Properties:
    DGConnectIdentifier             = 'ora11gr2'
    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          = '1'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = 'ORA11GR2, ENMOEDU'
    LogFileNameConvert              = 'ORA11GR2, ENMOEDU'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName                         = 'ENMOEDU'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=enmo1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ENMOEDU_DGMGRL)(INSTANCE_NAME=ENMOEDU)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/u01/app/oracle/fast_recovery_area/ENMOEDU'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.arc'
    TopWaitEvents                   = '(monitor)'

Database Status:
DGM-17016: failed to retrieve status for database "enmoedu"
ORA-16642: DB_UNIQUE_NAME mismatch
ORA-16625: cannot reach database "enmoedu"

DGMGRL> SHOW DATABASE VERBOSE ora11gr2;

Database - ora11gr2

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

  Properties:
    DGConnectIdentifier             = 'ora11gr2'
    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               = 'ENMOEDU, ORA11GR2'
    LogFileNameConvert              = 'ENMOEDU, ORA11GR2'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName                         = 'ORA11GR2'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=enmo2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORA11GR2_DGMGRL)(INSTANCE_NAME=ORA11GR2)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/u01/app/oracle/fast_recovery_area/ORA11GR2'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.arc'
    TopWaitEvents                   = '(monitor)'

Database Status:
SUCCESS


DGMGRL> SHOW DATABASE VERBOSE ENMOEDU;

Database - enmoedu

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

  Properties:
    DGConnectIdentifier             = 'ora11gr2'
    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          = '1'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = 'ORA11GR2, ENMOEDU'
    LogFileNameConvert              = 'ORA11GR2, ENMOEDU'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName                         = 'ENMOEDU'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=enmo1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ENMOEDU_DGMGRL)(INSTANCE_NAME=ENMOEDU)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/u01/app/oracle/fast_recovery_area/ENMOEDU'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.arc'
    TopWaitEvents                   = '(monitor)'

Database Status:
SUCCESS

DGMGRL> SHOW DATABASE VERBOSE ora11gr2;

Database - ora11gr2

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

  Properties:
    DGConnectIdentifier             = 'ora11gr2'
    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               = 'ENMOEDU, ORA11GR2'
    LogFileNameConvert              = 'ENMOEDU, ORA11GR2'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName                         = 'ORA11GR2'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=enmo2)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORA11GR2_DGMGRL)(INSTANCE_NAME=ORA11GR2)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/u01/app/oracle/fast_recovery_area/ORA11GR2'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.arc'
    TopWaitEvents                   = '(monitor)'

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



DGMGRL> REMOVE CONFIGURATION PRESERVE DESTINATIONS;
Warning: ORA-16620: one or more databases could not be reached for a delete operation

Removed configuration
DGMGRL> help create

Creates a broker configuration

Syntax:

  CREATE CONFIGURATION AS
    PRIMARY DATABASE IS
    CONNECT IDENTIFIER IS ;

DGMGRL> CREATE CONFIGURATION EN AS PRIMARY DATABASE IS ENMOEDU CONNECT IDENTIFIER IS ENMOEDU;
Configuration "en" created with primary database "enmoedu"
DGMGRL> HELP ADD

Adds a standby database to the broker configuration

Syntax:

  ADD DATABASE
    [AS CONNECT IDENTIFIER IS ]
    [MAINTAINED AS {PHYSICAL|LOGICAL}];

DGMGRL> ADD DATABASE ORA11GR2 AS CONNECT IDENTIFIER IS ORA11GR2 MAINTAINED AS PHYSICAL;
Database "ora11gr2" added
DGMGRL> connect sys/oracle@ENMOEDU;
Connected.
DGMGRL> SHOW DATABASE verbose ENMOEDU;

Database - enmoedu

  Role:            PRIMARY
  Intended State:  OFFLINE
  Instance(s):
    ENMOEDU

  Properties:
    DGConnectIdentifier             = 'enmoedu'
    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          = '1'
    LogArchiveMinSucceedDest        = '1'
    DbFileNameConvert               = 'ORA11GR2, ENMOEDU'
    LogFileNameConvert              = 'ORA11GR2, ENMOEDU'
    FastStartFailoverTarget         = ''
    InconsistentProperties          = '(monitor)'
    InconsistentLogXptProps         = '(monitor)'
    SendQEntries                    = '(monitor)'
    LogXptStatus                    = '(monitor)'
    RecvQEntries                    = '(monitor)'
    SidName                         = 'ENMOEDU'
    StaticConnectIdentifier         = '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=enmo1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ENMOEDU_DGMGRL)(INSTANCE_NAME=ENMOEDU)(SERVER=DEDICATED)))'
    StandbyArchiveLocation          = '/u01/app/oracle/fast_recovery_area/ENMOEDU'
    AlternateLocation               = ''
    LogArchiveTrace                 = '0'
    LogArchiveFormat                = '%t_%s_%r.arc'
    TopWaitEvents                   = '(monitor)'

Database Status:
DISABLED

DGMGRL> ENABLE CONFIGURATION;
Enabled.
DGMGRL> SHOW CONFIGURATION VERBOSE;

Configuration - en

  Protection Mode: MaxPerformance
  Databases:
    enmoedu  - Primary database
    ora11gr2 - Physical standby database (disabled)

  Properties:
    FastStartFailoverThreshold      = '30'
    OperationTimeout                = '30'
    FastStartFailoverLagLimit       = '30'
    CommunicationTimeout            = '180'
    FastStartFailoverAutoReinstate  = 'TRUE'
    FastStartFailoverPmyShutdown    = 'TRUE'
    BystandersFollowRoleChange      = 'ALL'

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

以上是我搭建环境的时候报错 
请使用浏览器的分享功能分享到微信等