Hi DG experts,
Having issues with crearting a configuration for a physical STandby for DG Broker. Here is the statement and error:
DGMGRL> ADD DATABASE 'DNATRECO' AS
CONNECT IDENTIFIER IS DNATRECO.JEPPESEN.COM
MAINTAINED AS PHYSICAL ;
Error: ORA-16796: one or more properties could not be imported from the database
Failed.
DGMGRL>
Background history
==============
Created 10.2.0.3.0 Database
Created a Physical Standby database using the the Oracle documenttation
Both of the above went well and Now trying to setup a DG broker:
The below Step 1 went well..
DGMGRL> CREATE CONFIGURATION 'DRTEST' AS
PRIMARY DATABASE IS 'DNATTEST'
CONNECT IDENTIFIER IS DNATTEST.JEPPESEN.COM ;
Configuration "DRTEST" created with primary database "DNATTEST"
DGMGRL> show configuration
Configuration
Name: DRTEST
Enabled: NO
Protection Mode: MaxPerformance
Fast-Start Failover: DISABLED
Databases:
DNATTEST - Primary database
Current status for "DRTEST":
DISABLED
Any help is sppreciated..
Here is what I got from Broker log
===========================
DG 2008-05-21-08:49:07 0 2 0 DMON: Failed to get properties from remote database DNATRECO. Error is ORA-12154.
DG 2008-05-21-08:49:07 0 2 0 Error: importing database setting from the remote site failed.
DG 2008-05-21-08:49:07 0 2 0 DMON: Failed to connect to remote database DNATRECO. Error is ORA-12154
DG 2008-05-21-08:49:07 0 2 0 DMON: Failed to get properties from remote database DNATRECO. Error is ORA-12154.
DG 2008-05-21-08:49:07 0 2 0 Error: importing database setting from the remote site failed.
DG 2008-05-21-08:49:07 2000000 3 655122728 Add resource failed.
DG 2008-05-21-08:49:07 2000000 3 655122728 Failed to add the database resource, deleting the site.
DG 2008-05-21-08:49:07 2000000 3 655122728 DMON: ADD_DATABASE: (error=ORA-16796)
DG 2008-05-21-08:49:07 2000000 3 655122728 DMON: ADD_DATABASE operation completed
DG 2008-05-21-08:49:07 2000000 3 655122728 DMON: Entered rfm_release_chief_lock for ADD_DATABASE