ORA-16796: one or more properties could not be imported from the database ORACLE 报错 故障修复 远程处理

文档解释

ORA-16796: one or more properties could not be imported from the database

Cause: The broker was unable to import property values for the database being added to the broker configuration. This error indicates:
– The oracle Net service name specified in DGMGRL CREATE CONFIGURATION or ADD DATABASE command was not one that provides access to the database being added.
– There were no instances running for the database being added.

Action: Remove the database from the configuration using the REMOVE CONFIGURATION or REMOVE DATABASE command. Make sure that the database to be added has at least one instance running and that the Oracle Net service name provides access to the running instance. Also check the broker log file for additional infORMation. Then, reissue the CREATE CONFIGURATION or ADD DATABASE command.

。

ORA-16796: one or more properties could not be imported from the database是Oracle数据库迁移过程中，在将数据库对象导入至新数据库时可能引发的一个错误。官方描述说明：This error occurs when one or more of the properties required by the target system are not present in the source system.

常见案例

正常处理流程：

1. 首先，检查源数据库和目标数据库版本信息，确认是否具有可迁移性。

2. 在开始数据库迁移前，检查源数据库及目标数据库，在网上搜集必要的手动配置信息，以便迁移成功。

3. 给定的系统内存，确保数据库导出导入操作能够使用内存。

4. 如果源和目标数据库结构具有变化，需要使用Oracle的数据库比较工具确保正确修改数据库结构，以确保迁移成功之前不会发生其他错误。

5. 在真正进行迁移之前，要使用Oracle的迁移检查工具，检查系统中是否有任何不兼容的属性，以避免任何不可预见的后果。

6. 最后，在源和目标机器上执行导入/导出操作，确保正确迁移数据库及所有必要属性。