LOG_ARCHIVE_DEST_2 Fails With ORA-1031 While Configuring Streams Downstream Capture
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.
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
However, an attempt to ship the log to the remote destination will fail with errors like :
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
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.
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