OraFAQ Forum: Streams & AQ » Error at create capture process

Home » Server Options » Streams & AQ » Error at create capture process (Oracle 11g Centos 5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Error at create capture process [message #465457]

Wed, 14 July 2010 04:24

Loles
Messages: 9
Registered: April 2009

Junior Member

Hello!

I'm configuring Oracle Streams 11g. When I'm trying create capture process I receive this error:

ORA-01031: insufficient privileges
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 372
ORA-06512: at "SYS.DBMS_STREAMS_ADM", line 312

User stream administrator "stradmin" has dba role in both source and target databases.

Can you help me?

Thank you.

Report message to a moderator

Re: Error at create capture process [message #466372 is a reply to message #465457]

Mon, 19 July 2010 05:33

Yasir Hashmi
Messages: 304
Registered: April 2006

Senior Member

Hi,
Did you run

BEGIN
  DBMS_STREAMS_AUTH.GRANT_ADMIN_
PRIVILEGE(
    grantee         => 'strmadmin',    
    grant_privileges => true);
END;

Report message to a moderator

Previous Topic:	AQ
Next Topic:	unique constraint (SYSTEM.LOGMNR_SESSION_UK1) violated

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 04 02:46:09 CST 2026