ORA-16796: one or more properties could not be imported from the database [ID 358040.1]-优快云博客

ORA-16796: one or more properties could not be imported from the database [ID 358040.1]

	Modified 29-MAY-2009Type PROBLEMStatus MODERATED

In this Document
Symptoms
Cause
Solution

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4
This problem can occur on any platform.

Symptoms

$ dgmgrl
DGMGRL for Linux: Version 10.2.0.1.0 - Production

Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/<Password>
Connected.
DGMGRL> remove configuration
Removed configuration

DGMGRL> create configuration 'SHRUB' as
> primary database is 'SHRUB'
> connect identifier is 'SHRUB';
Configuration "SHRUB" created with primary database "SHRUB"

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

Failed.

Following error reported in the standby dataguard broker log

DG 2006-02-14-22:16:08 0 2 0 DMON: cannot open configuration file "/oracle/product/10.2.0/dbs/dr2wagtail.dat"

Cause

Noticedfollowing file was not exists atstandby server.

DG 2006-02-14-22:16:08 0 2 0 DMON: cannot open configuration file "/oracle/product/10.2.0/dbs/dr2wagtail.dat"

Solution

1) Stop the Data Guard Broker on both, the Primary and Standby Database using following Command:

SQL> alter system set dg_broker_start=false scope=both;

2) Remove the old Data Guard Broker Configuration Files specified by the Initialization Parameter 'DG_BROKER_CONFIG_FILE1|2' from Primary and Standby Site.

3)Start the Data Guard Broker on both Sites again:

SQL> alter system set dg_broker_start = true scope=both;

4) Recreate the Data Guard Broker Configuration

------------------------------------------------------------------------------

Blog： http://blog.youkuaiyun.com/tianlesoftware

网上资源： http://tianlesoftware.download.youkuaiyun.com

相关视频：http://blog.youkuaiyun.com/tianlesoftware/archive/2009/11/27/4886500.aspx

DBA1 群：62697716(满); DBA2 群：62697977(满)

DBA3 群：62697850 DBA 超级群：63306533;

聊天群：40132017