Dataguard creation on OCI Base Database failing with DCS-12541 ORA-12514
(Doc ID 2971012.1)
Last updated on OCTOBER 06, 2023
Applies to:
Oracle Cloud Infrastructure - Database Service - Version N/A and laterInformation in this document applies to any platform.
Symptoms
Customer was trying to create Dataguard for OCI Base Database service which was failing with below errors :
[root@primary_host ~]# /opt/oracle/dcs/bin/dbcli describe-job -i 9acee8b2-65c6-46dd-86a2-0be083235bb0 -l Verbose
Job details
----------------------------------------------------------------
ID: 9acee8b2-65c6-46dd-86a2-0be083235bb0
Description: DG Config service creation
Status: Failure
Created: August 21, 2023 6:16:40 AM CDT
Progress: 8%
Message: DCS-12541:Data Guard broker configuration failed.
Error Code: DCS-12541
Cause: Unable to configure broker.
Action: Check database role/state and retry the operation.
Task Name Start Time End Time Status
------------------------------------------------------------------------ ----------------------------------- ----------------------------------- ----------
task:TaskZLockWrapper_44396 August 21, 2023 6:16:40 AM CDT August 21, 2023 6:16:52 AM CDT Failure
DG config dataguard task August 21, 2023 6:16:40 AM CDT August 21, 2023 6:16:52 AM CDT Failure
Registering listner August 21, 2023 6:16:40 AM CDT August 21, 2023 6:16:40 AM CDT Success
Config and enable data guard August 21, 2023 6:16:40 AM CDT August 21, 2023 6:16:52 AM CDT Failure
++ Log shows services were not getting registered on standby listener :
2023-08-21 06:16:43,680] FINE [Config and enable data guard : JobId=9acee8b2-65c6-46dd-86a2-0be083235bb0] com.oracle.dcs.commons.utils.CommonsUtils:
create configuration 'primary_db_standby_db' as primary database is 'primary_db' connect identifier is 'primary_db' ;
[2023-08-21 06:16:43,680] FINE [Config and enable data guard : JobId=9acee8b2-65c6-46dd-86a2-0be083235bb0] com.oracle.dcs.commons.utils.CommonsUtils:
add database 'standby_db' as connect identifier is 'standby_db' maintained as physical ;
[2023-08-21 06:16:43,680] FINE [Config and enable data guard : JobId=9acee8b2-65c6-46dd-86a2-0be083235bb0] com.oracle.dcs.commons.utils.CommonsUtils:
enable configuration ;
Welcome to DGMGRL, type "help" for information.
Password:
Connected to "primary_db"
Connected as SYSDBA.
Configuration "primary_db_standby_db" created with primary database "primary_db"
Error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor >>>>>>>>>
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |