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

Question

502 views24/04/2023Oracle Database

0

Amen1.09K 15/04/2023 0 Comments

What is the cause and solution for Oracle error ORA-16796: one or more properties could not be imported from the database?

Ezana Answered question 24/04/2023

Write your answer.

score 0 · Answer 1 · 2023-04-24T08:42:26+00:00

Cause:

The configuration file is not opened and does not exist on the standby server.

Solution:

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;
```
Remove the old Data Guard Broker Configuration Files specified by the Initialization Parameter ‘DG_BROKER_CONFIG_FILE1|2’ from Primary and Standby Site.

Start the Data Guard Broker on both Sites again:

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