My Oracle Support Banner

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.

Goal

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;

execute dbms_streams_auth.grant_admin_privilege('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

Solution

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.