Re: Streams error- PLS-00201: identifier 'DBMS_AQADM' must be declared
- From: Prasad <p4cldba@xxxxxxxxx>
- To: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
- Date: Fri, 9 Nov 2007 17:26:05 -0800
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@xxxxxxxxx> 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@xxxxxxxxx> 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
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
