Streams Capture Failing with ORA-942 on RAC Database Restart via SRVCTL

(Doc ID 2398403.1)

Last updated on JUNE 19, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

When a Streams capture process is in an enabled state and the database is shutdown, it is expected that the process would remain enabled after the database is restarted.
In 12.2, capture will fail on restart with an ORA-942 if it is restarted via SRVCTL.  Restart via SQL*Plus works as expected.

Changes

Upgrade to RDBMS 12.2.x

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