Return
-
Title
Unable to configure Standby Connection on Oracle RAC installation -
Description
On the Standby connection window, it is not possible to set up the DB Name on the Standby Connection Window.
Connection details are for the incorrect standby database.
.png)
-
Resolution
Execute the following SQL query on primary:
SELECT dest_id,
dest_name,
destination,
db_unique_name
FROM v$archive_dest
WHERE target= 'STANDBY' AND schedule IN ('ACTIVE','LATENT') AND dest_name LIKE 'LOG_ARCHIVE_DEST_%';And following on secondary node:
select db_unique_name,name,protection_mode,dataguard_broker,open_mode,database_role,platform_name,dbid,current_scn,'NO' cdb,NULL con_name,NULL con_idfrom v$database;
If the db_unique_name column is not the same, please correct the configuration of archive destination. It need to be the same on both servers.