My Oracle Support Banner

Streams Capture Failing with ORA-942 on RAC Database Restart via SRVCTL (Doc ID 2398403.1)

Last updated on FEBRUARY 28, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A 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

To view full details, 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 a vibrant support community of peers and Oracle experts.