oracel 10g data guard 使用dgmgrl

在使用dgmgrl配置oracle dg的故障自动切换主从数据库时遇到如下问题：

DGMGRL> remove configuration;
Removed configuration
DGMGRL> create configuration 'dgconfig' as primary database is 'dg1' connect identifier is 'dg1';
Configuration "dgconfig" created with primary database "dg1"
DGMGRL> add database 'dg2' as connect identifier is test maintained as physical;
Error: ORA-16796: one or more properties could not be imported from the database

Failed.
DGMGRL> show configuration;

Configuration
  Name:                dgconfig
  Enabled:             NO
  Protection Mode:     MaxPerformance
  Fast-Start Failover: DISABLED
  Databases:
    dg1 - Primary database

Current status for "dgconfig":
DISABLED

DGMGRL> add database 'devdb1' as connect identifier is test maintained as physical;
Error: ORA-16796: one or more properties could not be imported from the database

Failed.
DGMGRL>

 将主库的tnsnames.ora和listener.ora贴出

# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

LSNODE2 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.128.52)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = devdb1)
    )
  )

LSNODE1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.128.51)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = devdb1)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

 

# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = devdb1)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
      (SID_NAME = devdb1)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = dg1)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
      (SID_NAME = devdb1)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = dg1_DGMGRL)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
      (SID_NAME = devdb1)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dg1.orademo.org)(PORT = 1521))
    )
  )

 

找不到错误的解决方案了，有点晕，您知道吗？欢迎您给我予指点。谢谢!

 

 

上边的错误我知道怎么解决了：

需要将 listener.ora中的“lsnode1”和“lsnode2”修改为 “dg1”“dg2”，需要与 init<S_ID>.ora中的“DB_UNIQUE_NAME”一致，但是又有新的问题了

DGMGRL> show configuration;

Configuration
  Name:                dgconfig
  Enabled:             YES
  Protection Mode:     MaxPerformance
  Fast-Start Failover: DISABLED
  Databases:
    dg1 - Primary database
    dg2 - Physical standby database

Current status for "dgconfig":
Warning: ORA-16607: one or more databases have failed

 不知道该怎么解决，请教各位了

 

 

终于配置好了^_^，有什么问题可以发邮件给我：fangrn@163.com