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 184.108.40.206 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.
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!