Re: Streams error- PLS-00201: identifier 'DBMS_AQADM' must be declared

From: Prasad <p4cldba_at_gmail.com>
Date: Fri, 9 Nov 2007 17:26:05 -0800
Message-ID: <666b99c70711091726y77f21953qd7cb4bbf6f1600fb@mail.gmail.com>

SQL> select propagation_name,source_queue_owner,destination_dblink   2 from dba_propagation;

PROPAGATION_NAME SOURCE_QUEUE_OWNER

------------------------------ ------------------------------

DESTINATION_DBLINK

---

CAPTURE_STREAM                 STRMADMIN

DEV10G.US.ORACLE.COM and I granted the below privileges as suggested to strmadmin .as the source db is 9i .

GRANT EXECUTE ON DBMS_AQADM TO strmadmin;
GRANT EXECUTE ON DBMS_STREAMS_ADM TO strmadmin;
GRANT EXECUTE ON DBMS_APPLY_ADM to strmadmin;
GRANT EXECUTE ON DBMS_CAPTURE_ADM to strmadmin;
GRANT EXECUTE ON DBMS_PROPAGATION_ADM to strmadmin;
GRANT EXECUTE ON DBMS_FLASHBACK to strmadmin;

GRANT SELECT_CATALOG_ROLE to strmadmin;
GRANT SELECT ANY DICTIONARY to strmadmin; GRANT ALL PRIVILEGES TO strmadmin;

but still i dont see the dml changes not getting propagation. Can you please point me to where to start the debugging .

thanks
-Prasad

On Nov 9, 2007 4:06 PM, Alexander Fatkulin <afatkulin_at_gmail.com> wrote:
> see in the dba_jobs who is the propagation job owner
>
> if your propagation job owner is strmadmin and you've granted access
> only through a role -- it will not work in 9i, since that use need an
> explicit execute grant on that package for propagation to work (for
> 10G I found that propagation works regardless).
>
> On Nov 9, 2007 6:30 PM, Prasad <p4cldba_at_gmail.com> wrote:
> > i have all the access granted to strmadmin user. but the owner of the
>
>
>
>
> --
>
> Alex Fatkulin,
> The Pythian Group,
> http://www.pythian.com/blogs/author/alexf
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Nov 09 2007 - 19:26:05 CST