[OCI]: Dataguard configuration in OCI fails with "DCS-10045:Validation error encountered: invalid database logon credentials; logon denied." (Doc ID 2597867.1)

Last updated on OCTOBER 14, 2023

Applies to:

Symptoms

Dataguard configuration in OCI fails with following error:
DCS-10045:Validation error encountered: invalid database logon credentials; logon denied.

# /opt/oracle/dcs/bin/dbcli describe-job -i <failed job ID>
================================

Job details
----------------------------------------------------------------
ID: 1543c414-901b-4a03-9c72-b484255281c0
Description: Validate DG Config Creation
Status: Failure
Created: January 9, 2020 10:26:50 AM BST
Message: DCS-10045:Validation error encountered: invalid database logon credentials; logon denied.

Task Name Start Time End Time Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
task:TaskZLockWrapper_21794 January 9, 2020 9:26:50 AM BST January 9, 2020 10:26:50 AM BST Failure
Validate create dataguard config task January 9, 2020 10:26:50 AM BST January 9, 2020 10:26:50 AM BST Failure
Validate create dataguard config task January 9, 2020 10:26:50 AM BST January 9, 2020 10:26:50 AM BST Failure
================================

From \opt\oracle\dcs\log\dcs-agent-debug.log:
================================
2020-01-09 10:12:52,120 DEBUG [Validate create dataguard config task : JobId=1543c414-901b-4a03-9c72-b484255281c0] [] c.o.d.c.u.CommonsUtils:

run: cmd= '[su,
-,
grid,
-c,
/u01/app/19.0.0.0/grid/bin/sqlplus -S -L sys/"********"@<hostname.domain name>:1521/<db unique name.domain name> as sysdba @ /tmp/dcsserver/sqlplus/sqlplus2020-01-09_10-12-52-6771421331038277082.sql ]'
2020-01-09 10:12:52,185 DEBUG [Validate create dataguard config task : JobId=1543c414-901b-4a03-9c72-b484255281c0] [] c.o.d.c.u.c.CommandExecutor: Return code: 1
2020-01-09 10:12:52,185 DEBUG [Validate create dataguard config task : JobId=1543c414-901b-4a03-9c72-b484255281c0] [] c.o.d.c.u.CommonsUtils: Output :
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus

2020-01-09 10:12:52,185 ERROR [Validate create dataguard config task : JobId=1543c414-901b-4a03-9c72-b484255281c0] [] c.o.d.a.u.d.SqlPlusHelper: Db EzConnection Failed.
2020-01-09 10:12:52,185 ERROR [Validate create dataguard config task : JobId=1543c414-901b-4a03-9c72-b484255281c0] [] c.o.d.a.u.d.SqlPlusHelper: Failed to run the sql script /tmp/dcsserver/sqlplus/sqlplus2020-01-09_10-12-52-6771421331038277082.sql
2020-01-09 10:12:52,185 DEBUG [Validate create dataguard config task : JobId=1543c414-901b-4a03-9c72-b484255281c0] [] c.o.d.a.u.d.SqlPlusHelper: Finished running Sql Script /tmp/dcsserver/sqlplus/sqlplus2020-01-09_10-12-52-6771421331038277082.sql
2020-01-09 10:12:52,185 ERROR [Validate create dataguard config task : JobId=1543c414-901b-4a03-9c72-b484255281c0] [] c.o.d.a.v.DatabaseValidationUtil: ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

SP2-0751: Unable to connect to Oracle. Exiting SQL*Plus

2020-01-09 10:12:52,185 ERROR [Validate create dataguard config task : JobId=1543c414-901b-4a03-9c72-b484255281c0] [] c.o.d.a.v.DatabaseValidationUtil:
2020-01-09 10:12:52,185 ERROR [Validate create dataguard config task : JobId=1543c414-901b-4a03-9c72-b484255281c0] [] c.o.d.a.v.DatabaseValidationUtil: validateSysPassword: SqlPlus run got ERROR
2020-01-09 10:12:52,195 ERROR [Validate create dataguard config task : JobId=1543c414-901b-4a03-9c72-b484255281c0] [] c.o.d.c.j.JsonRequestProcessor: RPC request invocation failed on request: {"classz":"******** "
! com.oracle.dcs.commons.exception.DcsException: DCS-10045:Validation error encountered: invalid database logon credentials;
! logon denied.
================================

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.