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

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