Message-ID: <F001.005D46F0.20031026030926@fatcity.com>
Date: Sun, 26 Oct 2003 03:09:26 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: ml-errors@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: "Tanel Poder" <tanel.poder.003@mail.ee>
Subject: Re: Replication : ORA-04068: existing state of packages has been
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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