Re: Replication trouble

From: <ramakrishna.gv_at_db.com>
Date: Tue, 17 Oct 2000 07:06:07 +0530
Message-Id: <10651.119409@fatcity.com>

Hi
Have u compiled the invalid objects in sys.

Thanks & Regards

Ram
Tel:4236953

Message History ----------------------------------------

From: henrik.ekenberg_at_anoto.com on 16/10/2000 09:04 GMT

Please respond to ORACLE-L_at_fatcity.com

To: ORACLE-L_at_fatcity.com
cc:
Subject: Replication trouble

Hello,

I have one small problem on Sun Solaris 8

                         Oracle 8.1.5

I have run catalog,catproc and catrep as internal. But when I try todo GRANT_ADMIN_ANY_SCHEMA to the repadmin user I have one 4063 and 4068 error.

Some hint ??

     SQL>
     SQL> grant dba to repadmin;

     Grant succeeded.

     SQL>
     SQL> BEGIN
       2     DBMS_REPCAT_ADMIN.GRANT_ADMIN_ANY_SCHEMA (
       3        USERNAME => 'repadmin');
       4  END;
       5  /
     BEGIN
     *
     ERROR at line 1:
     ORA-04068: existing state of packages has been discarded
     ORA-04063: package body "SYS.DBMS_REPCAT_ADMIN" has errors
     ORA-06508: PL/SQL: could not find program unit being called
     ORA-06512: at line 2

Regards
Henrik

Henrik Ekenberg                                   Anoto AB
www.anoto.com                                     Switchb. +46 (0)8 406 79
00
E-mail :henrik.ekenberg_at_anoto.com                 Fax      +46 (0)8 406 79

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Henrik Ekenberg
INET: henrik.ekenberg_at_anoto.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

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 Received on Mon Oct 16 2000 - 20:36:07 CDT