Maybe someone can explain this to me. I decided to configure our current standby databases for administration in EM 12c via the "Manage an existing standby database with Data Guard broker". The first one went off without issue but on the second I got "ORA-16664: unable to receive the result from a database". I've scoured through everything and confirmed, more than once, that the tnsnames, listener and pwfile are all good to go. I can tnsping everything from both servers. The sby1 database is functioning fine and all log files are being transported and applied without issue from primary to standby, on different servers. I can connect via sqlplus to each database from opposite servers.
I don't understand how I can do the below in DGMGRL:
The listener doesn't not know of service requested (PRI1) and is unreachable in the first connect, but then I can turn around and successfully connect to PRI1 without issue?
DGMGRL> connect sys@sby1
Password:
Connected.
DGMGRL> show configuration;
Configuration - PRI1_ora-9002.xxxx
Protection Mode: MaxPerformance
Databases:
PRI1 - Primary database
sby1 - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
ORA-16625: cannot reach database "PRI1"
DGM-17017: unable to determine configuration status
DGMGRL> connect sys@pri1
Password:
Connected.
DGMGRL> show configuration
Configuration - PRI1_ora-9002.xxxx
Protection Mode: MaxPerformance
Databases:
PRI1 - Primary database
sby1 - Physical standby database
Error: ORA-16664: unable to receive the result from a database
Fast-Start Failover: DISABLED
Configuration Status:
ERROR
DGMGRL> ;