Help - Search - Members - Calendar
Full Version: Oracle11g Streams- error executing DBMS_STREAMS_AUTH.GRANT_ADMIN_PRIVILEGE
Oracle DBA Forums > Oracle > Oracle Forum
karpagam
Hello,

I am configuring Oracle Streams in Oracle 11.2.0.1 environment.
I created the strmadmin user and trying to grant necessary privilleges using DBMS_STREAMS_AUTH.GRANT_ADMIN_PRIVILEGE package.

I got the below error:
------------------------------

BEGIN
*
ERROR at line 1:
ORA-04063: package body "SYS.DBMS_REPCAT_UTL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_REPCAT_UTL"
ORA-06512: at "SYS.DBMS_STREAMS_AUTH", line 1621
ORA-06512: at line 2
---------------------------------
I found the package DBMS_REPCAT_UTL invalid and tried to recompile the invalid objects using utlrp.sql.
No invalid objects turned to valid status.

Also I find the package , DBMS_REPCAT_UTL is deprecated

Kindly help me to sort out this problem.

Thanks
Karpagam
burleson

>> ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_REPCAT_UTL"

Sign-on as the sys USER.

Dis you not run the cataloag, scrpt?

Try re-tunning catqm.sql. and catrep.sql as sys.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.