Streams Capture Failing with ORA-942 on RAC Database Restart via SRVCTL
Last updated on JUNE 19, 2018
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
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.
Upgrade to RDBMS 12.2.x
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