I am still getting the same error message...i have question here regarding database name...where is it looking for db name?
DGMGRL> show database***** inconsistent_properties
Object "***" was not found
DGMGRL> show configuration
Configuration - *****_DG_CONFIG
Protection Mode: MaxPerformance
****DUKE1 - Primary database
****DUKE2 - Physical standby database
Fast-Start Failover: DISABLED
Not sure I understand you question, but I'm thinking it's in the Broker setup.
Do both database do this?
Are you using a format like this?
SHOW DATABASE '****DUKE1' 'inconsistent_properties' ;
When all else fails do over:
How to Safely Remove a Data Guard Broker Configuration (Doc ID 261336.1)
Also I assume you know once you start using Broker you cannot use SQL to change your config without creating SYNC issue between the Broker setup and the Database.
Is it perhaps a case thing...if my database name is in upper case and I don't put the database name in single quotes I get the "Object not found error:
DGMGRL> show database MODS
Object "mods" was not found
DGMGRL> show database 'MODS'
Database - MODS
Enterprise Manager Name: MODS.UK.INTRANET
Intended State: TRANSPORT-ON
here is the output of current dmon status
dukedmps03db05 | PAPPDM5 | /home/oracle
> ps -ef |grep dmon
oracle 3790 1 0 Mar23 ? 00:00:56 ora_dmon_PAPPDM5
oracle 56508 11262 0 11:59 pts/9 00:00:00 grep dmon
root 76478 1 0 Jan13 ? 01:16:43 /u01/app/220.127.116.11/grid/bin/cssdmonitor
oracle 84141 1 0 Mar25 ? 00:00:48 ora_dmon_PEDW5
In dgmgrl the database is the one you define in the configuration with 'create configuration' for the primary or 'create database' for others.
The name must match the db_unique_name, but the case can be different. In dgmgrl non quoted identifiers are translated to lower case.
SQL> show parameter db_unique_name NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_unique_name string U1 DGMGRL> connect / Connected as SYSDG.
DGMGRL> create configuration MYCONF as primary database is U1 connect identifier is "//localhost/beta1"; Configuration "myconf" created with primary database "u1" DGMGRL> show configuration Configuration - myconf Protection Mode: MaxPerformance Members: u1 - Primary database
Here the name used by data guard broker is lowercase (you see it from the output where dgmgrl added the quotes after making it lowercase.
In your case, it has been entered uppercase with quotes, so you must do the same.