While testing some scripts, I was getting an error on DGMGRL, while querying some databases:
DGMGRL> show database A1021P_SITE1
Object "a1021p_site1" was not found
But it would work if I put single quotes around:
DGMGRL> show database 'A1021P_SITE1'
Database - A1021P_SITE1
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
A1021P
Database Status:
SUCCESS
The problem is on the way the database was added to the configuration, and it is quite simple to fix it…
- after disabling configuration
- and connecting with password to the database
- then just rename the database to a name without using quotes.
DGMGRL> edit database 'A1021P_SITE1' rename to a1021p_site1;
Error: ORA-16602: database must be disabled to perform this operation
Failed.
DGMGRL> disable fast_start failover;
Disabled.
DGMGRL> disable configuration
Disabled.
DGMGRL> edit database 'A1021P_SITE1' rename to a1021p_site1;
ORA-16541: database is not enabled
Configuration details cannot be determined by DGMGRL
DGMGRL> edit database 'A1021P_SITE1' rename to a1021p_site1;
ORA-16541: database is not enabled
Configuration details cannot be determined by DGMGRL
DGMGRL> connect sys/XXXX@a1021p_site1
Connected.
DGMGRL> edit database 'A1021P_SITE1' rename to a1021p_site1;
Succeeded.
DGMGRL> show database A1021P_SITE1
Database - a1021p_site1
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
A1021P
Database Status:
DISABLED
DGMGRL> enable configuration;
Enabled.
DGMGRL> enable fast_start failover
Enabled.
DGMGRL> show configuration
Configuration - A1021P
Protection Mode: MaxAvailability
Databases:
a1021p_site1 - Primary database
a1021p_site2 - (*) Physical standby database
Fast-Start Failover: ENABLED
Configuration Status:
SUCCESS