Home » Server Options » Streams & AQ » Error at create capture process (Oracle 11g Centos 5)
Error at create capture process [message #465457] Wed, 14 July 2010 04:24 Go to next message
Messages: 9
Registered: April 2009
Junior Member

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.
Re: Error at create capture process [message #466372 is a reply to message #465457] Mon, 19 July 2010 05:33 Go to previous message
Yasir Hashmi
Messages: 304
Registered: April 2006
Senior Member
Did you run

    grantee         => 'strmadmin',    
    grant_privileges => true);

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

Current Time: Tue Dec 01 14:15:21 CST 2015

Total time taken to generate the page: 0.11413 seconds