在使用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