I am enabling DG via console for G4S from Jeddah to Frankfurt. I
have been asked only the SYS password on the console via provisioning, But
Provisioning is failing saying password is incorrect. I have doublechecked the
password in the backend connecting via SQLPLUS and Reset the SYS/TDE wallet
password too as same as SYS password to ensure TDE wallet password is not
messing around. Wallet also open and look good in the DB.
Below is the current status :
# /opt/oracle/dcs/bin/dbcli list-jobs
04ca847a-71a2-4882-8c23-2de32e0e439a Validate DG
Config Creation
Friday, April 03, 2026, 20:47:20 AST Failure
# /opt/oracle/dcs/bin/dbcli describe-job
-i 04ca847a-71a2-4882-8c23-2de32e0e439a -l Verbose
Job details
----------------------------------------------------------------
ID: 04ca847a-71a2-4882-8c23-2de32e0e439a
Description:
Validate DG Config Creation
Status: Failure
Created: April 3, 2026 at 8:47:20 PM AST
Progress: 0%
Message:
DCS-10045:Validation error encountered: invalid database logon credentials;
logon denied.
Error Code: DCS-10045
Cause: Parameter validation
failed.
Action: Provide the correct
parameter values for the operation.
Task Name
Start Time
End Time
Status
------------------------------------------------------------------------
----------------------------------- -----------------------------------
----------
task:TaskZLockWrapper_280200
April 3, 2026 at 8:47:20 PM
AST April 3, 2026 at 8:47:22 PM AST
Failure
Validate create dataguard config task
April 3, 2026 at 8:47:20 PM AST April
3, 2026 at 8:47:22 PM AST Failure
Validate create dataguard config task
April 3, 2026 at 8:47:20 PM AST April
3, 2026 at 8:47:22 PM AST Failure
Log file to be investigated :
/opt/oracle/dcs/log/jobs/04ca847a-71a2-4882-8c23-2de32e0e439a.log
export ORACLE_HOME=/u01/app/19.0.0.0/grid;
/u01/app/19.0.0.0/grid/bin/sqlplus
-S -L sys@<Hostname>.<subnet>.oraclevcn.com:1521/<DB_UNIQUE_NAME>.xxxxxxxx.oraclevcn.com
as sysdba @
/tmp/dcsserver/sqlplus/sqlplus2026-04-03_20-47-22-8544278851304356271.sql]'
[2026-04-03 20:47:22,127] FINE [Validate create dataguard
config task : JobId=04ca847a-71a2-4882-8c23-2de32e0e439a]
com.oracle.dcs.commons.utils.command.CommandExecutor: Return code: 1
[2026-04-03 20:47:22,127] FINE [Validate create dataguard
config task : JobId=04ca847a-71a2-4882-8c23-2de32e0e439a]
com.oracle.dcs.commons.utils.CommonsUtils: Output :
ERROR:
ORA-12514:
TNS:listener does not currently know of service requested in connect
descriptor
Manual
Check :
sqlplus sys@<Hostname>.<subnet>.oraclevcn.com:1521/<DB_UNIQUE_NAME>.xxxxxxxx.oraclevcn.com as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Apr 4
17:41:12 2026
Version 19.24.0.0.0
Copyright (c) 1982, 2024, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-12514: TNS:listener does not currently know of
service requested in connect
descriptor
Reason
for the Error :
+ The listener does not have the service
"PRODCDB_dqc_jed.sn04g4sdbppri.vcn01g4sjedprod.oraclevcn.com" with
the
domain name .
+ To enable Data Guard on an EBS database using the OCI
Console, the above service must exist and be running.
Fix
:
SQL> select name from v$database;
NAME
---------
PRODCDB
SQL> BEGIN
DBMS_SERVICE.START_SERVICE(
'DB_Unique_name.snxxxxxx.xxxxxxx.oraclevcn.com'
);
END;
/ 2 3
4 5 6
PL/SQL procedure successfully completed.
SQL> ALTER SYSTEM REGISTER;
System altered.
Ensure Listener picked up the Service :
Ensure you can connect manually :
sqlplus sys@<Hostname>.<subnet>.oraclevcn.com:1521/<DB_UNIQUE_NAME>.xxxxxxxx.oraclevcn.com as sysdba
Once the connection happens, I was able to DG fine via console.
Happy Learning.
No comments:
Post a Comment