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

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

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

SQL> SELECT thread#, dest_id, gvad.status, error, fail_sequence FROM gv$archive_dest gvad, gv$instance gvi WHERE gvad.inst_id = gvi.inst_id AND destination is NOT NULL ORDER BY thread#, dest_id;

THREAD# DEST_ID STATUS ERROR FAIL_SEQUENCE
---------------------------------------------------------------------------------
1 1 VALID 0
1 2 ERROR ORA-16191: Primary log shipping client not logged on standby 0

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 " 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

After granting SYSOPER and SYSDG to redo_transport_user, Password File was created again at Primary and copied to Standby, but issue remained.

Below query listed redo_transport_user (REDO_USER) only at Primary, but not at Standby.

后续精彩内容已被站长无情隐藏，请输入验证码解锁本文！

验证码：

获取验证码： 请先关注本站微信公众号，然后回复“验证码”，获取验证码。在微信里搜索“AiDBA”或者“dbaup6”或者微信扫描右侧二维码都可以关注本站微信公众号。