Re: Replication : ORA-04068: existing state of packages has been

Thanks Jared.

Recently we did run catrepr.sql and catrep.sql to recreate replication catalog.

I was getting the same error even after recompiled all the invalid objects(few packages were invalid). Then restared my instance and now it is woking fine.

Thanks again
-tamizh

• Original Message ----- Date: Saturday, October 25, 2003 2:04 pm

> Have you recently made any changes to your database?
>
> Upgrades, etc?
>
> This is the message you will receive when the state
> of a package is invalid. It either needs recompiled,
> as something it is dependent on has changed, and/or
> it is broken for the same reason.
>
> One possible explanation for this is an incomplete
> upgrade.
>
> You can recompile all stored code in the database
> by logging in as SYS and running $ORACLE_HOME/rdbms/admin/utlrp.sql.
>
> There's another script for this as well, but I can't recall
> it at the moment. The above script is generally used as
> a final step in an upgrade.
>
> Jared
>
> On Sat, 2003-10-25 at 10:14, tamizh_at_optonline.net wrote:
> > Hi List,
> >
> > Coudl someone please help me out to resolve this issue?
> >
> > 1 begin
> > 2* dbms_repcat.do_deferred_repcat_admin('scott_mg',FALSE);
> > end;
> > /
> >
> >
> > begin
> > *
> > ERROR at line 1:
> > ORA-04068: existing state of packages has been discarded
> > ORA-04062: of has been changed
> > ORA-04062: timestamp of package "SYS.DBMS_REPCAT_RPC" has been
> changed> ORA-06512: at "SYS.DBMS_REPCAT_MAS", line 812
> > ORA-06512: at "SYS.DBMS_REPCAT", line 532
> > ORA-06512: at line 2
> >
> >
> > -tamizh
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author:
> > INET: tamizh_at_optonline.net
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting
> services> ---------------------------------------------------------
> ------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jared Still
> INET: jkstill_at_cybcon.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> -------------------------------------------------------------------
> --
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: tamizh_at_optonline.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).