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

Hi!

Just for the record, one other solution would probably have been to set REMOTE_DEPENDENCIES_MODE = SIGNATURE. Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Saturday, October 25, 2003 10:24 PM

> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

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).