My Oracle Support Banner

ORA-1031 Failed at Alter Database Start Logical Standby Apply Initial (Doc ID 378366.1)

Last updated on DECEMBER 16, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 9.2.0.7 [Release 9.2]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

Building a logical standby database, all steps are fine until start logical standby apply initial.

Alter database start logical standby apply initial;
database altered

But there is no rows in v$logstdby. In alert log:
Completed: ALTER DATABASE START LOGICAL STANDBY APPLY INITIAL
Wed Jul 26 19:13:06 2006
LOGSTDBY event: ORA-01031: insufficient privileges
Wed Jul 26 19:13:06 2006
Errors in file /u01/oracle/product/<PATH>/bdump/<FILE_NAME>.trc:
ORA-01031: insufficient privileges

lg92_lsp0_18120.trc trace shows:
knahcapplymain: encountered error=1031
*** 2006-07-26 19:13:06.770
ksedmp: internal or fatal error
ORA-01031: insufficient privileges
KNACDMP: Apply Coordinator's Context is NULL
error 1031 detected in background process
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-01031: insufficient privileges


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


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