LOG_ARCHIVE_DEST_2 Fails With ORA-1031 While Configuring Streams Downstream Capture (Doc ID 259142.1)

Last updated on MAY 07, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.1.0.2 [Release 10.1]
Information in this document applies to any platform.


Symptoms

When configuring log transport services for Streams Downstream capture, you may encounter this situation.
On the source database, the remote archive destination might to be specified as follows :
log_archive_dest_2 = 'SERVICE=TEST10.IDC.ORACLE.COM LGWR MANDATORY NOREGISTER
REOPEN=120'
However, an attempt to ship the log to the remote destination will fail with errors like :

ORA-16014: log 3 sequence# 10 not archived, no available destinations
ORA-00312: online log 3 thread 1: 'F:\V10\ORADATA\V10\REDO03.LOG'



The generated trace file contains :

Redo shipping client performing standby login
OCISessionBegin failed -1
Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges


*** 2003-11-30 18:55:30.937 49871 kcrr.c
Error 1031 received logging on to the standby
Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'TEST10'
Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'TEST10'
ORA-01031: insufficient privileges
*** 2003-11-30 18:55:30.984 49871 kcrr.c
ARC1: Heartbeat failed to connect to standby 'TEST10'. Error is 1031.
*** 2003-11-30 18:55:30.984 48767 kcrr.c
kcrrfail: dest:2 err:1031 force:0 blast:1




The ERROR column in V$ARCHIVE_DEST shows ORA-01031 insufficient privileges.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms