The Data Guard association setup in OCI - Bare Metal Failed on task Enable force logging and archivelog mode in primary env (Doc ID 2442840.1)

Last updated on OCTOBER 01, 2019

Applies to:

Symptoms

The Data Guard association was enabled using the Steps documented in the Oracle Doc (https://docs.cloud.oracle.com/iaas/Content/Database/Tasks/usingdataguard.htm)

The Data Guard association  failed in the OCI - Console .
Gather all jobs from Primary and Standby DB system if the Data Guard association failed in the OCI Console.

Login to the Primary DB system and Standby DB systemas opc user and switch to root

$sudo -s

#cd /opt/oracle/dcs/bin

#./dbcli list-job

#./dbcli describe-job -i <job id for all task/job related to DG setup>

Ref:  Note 2439602.1 to collect diagnostic information.

In the following scenario, the DG Config service creation job failed in the Primary DB system
The DG Config service creation have multiple sub-task which is listed by running the command dbcli describe-job -i <id>
The sub task failure in our case is Enable force logging and archivelog mode in primary env

Upon verifying the dcs agent log file, found the remote SYS operation failed with ORA-01017

• Primary DB system

#dbcli list-jobs

ID                                       Description                                                                 Created                             Status
---------------------------------------- --------------------------------------------------------------------------- ----------------------------------- ----------
109f9915-a7ef-4243-acf0-226341ea2cee     DG Config service creation                                                  September 3, 2018 8:29:48 PM UTC    Failure


#dbcli describe-job -i 109f9915-a7ef-4243-acf0-226341ea2cee

Job details
----------------------------------------------------------------
                     ID:  109f9915-a7ef-4243-acf0-226341ea2cee
            Description:  DG Config service creation
                 Status:  Failure
                Created:  September 3, 2018 8:29:48 PM UTC
                Message:  DCS-10001:Internal error encountered: Unable to create Redo Logs.

Task Name                                Start Time                          End Time                            Status
---------------------------------------- ----------------------------------- ----------------------------------- ----------
task:TaskZLockWrapper_4750                               September 3, 2018 8:29:48 PM UTC                    September 3, 2018 8:29:52 PM UTC    Failure
DG config primary task                                   September 3, 2018 8:29:48 PM UTC                    September 3, 2018 8:29:52 PM UTC    Failure
Configure host DNS on primary env                        September 3, 2018 8:29:48 PM UTC                    September 3, 2018 8:29:48 PM UTC    Success
Configure dataguard Tns on primary env                   September 3, 2018 8:29:48 PM UTC                    September 3, 2018 8:29:48 PM UTC    Success
Enable Db parameters for primary                         September 3, 2018 8:29:48 PM UTC                    September 3, 2018 8:29:50 PM UTC    Success
Enable force logging and archivelog mode in primary env September 3, 2018 8:29:50 PM UTC                    September 3, 2018 8:29:52 PM UTC    Failure


#cd /opt/oracle/dcs/log
#grep -i ORA-01017 *.log
dcs-agent.log:ORA-01017: invalid username/password;

• From /opt/oracle/dcs/log/dcs agent log file:
  .....................
  2018-09-03 13:29:52,283 DEBUG [Enable force logging and archivelog mode in primary env] [] c.o.d.c.u.CommonsUtils: Output :
  ERROR:
  ORA-01017: invalid username/password;
   ******** denied
   
  

Changes

Cause

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