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
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.
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
Hi,
Did you run

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

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


Current Time: Wed Jul 23 01:33:24 CDT 2014

Total time taken to generate the page: 0.07112 seconds