Enterprise Manager May show message 'STRMADMIN - Is Not In The Streams Administrator Group And May Not Have Full Privileges To Setup Successful Replication' or 'Streams Replication is not setup for this database
(Doc ID 1205393.1)
Last updated on FEBRUARY 05, 2020
Applies to:Enterprise Manager for Oracle Database - Version 10.2.0.1 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.
The Streams Administrator schema STRMADMIN was created by the following:
create user strmadmin identified by strmadmin;
alter user strmadmin default tablespace users temporary tablespace temp quota unlimited on users;
grant connect, resource, aq_administrator_role, dba to strmadmin;
However, getting the following warning in Enterprise Manager:
Oracle recommends that following issues be resolved before submitting the Streams replication setup job
STRMADMIN - Is not in the Streams Administrator group and may not have full privileges to setup successful replication
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document