My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

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


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 :
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.


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

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