ORA-00604, ORA-00942 During Instance Startup When Startup Trigger Enabled (Doc ID 1381800.1)

Last updated on DECEMBER 15, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 15-Dec-2016***

Symptoms

The database does start successfully, but the alert log file shows:

Errors in file /oradata3/diag/rdbms/bcp/polaris/trace/polaris_ora_17039488.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
ORA-06512: at line 7
Completed: ALTER DATABASE OPEN



The referenced trace file shows:

*** 2011-11-28 08:44:30.953
Error in executing triggers on database startup <==================******
*** 2011-11-28 08:44:30.954
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=0, mask=0x0)
----- Error Stack Dump -----
ORA-00604: error occurred at recursive SQL level 1
ORA-00942: table or view does not exist
ORA-06512: at line 7

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