RE: Replication trouble

From: <ramakrishna.gv_at_db.com>
Date: Tue, 17 Oct 2000 12:29:50 +0530
Message-Id: <10652.119421@fatcity.com>

Hi henrik

check ur system user. whether u have repcat$_repobject table or not. if it is not created then

open $ORACLE_HOME/rdbms/admin/catrepc.sql

search for this statement 'CREATE TABLE system.repcat$_repobject ' remove semicolon in comments statements.

This is a bug in catrepc.sql in oracle 815. now run the catrep.sql again.

Thanks & Regards

Ram
Tel:4236953

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

From: henrik.ekenberg_at_anoto.com on 17/10/2000 07:05 GMT

Please respond to ORACLE-L_at_fatcity.com

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

Hello,

Yes I have also compile the invalid object. But it doesn't work.

Regards
Henrik

Henrik Ekenberg                                   Anoto AB

www.anoto.com

-----Original Message-----

ramakrishna.gv_at_db.com
Sent: den 17 oktober 2000 04:41
To: Multiple recipients of list ORACLE-L

Hi
Have u compiled the invalid objects in sys.

Thanks & Regards

Ram
Tel:4236953

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

Please respond to ORACLE-L_at_fatcity.com

To: ORACLE-L_at_fatcity.com
cc:

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 also send the HELP command for other information (like subscribing).

--

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

Author:
INET: ramakrishna.gv_at_db.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

--

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 Received on Tue Oct 17 2000 - 01:59:50 CDT