My Oracle Support Banner

ORA-16191 and ORA-1017 reported for Log Transport to Standby when using "redo_transport_user" (Doc ID 2848435.1)

Last updated on APRIL 29, 2022

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

NOTE: In the images and/or the document content below, the user information and environment data used represents fictitious data

from the Oracle sample schema(s), Public Documentation delivered with an Oracle database product or other training material.

Any similarity to actual environments, actual persons, living or dead, is purely coincidental and not intended in any manner.

 

For the purposes of this document, the following fictitious environment is used as an example to describe the procedure:

Database name                     : ORCL

Primary db db_unique_name  : ORCL

Standby db db_unique_name : ORCLDR

 


ORA-16191 and ORA-1017 reported for Log Transport when using "redo_transport_user"

PRIMARY

 Following checks were done and passed 

1. Check where the Password File is located :

a. If within '$ORACLE_HOME/dbs", then File naming should be as "orapw$ORACLE_SID" (example : orapwORCL)

    For RAC, need to ensure that correct ORACLE_SID/INSTANCE_NAME is reflecting in the Password File Name of each instance (orapw$ORACLE_SID => example : orapwORCL1, orapwORCL2)

b. Password File within ASM Disk Group and registered in OCR

    Check the output of "$ srvctl config database -d <db_unique_name>" to see if Password File field is populated

2. Checksum of Password Files at Primary and Standby should match

    Check the output of "md5sum orapwORCL" at each Node of Primary and Standby

3. remote_login_passwordfile=EXCLUSIVE

4. sec_case_sensitive_logon=TRUE

    If set to TRUE, then ensure that password file is created with option IGNORECASE=N
    If set to FALSE, then ensure that password file is created with option IGNORECASE=Y

Changes

Redo transport configured to use 'redo_transport_user=REDO_USER'

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
Changes
Cause
Solution
References


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